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.

| improve this question | |
  • Did you modify the location of the system databases during installation? – Thomas Stringer Sep 11 '12 at 13:15
  • No, I haven't modified any location. – PassionateAboutLife Sep 12 '12 at 9:29
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

| improve this answer | |
  • 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 – PassionateAboutLife Sep 12 '12 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 '12 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 '12 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 '12 at 16:11
  • I have added the error log from Detail.txt. – PassionateAboutLife Sep 18 '12 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.