I understand that from Sql Server 2005 service packs should be able to be applied with no disruption, is this true ?
I want to install service pack 1 on our 2005 instances but i cannot find any documentation in BOL or the official SP1 website on installation steps.
Is there no thing i need to do when i install the service pack ? I am just weary of applying a service pack to the instance while users are woking etc.
I find it very starnge that they are no reccomended steps to follow before applying th service pack. If anyone has a link to this i would really appreciate it as i cannot find ot anywhere ?
I have several installations of SQL Server with identical configurations on different computers. Is it possible to develop an unattented installation that includes SQL Server Sevice Pack, and how to do that? Thanks.
After I installed Sql Server, I ran windows update. it downloaded the service pack 1 fine, but during the installation, it just frozed at the middle, so I cancelled it, but the window froze, so I had to end process. Is my sql server messed up? I kind of tested it, and it seems to work? Is it ok if I just download SP 1 and reinstall it?
I am trying to install Service pack 5a and post SP5a patches. But how many ever times I try to, it says that the sa password is incorrect. has any one encountered this problem before? If so what needs to be done. Help appreciated.
It seems that all of a sudden my companies clients are running into problems with the installation of servicepack 5a on SQL Server 6.5 workstations. The servicepack is apparently getting to the point where it checks the master DB and then Chkmast.exe returns a value of 0 which seems to indicate that there is not enough space in the master DB for the service pack to install. I have expanded master databases well beyond the capacity where this would ever be a problem but the service pack continues to fail on chkmast.exe. What nweeds to be done to allow the service pack installation to complete?
I heard that installing the service packs for sql 7 causes a file to be written that contains the sa password in clear text. Is this true? If so, does anyone know what the name of the file is?
Do any one has a step by step instructions for installing the service pack 2 and 3 on Active/Passive cluster. I installed sqlserver 7.0 in one active/ passive cluster and it worked successfully. Now I followed the instructions as given by microsoft by running the cluster wizard. It removed the virtual server. I made all sqlservr services offline.
When I try installing I couldn't able to install as it is saying "Active virtual server is there run clustered wizard in all the nodes". Now I am in the middle of no where.
I have an installation of SQL Server 2000. Both MBSA and @@versionshow this to be the gold release. When I install Service Pack 3a, itshows no error. But after restart of the server, it's still unpatched,by both MBSA and @@version.Any idea what may be going on here?
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)
I have been asked to provide a SQL Server 2000 Service Pack 4 validation procedure... I have been unable to locate any reference to how this can be validated in either the program itself or in the registry... Any help is appreciated...
I want to install service pack 3 to my SQL Server 2012 Enterprise running on windows server 2008 R2 Enterprise fail over cluster, I read about the SP installation in technet, its mentioned that the passive node should be patched first and to do this the passive node should be removed from the cluster, I need to know whether I should completely remove the node from windows cluster or remove the node by using SQL Server installer and install the service pack and then add it back to the cluster, Can I do this by pausing the node in cluster and perform the service pack installation ?
Hi, i tried to install SQL Server 2000 Developer and MSDE the whole day on my Windows XP SP2. MDAC is the latest, that come with WinXP SP2 (2.81). The installation fails at the end after 100% complete.
It says: Translated: "the setup programm starts the server and installs the configuration you chose..." ("das setup-programm startet den server und installiert die von ihnen gewählte konfiguration...")
then it takes some time and the failure appears, saying: "the setup programm could not configure the server. you can find more information in the server-failure-log files and in "C:windowssqlstp.log."
We deploy an application that uses SQL Server Express 2005. One of our test engineers tried to use our setup on Windows XP SP 3. But the SQL server installer gave an error - unable to update msxml6r.dll. Is this a bug of the SQL Server installer or do we need to make use of a more recent version of msxml6?
I am trying to install SQL Server 2005 Standard on my laptop, which has Windows XP Professional with Service Pack 2. I could not able to install properly and i am getting error always. i tried whatever the people mentioned in Google, but I could not able to fix the problem. please some one can help my problem.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.
please help
Note : I have SQL Server 2000 Client installed in my laptop. this is my development machine
Thanks
Paddy
Here is the Error message from Summary.txt
Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
-------------------------------------------------------------------------------- Machine : W4102762 Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_w4102762_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted. Error Number : 29515 -------------------------------------------------------------------------------- Machine : W4102762 Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_w4102762_SQLXML4_1.log --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
hi !!!i try to connect to my sql server local instance but it is always failed ..... can you please tell me the step by steps and options to use to install sql server on my machine and i think i need to use he personal copy rather than the standard as it will be on my machne not in the server??? please help
I am putting my first steps into the new Service Broker. I (think i) undestand what it can do, so i execute some example sript i found on the Internet. But with none om them i receive any message into a queue. Can somebody help me. The undeneath example i use.
----------------------------------------
USE AdventureWorksDW GO CREATE MESSAGE TYPE HelloMessage VALIDATION = NONE GO CREATE CONTRACT HelloContract (HelloMessage SENT BY INITIATOR) GO CREATE QUEUE SenderQueue CREATE QUEUE ReceiverQueue GO CREATE SERVICE Sender ON QUEUE SenderQueue
CREATE SERVICE Receiver ON QUEUE ReceiverQueue (HelloContract) GO DECLARE @conversationHandle UNIQUEIDENTIFIER DECLARE @message NVARCHAR(100)
BEGIN BEGIN TRANSACTION; BEGIN DIALOG @conversationHandle FROM SERVICE Sender TO SERVICE 'Receiver' ON CONTRACT HelloContract SET @message = N'Hello, World'; SEND ON CONVERSATION @conversationHandle MESSAGE TYPE HelloMessage (@message) COMMIT TRANSACTION END GO
-----------
From here i do a select * from queue. with 0 rows selected
select * from ReceiverQueue or
RECEIVE CONVERT(NVARCHAR(max), message_body) AS message FROM ReceiverQueue
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)
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!!!
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?
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.
I have installed service pack-1 on SQL SERVER 7.0 Standard Edition. After the pack is installed @@version is still showing 7.00.623 instead of 7.00.699 HELP !!!
