You cannot install SQL Server 2005 Service Pack 2 when the database file of the Resource database is not in the same folder as the log file of the Resource database

Article translations Article translations
Article ID: 947989 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

Symptoms

You cannot install Microsoft SQL Server 2005 Service Pack 2 (SP2). Additionally, the following error message is logged in the Summary.txt file:
Product : Database Services (InstanceName)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQL$InstanceName' could not be started. Verify that you have sufficient privileges to start system services. The error code is (1067) The process terminated unexpectedly.
Note The Summary.txt file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Hotfix
This problem may also happen when you install a cumulative update or a hotfix to SQL Server 2005.

This problem occurs when the database file of the Resource database (Mssqlsystemresource.mdf) is not in the same folder as the log file of the Resource database (Mssqlsystemresource.ldf).

Cause

This problem occurs because SQL Server 2005 SP2 Setup and the hotfix installers require that the database file of the Resource database is in the same folder as the log file of the Resource database.

Workaround

To work around this problem, move the log file of the Resource database to the same folder as the database file of the Resource database. Then, start the Setup program again.

For more information about how to move the log file of the Resource database, see the "Moving the master and Resource Databases" section of the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms345408.aspx

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 947989 - Last Review: November 1, 2013 - Revision: 3.0
Applies to
  • Microsoft SQL Server 2005 Service Pack 2
Keywords: 
kbnosurvey kbarchive kbexpertiseadvanced kbtshoot kbprb KB947989

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com