Monday, March 26, 2012

Problems With SQL 2005 SP1 (x64)

Hi,

After installing SP1 onto our SQL x64 2005 box (running Server 2003 x64 R2), I have come across two problems. The first is that the install seems to fail for database services (and I see I'm not the only one), declaring the following:

04/21/2006 11:31:59.773 ================================================================================
04/21/2006 11:31:59.773 Hotfix package launched
04/21/2006 11:32:01.351 Product discovery successfully completed during the install process for MSSQLSERVER
04/21/2006 11:32:01.351 SP Level check successfully completed during the install process for MSSQLSERVER
04/21/2006 11:32:01.351 Product language check successfully completed during the install process for MSSQLSERVER
04/21/2006 11:32:01.351 Product version check successfully completed during the install process for MSSQLSERVER
04/21/2006 11:32:01.351 Command-line instance name check completed during the install process
04/21/2006 11:32:01.351 Baseline build check completed during the install process
04/21/2006 11:32:29.538 Attempting to install instance: MSSQLSERVER
04/21/2006 11:32:29.600 Attempting to install target: my_server
04/21/2006 11:32:29.616 Attempting to stop service: SQLSERVERAGENT
04/21/2006 11:32:34.631 Successfully stopped service: SQLSERVERAGENT
04/21/2006 11:32:34.631 Attempting to stop service: MSSQLServer
04/21/2006 11:32:36.631 Successfully stopped service: MSSQLServer
04/21/2006 11:32:36.631 Attempting to check for locked files: sqlrun_sql.msp
04/21/2006 11:32:36.663 Attempting to check for locked files: \\my_server\d$\39e3f3124a1ef45cc9e9\HotFixSQL\Files\sqlrun_sql.msp
04/21/2006 11:32:36.663 Creating MSP locked file check log at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.out
04/21/2006 11:32:51.787 MSP returned 1602: The user cancels installation.
04/21/2006 11:32:51.866 Successfully checked file: \\my_server\d$\39e3f3124a1ef45cc9e9\HotFixSQL\Files\sqlrun_sql.msp
04/21/2006 11:32:51.881 Successfully opened registry key: System\CurrentControlSet\Control\Session Manager
04/21/2006 11:32:51.881 Failed to read registry key: PendingFileRenameOperations
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ThaWBrkr.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\query.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nls400.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\nlhtml.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msir5jp.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftesql.exe
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftepxy.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msftefd.exe
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\msfte.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\LangWrbk.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\korwbrkr.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\infosoft.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\FTERef\FTERef.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\CHTBRKR.DLL
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ChsBrkr.dll
04/21/2006 11:32:51.881 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\Resources\1033\REPLRES.rll
04/21/2006 11:32:51.881 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\replrec.dll
04/21/2006 11:32:51.881 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\rplisapi.dll
04/21/2006 11:32:51.881 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\WINDOWS\assembly\GAC_64\Microsoft.SqlServer.Replication\9.0.242.0__89845dcd8080cc91\Repl.dll
04/21/2006 11:32:51.881 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.DataStorage\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.DataStorage.dll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Common Files\Microsoft Shared\Database Replication\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\rplhtfin.sql
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\
C:\Program Files\Microsoft SQL Server\90\COM\qrdrsvc.exe
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files (x86)\Microsoft SQL Server\90\COM\snapshot.exe
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\9.0.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\sqlmergx.dll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\tabldiff.exe
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\COM\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\COM\DISTRIB.exe
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\DatabaseMail90.exe
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\3082\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\2052\sqlevn70.rll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1053\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1046\sqlevn70.rll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1043\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1042\sqlevn70.rll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1041\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1040\sqlevn70.rll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1036\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\sqlevn70.rll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1031\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1028\sqlevn70.rll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlacc~1.dll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlrwbin.dll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2.0.3609.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlsvc90.dll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLBOOT.dll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xplog70.dll
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\batchp~1.dll
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAGENT90.RLL
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE
04/21/2006 11:32:51.897 Failed to read version information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\Resources\1033\9.0.2047.0
C:\Program Files (x86)\Microsoft SQL Server\90\Shared\msmdrdir.dll
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/21/2006 11:32:51.897 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\msmdlocal.dll
04/21/2006 11:32:51.912 Failed to read version information for the following file: C:\Program Files (x86)\Common Files\System\ole db\2.0.3609.0
C:\Program Files (x86)\Common Files\System\ole db\xmlrw.dll
04/21/2006 11:32:51.912 Failed to read version information for the following file: C:\Program Files\Common Files\System\ole db\2.0.3609.0
C:\Program Files\Common Files\System\ole db\xmlrw.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\msasxpress.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\msasxpress.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\msasxpress.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\msasxpress.dll
04/21/2006 11:32:51.912 Failed to read version information for the following file: C:\Program Files (x86)\Microsoft.NET\ADOMD.NET\90\en\Microsoft.AnalysisServices.AdomdClient.xml
04/21/2006 11:32:51.912 Failed to read version information for the following file: C:\Program Files\Microsoft.NET\ADOMD.NET\90\en\Microsoft.AnalysisServices.AdomdClient.xml
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft.NET\ADOMD.NET\90\Microsoft.AnalysisServices.AdomdClient.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.AnalysisServices.AdomdClient\9.0.242.0__89845dcd8080cc91\Microsoft.AnalysisServices.AdomdClient.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft.NET\ADOMD.NET\90\Microsoft.AnalysisServices.AdomdClient.dll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.AnalysisServices.AdomdClient\9.0.242.0__89845dcd8080cc91\Microsoft.AnalysisServices.AdomdClient.dll
04/21/2006 11:32:51.912 Failed to read version information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\Resources\1033\
C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\Resources\1033\sqlcm.xml
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/21/2006 11:32:51.912 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\sqlcm.xml
04/21/2006 11:32:51.912 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\SqlManager.rll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SqlManager.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\batchparser90.dll
04/21/2006 11:32:51.928 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\Resources\1033\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAM90.DLL
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\SQLAgentMail90.rll
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/21/2006 11:32:51.928 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLSVC90.DLL
04/21/2006 11:32:51.928 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\xmlrw.dll
04/21/2006 11:32:51.944 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Tools\Binn\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\OSQL.EXE
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlsvcsync.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlsvcsync.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlsvcsync.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\isacctchange.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\isacctchange.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\isacctchange.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsvcsync.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsvcsync.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsvcsync.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsecacctchg.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/21/2006 11:32:51.944 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlftacct.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\isacctchange.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\svrenumapi.dll
04/21/2006 11:32:51.959 Failed to read version information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\2005.90.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\SqlBoot.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlsqm.exe
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlsqm.exe
04/21/2006 11:32:51.959 Failed to read version information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\9.0.2047.0
C:\Program Files (x86)\Microsoft SQL Server\90\Shared\dbghelp.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/21/2006 11:32:51.959 Failed to read version information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\9.0.2047.0
C:\Program Files\Microsoft SQL Server\90\Shared\dbghelp.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\90\Shared\SqlDumper.exe
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.Rmo\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.Rmo.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.AnalysisServices\9.0.242.0__89845dcd8080cc91\Microsoft.AnalysisServices.DLL
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.DataWarehouse.Interfaces\9.0.242.0__89845dcd8080cc91\Microsoft.DataWarehouse.Interfaces.DLL
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_64\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_64\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_64\Microsoft.SqlServer.BatchParser\9.0.242.0__89845dcd8080cc91\microsoft.sqlserver.batchparser.dll
04/21/2006 11:32:51.959 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SqlEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SqlEnum.dll
04/21/2006 11:32:51.975 Failed to read associated hotfix build information for the following file: C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.Smo\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.Smo.dll
04/21/2006 11:32:51.975 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\SqlSAC.exe
04/21/2006 11:32:51.975 Failed to read associated hotfix build information for the following file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\Microsoft.SqlSac.Public.dll
04/21/2006 11:32:52.006 Attempting to install file: sqlrun_sql.msp
04/21/2006 11:32:52.022 Attempting to install file: \\my_server\d$\39e3f3124a1ef45cc9e9\HotFixSQL\Files\sqlrun_sql.msp
04/21/2006 11:32:52.022 Creating MSP install log file at: C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log
04/21/2006 11:32:52.022 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/21/2006 11:32:52.022 Failed to read registry key: Debug
04/21/2006 11:34:17.130 MSP returned 1603: A fatal error occurred during installation.
04/21/2006 11:34:17.146 Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
04/21/2006 11:34:17.146 Failed to read registry key: Debug
04/21/2006 11:34:17.146 Unable to install MSP file: \\my_server\d$\39e3f3124a1ef45cc9e9\HotFixSQL\Files\sqlrun_sql.msp
04/21/2006 11:34:17.146 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/21/2006 11:34:17.146 File: \depot\sqlvault\setupmain\setup\sqlse\sqlsedll\copyengine.cpp Line: 856
04/21/2006 11:34:17.177
04/21/2006 11:34:17.177 Product Status Summary:
04/21/2006 11:34:17.177 Product: SQL Server Native Client (64-bit)
04/21/2006 11:34:17.177 SQL Server Native Client (64-bit) (RTM ) - Success
04/21/2006 11:34:17.177
04/21/2006 11:34:17.177 Product: Setup Support Files (64-bit)
04/21/2006 11:34:17.177 Setup Support Files (64-bit) (RTM ) - Success
04/21/2006 11:34:17.177
04/21/2006 11:34:17.177 Product: Database Services (64-bit)
04/21/2006 11:34:17.177 Database Services (64-bit) (SP1 2047 ENU) - Failure
04/21/2006 11:34:17.177 Details: Unable to install Windows Installer MSP file
04/21/2006 11:34:17.177 Analysis Services (64-bit) (SP1 2047 ENU) - Not Applied
04/21/2006 11:34:17.177 Reporting Services (64-bit) (SP1 2047 ENU) - Not Applied
04/21/2006 11:34:17.177
04/21/2006 11:34:17.177 Product: Notification Services (64-bit)
04/21/2006 11:34:17.177 Notification Services (64-bit) (SP1 2047 ENU) - Not Applied
04/21/2006 11:34:17.177
04/21/2006 11:34:17.177 Product: Integration Services (64-bit)
04/21/2006 11:34:17.177 Integration Services (64-bit) (SP1 2047 ENU) - Not Applied
04/21/2006 11:34:17.177
04/21/2006 11:34:17.177 Product: Client Components (64-bit)
04/21/2006 11:34:17.177 Client Components (64-bit) (SP1 2047 ENU) - Not Applied
04/21/2006 11:34:17.193
04/21/2006 11:34:17.193 Product: MSXML 6.0 Parser (64-bit)
04/21/2006 11:34:17.193 MSXML 6.0 Parser (64-bit) (RTM ) - Not Applied
04/21/2006 11:34:17.193
04/21/2006 11:34:17.193 Product: SQLXML4 (64-bit)
04/21/2006 11:34:17.193 SQLXML4 (64-bit) (RTM ) - Not Applied
04/21/2006 11:34:17.193
04/21/2006 11:34:17.193 Product: Backward Compatibility (64-bit)
04/21/2006 11:34:17.193 Backward Compatibility (64-bit) (RTM ) - Not Applied
04/21/2006 11:34:17.193
04/21/2006 11:34:17.193 Product: Microsoft SQL Server VSS Writer (64-bit)
04/21/2006 11:34:17.193 Microsoft SQL Server VSS Writer (64-bit) (RTM ) - Not Applied
04/21/2006 11:34:17.193

This has not caused any initial problems, as the database service will still start and everything appears ok.

...however, the second problem this have given me, is that the Integration Services service will not start (errors with a timeout). I'm having a number of maintenance jobs fails as a result of this.

Let me know what information you would like, and I'll be right back with it.

Cheers,

Darren

Just managed to pull this out of a log file:

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 SRVHAM14 as sysadmin
Launch SQL statement USE master
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\sysdbupg.sql
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\DbEngine_hotfix_install.sql
Launch script file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Install\repl_hotfix_install.sql
Stop service MSSQLSERVER
MSI (s) (20:A4) [13:56:22:544]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 1 for SQL Server Database Services 2005 (64-bit) 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.

"Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission."

:/
|||I haven't had a problem across a suite of x64 installs here at the bank. Disk space can be an issue as the SP install seems to require a lot. You can also run into problems if you have removed the security groups that SQL installs - there's another thread on this on this forum.|||Thanks for the reply. The file permissions haven't been touched, and disk space certainly isnt an issue (doesn't even come close to filling any partition).

I've dropped some more information into the bottom of this thread (guy seemed to be having the same problem as me)

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=318632&SiteID=1

|||This is the third forum message I've seen with this message, so hopefully we can solve it quickly.

After you get the 'dm_exec_query_resource_semaphores' error and the installer cancels out, can you try to apply SP1 a second time? Does that attempt also fail with the same message?

Thanks,
Samuel Lester (MSFT)

|||Yes, and yes :)
|||

Darren

Can you upload the first setup log file that failed with this error?

Thanks

Vishal

|||

We are having the same problem with Integration Services timing out after installing SP1, but we are running the 32-bit standard version.

I had to uninstall SQL 2005. I'm installing it again now. Should be done in about 6 hours.

|||

Hi

I had the same problem and found the solution in KB 918695

"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."

|||

Hello all...

Just to add my experience; in the process of setting up several servers, I encountered the same, however on one system, it was a clean installation and on the other, SQL had been installed/removed and re-installed (to support .NET 3.0).

Since I had the time and option and knew that the Master Database had not been moved, the corrective action is to:

a) Click Cancel on the database update locked message (the process will continue) - this lock message will occur on both the Database and again on Analysis Services

b) Let the entire process complete

c) Do not reboot - open Administrative Tools > Services and perform a Restart on the Microsoft SQL Server service

d) Rerun SP1

Regards,

David Sterling - Sterling International Consulting Group
www.sterling-consulting.com

Posted by chimpanzeenmqp at 9:58 AM
Labels: , , , , , , , , , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)