Microsoft KB Archive/918695

= You may experience a failure when you install SQL Server 2005 Service Pack 1 on an instance of SQL Server 2005 =

Article ID: 918695

Article Last Modified on 2/26/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Service Pack 1

-



Bug #: 433207 (SQLBUDT)



SYMPTOMS
When you install Microsoft SQL Server 2005 Service Pack 1 (SP1) on an instance of SQL Server 2005, you may experience a failure when the SQL Server 2005 SP1 Setup program upgrades the database services.

If you examine the SQL Server 2005 SP1 SQL9_Hotfix_KB913090_sqlrun_sql.msp.log installation log file, you notice error messages that resemble the following:

Error message 1

Doing Action: CommitSqlUpgrade

PerfTime Start: CommitSqlUpgrade : Fri Apr 28 10:41:04 2006



There was a failure during installation search up in this log file for this message:

SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.



PerfTime Stop: CommitSqlUpgrade : Fri Apr 28 10:41:04 2006

Gathering darwin properties for failure handling.



MSI (s) (98:98) [10:41:05:637]: Transforming table InstallExecuteSequence.

MSI (s) (98:98) [10:41:05:637]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038

MSI (s) (98:98) [10:41:05:637]: Transforming table InstallExecuteSequence.

MSI (s) (98:98) [10:41:05:637]: Transforming table InstallExecuteSequence.

MSI (s) (98:98) [10:41:05:637]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038

MSI (s) (98:98) [10:41:05:637]: Transforming table InstallExecuteSequence.

MSI (s) (98:98) [10:41:05:637]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038

MSI (s) (98:98) [10:41:05:637]: Transforming table InstallExecuteSequence.

MSI (s) (98:98) [10:41:05:637]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038

Action ended 10:41:05: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3. Action ended 10:41:05: INSTALL. Return value 3.

Error message 2

Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

Property(S): UpgradeInstruction = Connect to SQL instance \  as sysadmin

Launch SQL statement USE master

Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Install\sysdbupg.sql

Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Install\DbEngine_hotfix_install.sql

Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Install\repl_hotfix_install.sql

Stop service MSSQL$INST2

MSI (s) (98:98) [10:41:07:137]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log.

MSI (s) (98:98) [10:41:07:137]: Product: Microsoft SQL Server 2005 -- Configuration failed.

Note This problem does not occur when you install SQL Server 2005 Service Pack 2 (SP2).



CAUSE
The problem occurs because the master database file is not in the same location as the Resource database file for the instance of SQL Server 2005 on which you install SQL Server 2005 SP1. You may have previously moved the master database from its originally installed location. When you move the master database, you must make sure that the master and Resource database files are located in the same folder. If you only move the master database files, you experience this problem when you install SQL Server 2005 SP1. This problem occurs because the location of the master and Resource database files is inconsistent.



WORKAROUND
To work around this problem, make sure that the master and Resource database files are located in the same folder for a particular instance of SQL Server 2005 before you install SQL Server 2005 SP1.



You can use a tool, such as Sysinternals Process Explorer (Procexp.exe), to determine the location of the master and Resource database files that are currently used by the instance of SQL Server 2005.

To obtain Process Explorer, visit the following Sysinternals Web site:

http://www.microsoft.com/technet/sysinternals/utilities/ProcessExplorer.mspx

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

To determine the location of the master and Resource database files in Process Explorer, follow these steps:  In Process Explorer, locate the Sqlservr.exe process in the Process pane. On the View menu, click Show Lower Pane. In the lower pane of Process Explorer, make sure that the Name column is displayed.

If the Name column is not displayed, follow these steps:  On the View menu, click Select Columns, and then click the Handle pane.</li> Click to select the Name check box, and then click OK.</li></ol> </li> In the lower pane of Process Explorer, click Type to sort handles by type.</li> For the File type items, search the Name column for the path of the file Mssqlsystemresource.mdf file. This path is the path of the Resource database file. You can also search the Name column for the path of the Master.mdf file. This path is the path of the master database file.</li></ol>

If these paths are different, you must move the database files to the same folder.

The Resource database depends on the location of the master database. If you move the master database, you must also move the Resource database to the same location as the master database file. Do not put the Resource database in either compressed or encrypted NTFS file system folders. If you do this, you hinder performance and prevent upgrades.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

MORE INFORMATION
If you experience this problem, you will have two copies of the Resource database files on the computer for each instance that experiences this problem. If you use a utility such as Sysinternals FileMon (Filemon.exe) to monitor the installation of SQL Server 2005 SP1, you will notice the following behavior: <ul> The Setup program updates the Resource database files in the folder where the master database exists. The following information appears in the main FileMon window:

10:39:49 AM msiexec.exe:1944 IRP_MJ_WRITE C:\DATA\mssqlsystemresource1.mdf SUCCESS Offset: 22572523 Length: 24052

</li> The Sqlservr.exe process loads the master database from the new location when the process starts during setup. The following information appears in the main FileMon window:

10:40:56 AM sqlservr.exe:2788 IRP_MJ_READ C:\DATA\master.mdf SUCCESS Offset: 1900544 Length: 65536

</li> The Sqlservr.exe process loads the Resource database from the original location. This original location contains the older version of the Resource database files. The following information appears in the main FileMon window:

10:40:56 AM sqlservr.exe:2788 IRP_MJ_READ C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mssqlsystemresource.mdf SUCCESS Offset: 1245184 Length: 65536

</li></ul>

This behavior causes a mismatch between the version of the Resource database that is used and the version of the Resource database that the Setup program assumes is currently used.

To obtain FileMon, visit the following Sysinternals Web site:

http://www.microsoft.com/technet/sysinternals/utilities/filemon.mspx

Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

<div class="references_section">