SQL Service Pack 2 Failure To Install
Feb 24, 2007
I am a member of the Administrators group, and there is plenty of space in all hard drives, plus the temp directory is open for "everybody" to full-control it. Yet the Service Pack 2 database engine fails, all other components upgrade fine.
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3033
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29506
Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData for user SYSTEM. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
-
View 4 Replies
ADVERTISEMENT
Sep 14, 2007
Trying to install Service Pack 2 on a production server and it fails updating the Database Services with an 11032 error. Here is the summery log.
Time: 09/13/2007 20:43:21.980
KB Number: KB921896
Machine: SQLDATABASE
OS Version: Microsoft Windows Server 2003 family, Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.2.3042 x86
Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 STANDARD
Integration Services ENU SP2 9.00.3042.00 x86 STANDARD
SQL Server Native Client ENU 9.00.3042.00 x86
Client Components ENU SP2 9.2.3042 x86 STANDARD
MSXML 6.0 Parser ENU 6.10.1200.0 x86
SQLXML4 ENU 9.00.3042.00 x86
Backward Compatibility ENU 8.05.2004 x86
Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 11032
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Client Components
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : MSXML 6.0 Parser
Product Version (Previous): 1200
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
Unable to install Windows Installer MSP file
Exit Code Returned: 11032
View 4 Replies
View Related
May 3, 2006
Hi - using SQL Server Standard Edition (64Bit).
All of items of the service pack will install execpt for the Database Services.
The Details are:
"Unable to install Windows Installer MSP file"
Log Details Below
05/04/2006 08:18:42.327 ================================================================================
05/04/2006 08:18:42.327 Hotfix package launched
05/04/2006 08:18:43.827 Product discovery successfully completed during the install process for MSSQLSERVER
05/04/2006 08:18:43.827 SP Level check successfully completed during the install process for MSSQLSERVER
05/04/2006 08:18:43.827 Product language check successfully completed during the install process for MSSQLSERVER
05/04/2006 08:18:43.827 Product version check successfully completed during the install process for MSSQLSERVER
05/04/2006 08:18:43.827 Command-line instance name check completed during the install process
05/04/2006 08:18:43.827 Baseline build check completed during the install process
05/04/2006 08:19:12.014 Attempting to install instance: MSSQLSERVER
05/04/2006 08:19:12.060 Attempting to install target: REPORTS
05/04/2006 08:19:12.076 Attempting to stop service: SQLSERVERAGENT
05/04/2006 08:19:17.154 Successfully stopped service: SQLSERVERAGENT
05/04/2006 08:19:17.154 Attempting to stop service: MSSQLServer
05/04/2006 08:19:19.154 Successfully stopped service: MSSQLServer
05/04/2006 08:19:19.154 Attempting to check for locked files: sqlrun_sql.msp
05/04/2006 08:19:19.326 Attempting to check for locked files: \REPORTSe$7d39b5ebc15c1b5ee29a229c92b3HotFixSQLFilessqlrun_sql.msp
05/04/2006 08:19:19.326 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.out
05/04/2006 08:19:38.029 MSP returned 1602: The user cancels installation.
05/04/2006 08:19:38.169 Successfully checked file: \REPORTSe$7d39b5ebc15c1b5ee29a229c92b3HotFixSQLFilessqlrun_sql.msp
05/04/2006 08:19:38.169 Successfully opened registry key: SystemCurrentControlSetControlSession Manager
05/04/2006 08:19:38.169 Failed to read registry key: PendingFileRenameOperations
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnlhtml.dll
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsir5jp.dll
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftesql.exe
05/04/2006 08:19:38.169 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftepxy.dll
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftefd.exe
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsfte.dll
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLangWrbk.dll
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnkorwbrkr.dll
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinninfosoft.dll
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERefFTERef.dll
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnCHTBRKR.DLL
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnChsBrkr.dll
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMResources1033REPLRES.rll
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplrec.dll
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
plisapi.dll
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:WINDOWSassemblyGAC_64Microsoft.SqlServer.Replication9.0.242.0__89845dcd8080cc91Repl.dll
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources10332005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
plhtfin.sql
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
C:Program FilesMicrosoft SQL Server90COMqrdrsvc.exe
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program Files (x86)Microsoft SQL Server90COMsnapshot.exe
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM9.0.2047.0
C:Program FilesMicrosoft SQL Server90COMsqlmergx.dll
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM abldiff.exe
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMDISTRIB.exe
05/04/2006 08:19:38.185 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnDatabaseMail90.exe
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources30822005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources2052sqlevn70.rll
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10532005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1046sqlevn70.rll
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10432005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1042sqlevn70.rll
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10412005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1040sqlevn70.rll
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10362005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033sqlevn70.rll
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10312005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1028sqlevn70.rll
05/04/2006 08:19:38.185 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10332005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlacc~1.dll
05/04/2006 08:19:38.185 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlrwbin.dll
05/04/2006 08:19:38.201 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2.0.3609.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
05/04/2006 08:19:38.201 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLBOOT.dll
05/04/2006 08:19:38.201 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxplog70.dll
05/04/2006 08:19:38.201 Failed to read version information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnatchp~1.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
05/04/2006 08:19:38.201 Failed to read version information for the following file: C:Program Files (x86)Microsoft SQL Server90SharedResources10339.0.2047.0
C:Program Files (x86)Microsoft SQL Server90Sharedmsmdrdir.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedmsmdlocal.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedmsmdlocal.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedmsmdlocal.dll
05/04/2006 08:19:38.201 Failed to read version information for the following file: C:Program Files (x86)Common FilesSystemole db2.0.3609.0
C:Program Files (x86)Common FilesSystemole dbxmlrw.dll
05/04/2006 08:19:38.201 Failed to read version information for the following file: C:Program FilesCommon FilesSystemole db2.0.3609.0
C:Program FilesCommon FilesSystemole dbxmlrw.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlbrowser.exe
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlbrowser.exe
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlbrowser.exe
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedmsasxpress.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedmsasxpress.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedmsasxpress.dll
05/04/2006 08:19:38.201 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
05/04/2006 08:19:38.216 Failed to read version information for the following file: C:Program Files (x86)Microsoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml
05/04/2006 08:19:38.216 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
05/04/2006 08:19:38.216 Failed to read version information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnResources1033
E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnResources1033sqlcm.xml
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnResources1033SqlManager.rll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnResources1033SqlManager.rll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnResources1033SqlManager.rll
05/04/2006 08:19:38.216 Failed to read version information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnResources1033
E:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsinnSqlManager.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsinnSqlManager.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsinnSqlManager.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnatchparser90.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnatchparser90.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server (x86)90ToolsBinnatchparser90.dll
05/04/2006 08:19:38.216 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
05/04/2006 08:19:38.232 Failed to read version information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinnResources10332005.90.2047.0
E:Program FilesMicrosoft SQL Server (x86)90ToolsinnSQLSVC90.DLL
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: E:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
05/04/2006 08:19:38.232 Failed to read version information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinn2.0.3609.0
E:Program FilesMicrosoft SQL Server90ToolsBinnSQLdiag.exe
05/04/2006 08:19:38.232 Failed to read version information for the following file: E:Program FilesMicrosoft SQL Server90ToolsBinn2005.90.2047.0
C:Program Files (x86)Microsoft SQL Server90Sharedsqlsvc~1.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlsecacctchg.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlsecacctchg.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlsecacctchg.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlftacct.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlftacct.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlftacct.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedisacctchange.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedisacctchange.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedisacctchange.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsvrenumapi.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsvrenumapi.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsvrenumapi.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsvcsync.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsvcsync.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsvcsync.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
05/04/2006 08:19:38.232 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
05/04/2006 08:19:38.247 Failed to read version information for the following file: C:Program Files (x86)Microsoft SQL Server90Shared2005.90.2047.0
C:Program FilesMicrosoft SQL Server90SharedSqlBoot.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90Sharedsqlsqm.exe
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe
05/04/2006 08:19:38.247 Failed to read version information for the following file: C:Program Files (x86)Microsoft SQL Server90Shared9.0.2047.0
C:Program Files (x86)Microsoft SQL Server90Shareddbghelp.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90SharedSqlDumper.exe
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90SharedSqlDumper.exe
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90SharedSqlDumper.exe
05/04/2006 08:19:38.247 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0
C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Rmo.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_64Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_64Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_64Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll
05/04/2006 08:19:38.247 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll
05/04/2006 08:19:38.263 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90SharedSqlSAC.exe
05/04/2006 08:19:38.263 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90SharedMicrosoft.SqlSac.Public.dll
05/04/2006 08:21:12.933 Attempting to install file: sqlrun_sql.msp
05/04/2006 08:21:12.949 Attempting to install file: \REPORTSe$7d39b5ebc15c1b5ee29a229c92b3HotFixSQLFilessqlrun_sql.msp
05/04/2006 08:21:12.949 Creating MSP install log file at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log
05/04/2006 08:21:12.949 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
05/04/2006 08:21:12.949 Failed to read registry key: Debug
05/04/2006 08:22:23.775 MSP returned 1603: A fatal error occurred during installation.
05/04/2006 08:22:23.838 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
05/04/2006 08:22:23.838 Failed to read registry key: Debug
05/04/2006 08:22:23.838 Unable to install MSP file: \REPORTSe$7d39b5ebc15c1b5ee29a229c92b3HotFixSQLFilessqlrun_sql.msp
05/04/2006 08:22:23.838 The following exception occurred: Unable to install Windows Installer MSP file Date: 05/04/2006 08:22:23.838 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product Status Summary:
05/04/2006 08:22:23.885 Product: SQL Server Native Client (64-bit)
05/04/2006 08:22:23.885 SQL Server Native Client (64-bit) (RTM ) - Success
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: Setup Support Files (64-bit)
05/04/2006 08:22:23.885 Setup Support Files (64-bit) (RTM ) - Success
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: Database Services (64-bit)
05/04/2006 08:22:23.885 Database Services (64-bit) (RTM 1399 ENU) - Failure
05/04/2006 08:22:23.885 Details: Unable to install Windows Installer MSP file
05/04/2006 08:22:23.885 Analysis Services (64-bit) (SP1 2047 ENU) - Not Applied
05/04/2006 08:22:23.885 Reporting Services (64-bit) (SP1 2047 ENU) - Not Applied
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: Notification Services (64-bit)
05/04/2006 08:22:23.885 Notification Services (64-bit) (SP1 2047 ENU) - Not Applied
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: Integration Services (64-bit)
05/04/2006 08:22:23.885 Integration Services (64-bit) (SP1 2047 ENU) - Not Applied
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: Client Components (64-bit)
05/04/2006 08:22:23.885 Client Components (64-bit) (SP1 2047 ENU) - Not Applied
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: MSXML 6.0 Parser (64-bit)
05/04/2006 08:22:23.885 MSXML 6.0 Parser (64-bit) (RTM ) - Not Applied
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: SQLXML4 (64-bit)
05/04/2006 08:22:23.885 SQLXML4 (64-bit) (RTM ) - Not Applied
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: Backward Compatibility (64-bit)
05/04/2006 08:22:23.885 Backward Compatibility (64-bit) (RTM ) - Not Applied
05/04/2006 08:22:23.885
05/04/2006 08:22:23.885 Product: Microsoft SQL Server VSS Writer (64-bit)
05/04/2006 08:22:23.885 Microsoft SQL Server VSS Writer (64-bit) (RTM ) - Not Applied
05/04/2006 08:22:23.885
I have tried different log ons - Domain Administration / Administrator (but not a local administrator)
Each time I experience the same error.
Any suggestions?
Cheers
View 7 Replies
View Related
Dec 15, 1998
The instructions I printed out for installing SQL Server 7 state that NT SERVICE PACK 4 is a system requirement.
I have heard some comments that SP4 is buggy and shouldn't be used.
What should I do?
Thanks,
Judith
View 1 Replies
View Related
Mar 31, 2007
Hello world:
I'm having a problem installing Service Pack 2.
SQL Server Express still seems to work fine for me.
Here's the Log File entry from the latest failure.
Any ideas?
----------------------------------------------------------------------------
Time: 03/31/2007 08:53:18.968
KB Number: KB921896
Machine: XPS-0001
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 EXPRESS
Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS
**********************************************************************************
Products Disqualified & Reason
Product Reason
Express Database Services (SQLEXPRESS) Unable to start service
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 11042
Error Description : Unable to start service
----------------------------------------------------------------------------------
**********************************************************************************
Summary
Unable to start service
Exit Code Returned: 11042
View 2 Replies
View Related
May 18, 2007
I am new to Visual Studio (Pro Edition) and to SQL 2005. I installed the VS Pro, on Vista Business edition. Now I'm wondering if I need to install SQL-SP1 and SQL-SP2. Or do I install just SQL-SP2. Also which version of SQL-2005 is installed with Visual Studio? Standard, Express?
I would like to thank anyone in advance for your time to answer my question.
Just Me!
View 2 Replies
View Related
Mar 16, 2007
Windows Update Web Page indicates I have BOTH a
SUCCESS and FAILURE for
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue?
I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.
Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources
I include the logfile since it seems to convey useful informations to SQL Express experienced.
summary.txt logfile
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 03/13/2007 12:28:02.906
KB Number: KB921896
Machine: somejunk
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
Success
Exit Code Returned: 0
View 21 Replies
View Related
Jan 4, 2001
We are running SQL Server 7.0 on an NT Server in an NT environment. We have Service Pack 2 installed on the server hosting the database. Do we need the service pack installed on the client machines? Even if they only need client connectivity? Also does anyone know what fixes sp3 is supposed to fix? We are running our production environment without any known problems using sp2 and really dont want to disrupt it with sp3 if its not needed. Thanks in advance.
View 4 Replies
View Related
Mar 5, 2001
Has anyone had a problem when installing service pack 2 or 3 on SQL Server 7.0? I'm stuck at MDAC upgrade every time, had to 'end task'. Did select @@version afterwards, still on the old version. I didn't try service pack 1 yet.
I found the following page titled "Can't install SQL server service pack 1", but I'm unable to access.
http://www.swynk.com/archive3/4500/45001235457.asp
Any help will be appreciated. Please email me directly. Thanks in advance.
Phyllis
View 1 Replies
View Related
Apr 23, 2007
Hi, i have a clean install of VB2005 Express and it's accompanying SQL Server 2005 Express (yes i'm new to .net).
After installation i ran Windows Update and it found about 40mb of updates including SP1 for SQL Server. All installed correctly up to a reboot point, after which it continued with the update process.
When it reached SP2 (for SQL Server) it tried to install but just says "Updates were unable to be successfully installed" and "The following updates were not installed: Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)".
Now i have a permanent icon in my system tray which when clicked tries to do the install with the same result.
During the attempted install my floppy drive 'buzzes' a couple of times.
I'm running an AMD3000+ (64bit) cpu with Windows 2000 Pro SP4
As mentioned in another post (on the VB Install forum) my MyDocuments folder is on a networked pc which has caused other non related problems, not sure if this could be responsible for the error. It would seem unlikely as SQL SP1 installed without any errors.
Any help appreciated.
View 5 Replies
View Related
Feb 19, 2007
We are having trouble installing SQL2000 service pack 4 on our server. The package runs through and looks like it installs files to c:, but the install never asks us for any of the questions regarding the install of service pack 4. One issue we were thinking about was that MSDE was installed on the server also. We have a 2003 server with SQL 2000 sp3 (8.00.760)
View 6 Replies
View Related
Mar 9, 2007
Hi dear Devs!
I have a problem and now I am not sure, what I should do. "Microsoft Update" Service warned me, that a new critical update is ready for download. It was the update "SQL Server 2005 Express Edition Service Pack 2", I did that. Untill here no problem. The update "SQL Server 2005 Service Pack 2" was ready for download too. I have both versions on my computer "SQL Server 2005 Express Edition" and "SQL Server 2005 Developer Edition". The Express Edition came together with the install of "Visual Studio 2005 Team Suite", two days later I have installed the "SQL Server 2005 Developer Edition". Now to my problem, the "SQL Server 2005 Service Pack 2" installation failed in one point, the name of it is "Microsoft SQL Server Native Client". The whole installation was not interrupted, it told me only at end of this updating that this point wasn't successful - I saw it in the "Summary.txt". While the install I saw that this "Microsoft SQL Server Native Client" was twice in the list of the Service Pack 2 Update. Both of these points had the identical name. In short words, I saw that the SP2 wanted made an update at "Microsoft SQL Server Native Client" twice. I thought, it is because these two editions of "SQL Server 2005" on my computer. But the result is, that the SP2 couldn't update the second 'Native Client'. I checked it in the 'Software' section in 'Control Panel' and I have really two installations of this "Microsoft SQL Server Native Client". My question is, is that normal, is that because I have two "SQL Server 2005" Editions on my computer? And what can I do with this failed part of the SP2. Can someone help me with this failed 'Native Client' SP2 update? I were really happy, if someone could give me the best solution to fix this problem.
Thank you very much for your help and answers
Arzu Bazman · «US DEV United Systems»
View 1 Replies
View Related
Jul 20, 2007
I'm trying to install Service Pack 4 to our default instance of SQL Server 2000 with SP3a, on a Windows 2003 Server, which also has a named instance of SQL Server 2005 on it and a named instance of SQL Server 2000 with SP4.
The installation appears to be running just fine, but MUCH too quickly. The last window appears stating something along the lines of 'Updating Active X components'. I'm expecting the scripts to run to update my system stored procedures, etc., but that never occurs. The installer just quits.
No errors in the Windows logs, nor in SQL, and no C:WindowsSQLSP.log file.
I tried the installation again, but this time used a different copy of the service pack 4 installer, with the same results, and again no SQLSP.log file.
Since I was going to remove the named instance of SQL Server 2000 anyway, I verified that my SP4 installer was good by uninstalling the named instance of SQL Server (the one with SP4 already), reinstalling a named instance of SQL Server 2000, and reapplying SP4 to this named instance. Everything went flawlessly.
I then tried reapplying SP4 to the default instance of SQL Server 2000, and this time a SQLSP.log file was finally generated. In the error log, the last entries are:
19:10:03 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1SQLDBR~1.EXE sqldbreg2.exe -RegServer
19:10:04 An error occurred while setting the registry value for: SoftwareMicrosoftMSSQLServerMSSQLServer
19:10:04 Could not restore AuditLevel registry key
19:10:04 Action CleanUpInstall:
19:10:04 Installation Failed.
I confirmed that the service accounts that are running SQL Server both have local administrative access to the server (which may or may not matter), and that they are both sysadmin, so I don't think it's a permissions issue to the registry. I've also verified that the account I was using to run the SP installation also has local admin access on that box.
So, I compared my HKLMSoftwareMicrosoftMSSQLServerMSSQLServer registry entry from our production server to the one on the test server, I see that our test server's entry is completely empty. On production there are numerous subkeys, such as CurrentVersion and RPCNetLib.
I'm planning on copying the registry entries from production to test. Should this be sufficient, or are there other things I should look out for?
View 10 Replies
View Related
Jan 3, 2000
Hi!
I am totally new to this but have access to a SQL Server (version 6.5) and am looking at the processes used on it to learn. It is being used as a reporting server and have run into a wierd problem:
We discovered that it did not have any service packs at all on it so we applied SP4 to it (Microsoft SQL Server 6.50 - 6.50.281 (Intel X86) ).
Now what took a few minutes takes **hours** to do. In particular, a particular SELECT INTO statement that has a few joins in the WHERE clause is the problem. I changed the code from the SELECT INTO and created the table and used an INSERT...INTO statement. This did not help.
This process has ran successfully on the SQL Server without any service packes for over two years and now with the SP4 applied, it takes forever.
The SQL statement that is used has also been working fine for the same amount of time. One thing that I notice with it is that the join syntax uses *= instead of the more current way (LEFT OUTER JOIN). We are also clearing the logs before running the statement to make sure the space is available. This is run against a header table with around 600,000 rows and a detail table with approx 1,500,000 rows.
Any help would be greatly appreciated!
Scott
View 1 Replies
View Related
Jan 29, 2004
I'm trying to upgrade my SQL Server 2000 Developer's Edition to sp3a, I'm following the instructions.
I receive the following message:
Invalid product code was found. Check if product is installed.
I have installed this from CD I have with me. I followed instruction on http://support.microsoft.com/?kbid=311762
but I don't see product ID/code !!!!!
I have installed default instance (MSSQLSERVER) on my machine. How do I do Update to Service Pack 3a.
I can Install "Database Components "
Downloadable file name: SQL2KSP3.exe SP3a
but I can't install "SQL Server 2000 Desktop Engine(MSDE) "
Downloadable file name: SQL2kdesksp3.exe SP3a.
Any help?
Thank you.
View 1 Replies
View Related
Mar 5, 2007
I am attempting to install SQL Server 2005 Developer Edition (from CD) on my IBM PC with XP Operating System. During set up, I get a error message (see below) telling me about a Service Pack requirement. When I click on the link provided in the error message, it does not lead to any service pack download.
I'm trying to read thru these forum posts, it seems that there is a service pack that I need to download after installing SQL Server 2005. But how can I install the pack after when I can't install SQL Server. Any help would be greatly appreciated. Below is more information about the version of windows my PC has.
My PC: Windows Version 5.1 (Build 2600.xpsp2.030422-1633:Service Pack 1)
Error message from install program:
Operating System Service Pack Level Requirement. (Error)
Messages
Operating System Service Pack Level Requirement.
"The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again."
View 1 Replies
View Related
May 25, 2007
I have Windows XP Professional Version 2002 Service Pack2.
I Have:
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Service Pack is failing to Install CLIENT COMPONENTS; message is:
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 29549
Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
Error message: The system cannot find the file specified.
Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
This situation, I am guessing, also preventing me to run import/export from the SQLServer Client.
Any help is appreciated. Thanks.
View 6 Replies
View Related
Nov 22, 2007
I am continually prompted to download & install this SP by the windows update utility but it always fails to install it.
I have XP SP2. No error msg is provided. I do not have ACT! installed. I do have Oracle 10g Expr. Ed installed. Competitive jealousy?
I found this online:
Important notes about the cumulative hotfix package
€¢ You must enable the SQL Server Management Object (SMO) extended stored
procedures and the SQL Server Distributed Management Object (SQL-DMO)
extended stored procedures before you install the cumulative hotfix package.
Where does one enable SMO & SQL-DMO?
I looked in the summary log file in the Hotfix directory and it says that the problem is
that SQL Express cant be started. See below.
I went into the SQL Configuration Mgr and tried to start it and it fails to start.
No reason given. Now what?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 11/22/2007 09:44:37.546
KB Number: KB921896
Machine: TOSHIBA-ROGER
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS
**********************************************************************************
Products Disqualified & Reason
Product Reason
Express Database Services (SQLEXPRESS) Unable to start service
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 11042
Error Description : Unable to start service
----------------------------------------------------------------------------------
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
**********************************************************************************
Summary
Unable to start service
Exit Code Returned: 11042
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
View 4 Replies
View Related
Oct 7, 2015
If I install a new named instance of SQL Server 2008 R2 on a machine that already has 3 named instances that are upgraded to service pack 3, will the install of the new instance overwrite any of the current SP3 files? Will I have to re-apply SP 3 to the existing instances?
View 4 Replies
View Related
May 17, 2007
I tried to uninstall SQL Server 2005 and it was failed.
I tried to install SP2 for SQL Server 2005, and it was failed too!
Here are the log file SUMMARY.TXT (is it enough?).
Can anyone tell me what the problem is?
Time: 05/17/2007 16:51:41.483
KB Number: KB921896
Machine: XXXXXX
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : D:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 1332
Error Description : *** Shared String ID 1332 Not Found ***
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1332
View 1 Replies
View Related
Mar 16, 2007
yestarday there is an article released about the service pack for the service pack 2 for sqlserver wo downloaded before mar 5 , 2007.
but to my development server i didn't download sp2 yet. Ifs it safe to download the sp2 for sqlserver 2005 enterprise edition now??
thanks,
View 14 Replies
View Related
Apr 8, 2008
i have an acer extensa e series pc, i have the service pack 2, it keeps cuming up automatic updates for it, but it keeps failing, the yellow shield is there all the time + when i turn comp off it says installing update 1 of 1 which i know is the server pack, i phoned microsoft was on the phone for 3 hours n they turned round + said because i am not using a business computer dont need it, please help me going crazy, the yellow shield never goes away AAAARRRRGGGGHHHHH. thx
View 21 Replies
View Related
Oct 10, 2007
Hi All,
We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.
Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.
We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.
Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!
Error:
An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.
Regards,
Joseph
View 29 Replies
View Related
Feb 11, 2002
Hi, sorry but I don´t speak english, my problem:
I install Service Pack 3 to Sql Server 7, but the Store Procedure are missing now, please help me.
View 1 Replies
View Related
Mar 6, 2002
Any one know what is the lasted service pack for SQL server 6.5
Thank you very much.
Judy
View 1 Replies
View Related
Mar 6, 2002
Any one here knows what is the lastest service pack for SQL server 6.5?
Thank you very much.
Judy
View 1 Replies
View Related
Apr 23, 2001
Does Anyone know if there is a way to verify the SQL Service Pack Version on 7.0 on Windows 2000 Advanced server?
I'm getting this results for select @@version
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
Thanks
Rea
View 2 Replies
View Related
Jun 18, 2001
I installed Service Pack 5 on SQL 7.0 successfully, but when I go back to run @@version, it gives me Service Pack 2 which is the old pack. Does anyone know why and had an experience with this?? Thanks wonderful people!!!
View 4 Replies
View Related
Aug 9, 2001
Has anyone out loaded sp1 that can tell me if there are any issues that I need to be aware of?
View 1 Replies
View Related
Jan 2, 2001
I have a cluster server, with SP3 coming out I wanted to upgrade the SP2 I have right now, when I start SP3 installation it starts and quickly exits from the program. DO I need to uncluster the server before applying SP3? or there is a way arround it?
View 1 Replies
View Related
Jul 31, 2000
has anyone had this experience before after we installed service pack 2 our jobs are taking about 10hrs, some run it says it's succesfull but it didn't update the tables.
View 2 Replies
View Related
Dec 18, 2000
Hello,
I'm installing SQL Server 7.0 on my server, which service pack is good to intall? SP4, I've heard has many bugs? Pls. guide me.
Thanks.
Sejal
View 1 Replies
View Related
Apr 10, 2000
How do I determine which SP has been applied to a server.
@@version returns 'Microsoft SQL Server 6.50 - 6.50.416'
Thanks.
View 1 Replies
View Related
