3

Sql server 2008 R2 installation fails with the below error message in the log message,

This is a part of the sql server log

Starting up database 'msdb'. Error: 17204, Severity: 16, State: 1. FCB::Open failed: Could not open file e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1. OS error: 21(failed to retrieve text for this error. Reason: 1815).

Has anyone come across such an issue. Please help on how to resolve this issue.

EDIT: the sql server error log can be found at http://pastebin.com/TED7vJWX

EDIT: This is the latest log, 2012-09-20 14:34:29.74 spid6s Starting up database 'mssqlsystemresource'.

2012-09-20 14:34:29.78 spid6s The resource database build version is 10.50.1600. This is an informational message only. No user action is required.

2012-09-20 14:34:30.51 spid6s Error: 15209, Severity: 16, State: 1.

2012-09-20 14:34:30.51 spid6s An error occurred during encryption.

Same as before.

2
  • Did you modify the location of the system databases during installation? Sep 11, 2012 at 13:15
  • No, I haven't modified any location. Sep 12, 2012 at 9:29

1 Answer 1

1

This is a known issue which has several causes:

  1. The first thing to check is your permissions on local machine:
  2. Are You a local Administrator?
  3. Is there a group policy that might prevent you from installing \ debugging?

If these do not resolve the problem in your case, and you have verified the required permissions, please provide more info:

  1. What parameters do you use during installation (beside the default ones)?
  2. Which Edition of SQL Server are You installing?
  3. Do You use Default instance name?
  4. On which O/S are You installing?

EDIT:
Next steps: 1. open the folder ":\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
2. Find a file named Detail.txt
3. This file has a complete log, You need to find the FIRST error that occured during installation.
4. Paste it here, only the part with the error.

EDIT:
Added Solution to comments, waiting to hear if the problem is solved

12
  • Thanks for the quick response. I have checked, there are no issues with permissions.The installation is started with Admin privileges. Below is the info you have asked for: Parameters during installation: /ACTION=INSTALL /UIMODE=AutoAdvance /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLEngine /INSTANCENAME=<NAME> /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLSYSADMINACCOUNTS="BUILTIN\Administrators" /ADDCURRENTUSERASSQLADMIN="True" /NPENABLED=1 /TCPENABLED=1 /SECURITYMODE=SQL /SAPWD=<Password> Sql Server Version:Microsoft SQL Server 2008 R2 (RTM) We are using a named instance. OS-WindowsXP Sep 12, 2012 at 9:24
  • It still might be a matter of security, please make sure You have Debug Rights as stated here: support.microsoft.com/kb/2000257
    – Roi Gavish
    Sep 12, 2012 at 12:58
  • Take a look at The group policy item Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Debug If You are a member of local administrators group but the group is not a member of the debug group, installation will fail.
    – Roi Gavish
    Sep 12, 2012 at 13:08
  • The Error Log You added is showing that SQL Server is trying to start and fails. That is because installation did not complete successfully, and did not get to the part where it sets the database path inside master database. Please post the log file "Detail.txt" from the folder "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log" (find the relevant subfolder for the last installation attempt)
    – Roi Gavish
    Sep 13, 2012 at 16:11
  • I have added the error log from Detail.txt. Sep 18, 2012 at 1:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.