I am trying to install sql2005-kb918222-x86-enu.exe, first one in the x86 family. I am getting "This machine does not have a product that matches this installation package".
I have SP1 is installed. Version and patch level are 9.1.2047. on
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1Setup
Any help is appreciated
I am trying to install sql2005-kb918222-x86-enu.exe, first one in the x86 family. I am getting "This machine does not have a product that matches this installation package".
I have SP1 is installed. Version and patch level are 9.1.2047. on
HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1Setup
Any help is appreciated
The Kb article says to install all component patches, even if you are not running them, to avoid errors...the reporting services hotfix would not install(obviously since reporting svcs is not installed).....now I get the following erro, when trying to connect to the SSIS on my sql server...oh, I am trying to connect locally on the server it self too....
Cannot connect to CRP-DAY1-SQLs1.
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Connect to SSIS Service on machine "CRP-DAY1-SQLs1" failed:
The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
===================================
Connect to SSIS Service on machine "CRP-DAY1-SQLs1" failed:
The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.
.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
Hello.
I am attempting to install the first of the cumulative hotfix packages ( SQL2005-KB918222-x64-ENU.exe) after applying Service Pack 1 to a SQL Server 2005 std edn 64-bit installation. The service pack installed no problem but the hot fix fails with the following errors in the log file below.
I have installed the 32-bit versions of the hotfix packages onto a different server and I did not get these errors.
Any help on how to sort this out would be much appreciated!
08/23/2006 15:03:44.592 ================================================================================
08/23/2006 15:03:44.608 Hotfix package launched
08/23/2006 15:03:45.842 Product discovery successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.858 SP Level check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.889 Product language check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.905 Product version check successfully completed during the install process for MSSQLSERVER
08/23/2006 15:03:45.920 Command-line instance name check completed during the install process
08/23/2006 15:03:45.936 Baseline build check completed during the install process
08/23/2006 15:03:52.107 Attempting to install instance: MSSQLSERVER
08/23/2006 15:03:52.154 Attempting to install target: SRVLEBIZTALK
08/23/2006 15:03:52.170 Attempting to check for locked files: sqlrun_sql.msp
08/23/2006 15:03:52.232 Attempting to check for locked files: \SRVLEBIZTALKd$dd32a156dacc8dbe70a862647d70hotfixsqlFilessqlrun_sql.msp
08/23/2006 15:03:52.248 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB918222_sqlrun_sql.msp.out
08/23/2006 15:04:02.107 MSP returned 1602: The user cancels installation.
08/23/2006 15:04:02.310 Successfully checked file: \SRVLEBIZTALKd$dd32a156dacc8dbe70a862647d70hotfixsqlFilessqlrun_sql.msp
08/23/2006 15:04:02.326 Successfully opened registry key: SystemCurrentControlSetControlSession Manager
08/23/2006 15:04:02.357 Failed to read registry key: PendingFileRenameOperations
08/23/2006 15:04:02.373 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll
08/23/2006 15:04:02.388 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll
08/23/2006 15:04:02.435 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll
08/23/2006 15:04:02.451 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll.
-----------------------
It carries on with errors like the above but my post will be massive if I include it all, so below is the last few lines of the log file.
--------------------------
08/23/2006 15:04:07.591 Failed to read associated hotfix build information for the following file: C:Program Files (x86)Microsoft SQL Server90SharedMicrosoft.SqlSac.Public.dll
08/23/2006 15:04:07.653 Attempting to install file: sqlrun_sql.msp
08/23/2006 15:04:07.700 Attempting to install file: \SRVLEBIZTALKd$dd32a156dacc8dbe70a862647d70hotfixsqlFilessqlrun_sql.msp
08/23/2006 15:04:07.716 Creating MSP install log file at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB918222_sqlrun_sql.msp.log
08/23/2006 15:04:07.732 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
08/23/2006 15:04:07.747 Failed to read registry key: Debug
08/23/2006 15:05:11.197 MSP returned 1603: A fatal error occurred during installation.
08/23/2006 15:05:11.212 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
08/23/2006 15:05:11.244 Failed to read registry key: Debug
08/23/2006 15:05:11.259 Unable to install MSP file: \SRVLEBIZTALKd$dd32a156dacc8dbe70a862647d70hotfixsqlFilessqlrun_sql.msp
08/23/2006 15:05:11.275 The following exception occurred: Unable to install Windows Installer MSP file Date: 08/23/2006 15:05:11.275 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 856
08/23/2006 15:05:11.322
08/23/2006 15:05:11.353 Product Status Summary:
08/23/2006 15:05:11.369 Product: SQL Server Database Services 2005 (64-bit)
08/23/2006 15:05:11.384 MSSQLSERVER - Failure
08/23/2006 15:05:11.415 Details: Unable to install Windows Installer MSP file
Hello,
I do experiment a problem when trying to install the mentionned patch on my Windows XP SP2 machine (fully patched).
Interestingly, the patch works fine for the named instance, which is a "clean" install of SQL Server 2005 SP1, while it fails on the default instance, which is a SQL 2005 SP1 upgraded in place from SQL Server 2000 SP4. Both instances are Developer editions...
The error is along the following lines:
[snip]
08/10/2006 09:22:06.728 Unable to install MSP file: \DHDHY0Jc$1c7c01591e524f9a092159a233hotfixsqlFilessqlrun_sql.msp
08/10/2006 09:22:06.818 The following exception occurred: Unable to install Windows Installer MSP file Date: 08/10/2006 09:22:06.818 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 856
08/10/2006 09:22:06.948
08/10/2006 09:22:06.998 Product Status Summary:
08/10/2006 09:22:07.048 Product: SQL Server Database Services 2005
08/10/2006 09:22:07.088 MSSQLSERVER - Failure
08/10/2006 09:22:07.138 Details: Unable to install Windows Installer MSP file
08/10/2006 09:22:07.228 SQL2K5 - Not Selected
08/10/2006 09:22:07.338
08/10/2006 09:22:42.409 Hotfix package closed
Any thoughts somebody?
Thanks in advance,
Emmanuel
I believe that I mistakenly attempted to apply the Analysis Services component of this update before applying the SQL Server component. The update now fails continuously with the following message:
02/05/2007 17:58:24.990 ================================================================================
02/05/2007 17:58:25.021 Hotfix package launched
02/05/2007 17:58:27.615 Product discovery successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.630 SP Level check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.646 Product language check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.661 Product version check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.677 Command-line instance name check completed during the install process
02/05/2007 17:58:27.693 Baseline build check completed during the install process
02/05/2007 17:58:34.864 Attempting to install instance: MSSQLSERVER
02/05/2007 17:58:34.974 Attempting to install target: CHARLIDEVSRV
02/05/2007 17:58:35.005 Attempting to check for locked files: sqlrun_sql.msp
02/05/2007 17:58:35.052 Attempting to check for locked files: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 17:58:35.067 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB918222_sqlrun_sql.msp.out
02/05/2007 18:01:52.978 MSP returned 1635: This patch package could not be opened. Verify that the patch package exists and is accessible, or contact the application vendor to verify that this is a valid Windows Installer patch package.
02/05/2007 18:01:53.009 Unable to check MSP file: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 18:01:53.025 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/05/2007 18:01:53.025 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 689
02/05/2007 18:01:53.212 Failed to install instance: MSSQLSERVER
02/05/2007 18:01:53.259
02/05/2007 18:01:53.259 Product Status Summary:
02/05/2007 18:01:53.290 Product: SQL Server Database Services 2005
02/05/2007 18:01:53.306 MSSQLSERVER - Failure
02/05/2007 18:01:53.321
The update fails although I have cleaned the registry of any reference to it. Another article indicated that the hotfix may delete registry keys required, for instance, to operated SSIS if applied in the wrong order. Here, it appears to be preventing the hotfix from being reapplied. I have ensured that all necessary permissions are available and the services are running in domain user accounts with the necessary rights. I'm the administrator on the machine.
Is there a way to get this hotfix applied without having to completely rip and rebuild my server instance?
I have two clustered server. (ms sql 2000 server, windows 2003 server) now i need to add one new server to the cluster and take the secondary node off.
I have installed SP4 & hotfix in my SQL Server cluster before.
My question is do I still need to install SP4 & hotfix in my new server?
Thanks in advance
Hello,
We are trying to Install the Hot fix KB936305 on our SQL 2005 SP2 on Win2k3 machine. We are able to install the hotfix in our test environment but its failing in our PILOT environment. Below is the log for the installation. Any clues on why this happens??
=== Verbose logging started: 4/17/2008 4:46:37 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: o:94d5ea5728f26407a1d7f52282hotfix.exe ===
MSI (c) (94:C0) [04:46:37:781]: Resetting cached policy values
MSI (c) (94:C0) [04:46:37:781]: Machine policy value 'Debug' is 0
MSI (c) (94:C0) [04:46:37:781]: ******* RunEngine:
******* Product: {EB76B218-8FC5-41DF-9F1F-7FF3E0448383}
******* Action:
******* CommandLine: **********
MSI (c) (94:C0) [04:46:37:781]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (94:C0) [04:46:37:781]: Grabbed execution mutex.
MSI (c) (94:C0) [04:46:37:875]: Cloaking enabled.
MSI (c) (94:C0) [04:46:37:875]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (94:C0) [04:46:37:890]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (C8:90) [04:46:37:937]: Grabbed execution mutex.
MSI (s) (C8:34) [04:46:37:937]: Resetting cached policy values
MSI (s) (C8:34) [04:46:37:937]: Machine policy value 'Debug' is 0
MSI (s) (C8:34) [04:46:37:937]: ******* RunEngine:
******* Product: {EB76B218-8FC5-41DF-9F1F-7FF3E0448383}
******* Action:
******* CommandLine: **********
MSI (s) (C8:34) [04:46:37:937]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (C8:34) [04:46:37:937]: Adding MSIINSTANCEGUID to command line.
MSI (s) (C8:34) [04:46:37:953]: End dialog not enabled
MSI (s) (C8:34) [04:46:37:953]: Original package ==> C:WINDOWSInstaller82f71.msi
MSI (s) (C8:34) [04:46:37:953]: Package we're running from ==> C:WINDOWSInstaller82f71.msi
MSI (s) (C8:34) [04:46:38:062]: APPCOMPAT: looking for appcompat database entry with ProductCode '{EB76B218-8FC5-41DF-9F1F-7FF3E0448383}'.
MSI (s) (C8:34) [04:46:38:062]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (C8:34) [04:46:38:062]: Detected that this product uses a multiple instance transform.
MSI (s) (C8:34) [04:46:38:078]: MSCOREE not loaded loading copy from system32
MSI (s) (C8:34) [04:46:38:078]: Applying multiple instance transform 'qlRun01.mst'...
MSI (s) (C8:34) [04:46:38:078]: Looking for storage transform: SqlRun01.mst
MSI (s) (C8:34) [04:46:38:078]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (s) (C8:34) [04:46:38:078]: Transform 'SqlRun01.mst' is valid.
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2205 2: 3: Patch
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary.
MSI (s) (C8:34) [04:46:38:078]: TRANSFORM: Applying regular transform to database.
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (s) (C8:34) [04:46:38:078]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (s) (C8:34) [04:46:38:094]: Couldn't find local patch ''. Looking for it at its source.
MSI (s) (C8:34) [04:46:38:094]: Resolving Patch source.
MSI (s) (C8:34) [04:46:38:094]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (C8:34) [04:46:38:094]: User policy value 'DisableMedia' is 0
MSI (s) (C8:34) [04:46:38:094]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (C8:34) [04:46:38:094]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (C8:34) [04:46:38:094]: SOURCEMGMT: Looking for sourcelist for product {4A35EF4A-D868-4B15-A84D-3E8925AA9558}
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 1706 2: {4A35EF4A-D868-4B15-A84D-3E8925AA9558} 3:
MSI (s) (C8:34) [04:46:38:094]: SOURCEMGMT: Failed to resolve source
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 1708
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2729
MSI (s) (C8:34) [04:46:38:094]: Note: 1: 2729
MSI (s) (C8:34) [04:46:38:094]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (C8:34) [04:46:38:140]: MainEngineThread is returning 1612
The installation source for this product is not available. Verify that the source exists and that you can access it.
C:WINDOWSInstaller82f71.msi
MSI (c) (94:C0) [04:46:38:140]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (94:C0) [04:46:38:140]: MainEngineThread is returning 1612
=== Verbose logging stopped: 4/17/2008 4:46:38 ===
Hi,
We just upgraded 2 sql servers from sql server 2000 sp3a to sql server 2005 build 2153, and merge rep exists between these 2 servers.
However, after sql server upgrade, we had to reinitialize merge replication and now the merge agent is reporting 2 errors
1)
Error messages:
The Merge Agent failed to upgrade triggers, metadata and stored procedures on the Subscriber to versions compatible with SQL Server 2005. Restart synchronization, and if this failure continues to occur reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199403)
Get help: http://help/MSSQL_REPL-2147199403
Invalid column name 'metadata_select_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207
Invalid column name 'delete_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207
2)
Command attempted:
{call sp_MSensure_single_instance (N'Merge Agent Name', 4)}
Error messages:
The merge process could not connect to the Publisher 'Server:database'. Check to ensure that the server is running. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199368)
Get help: http://help/MSSQL_REPL-2147199368
Another merge agent for the subscription(s) is running or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)
Get help: http://help/21036
looking inside the sp_MSensure_single_instance stored procedure, it's trying to obtain an exclusive lock on resource 'Merge Agent Name' but fails and returns -1
this is the stored procedure executed by sp_MSensure_single_instance and @retcode = -1 and thus cannot obtain exclusive lock on resource
EXEC @retcode = sys.sp_getapplock @Resource = 'Merge Agent Name',
@LockMode = 'Exclusive',
@LockOwner = 'Session',
@LockTimeout = 0,
@DbPrincipal = 'MSmerge_PAL_role'
so i think it's failing because for some reason MSmerge_PAL_role database role does not have enough rights to obtain exclusive lock on necessary resources
i've tried many things to fix this, including scripting out and dropping all merge rep, turning off replication db option and reapplying replication create scripts on the server, and even manually deleting the MSmerge_PAL_role database role but still doesn't work
can anyone help?
Thanks
Hello,
Just want to know if anybody else has problems with the hotfix ?
I have a sqlserver 2005 on my desktop.
I installed the sp2 before 5th march.
Recently Microsoft changed the sp2 and released a hotfix for sp2 installed(downloaded) before 5th march.
I installed the hotfix but it failed to update the sqlserver engine.
Very weird.
I uninstalled sqlserver 2005, applied the new sp2 (which was smaller compared with previous one)
Today i still received a critical update in windows update.
I installed it, but i still don't trust these updates.
How can i investigate all went well ?
Can anyone help me to get the hotfix SQL Server 2000 build 8.00.2215 ?
As i do not find any download link.
We would like to apply a hotfix to solve the issue that brought our server down. The hotfix we are trying to apply is in Build 3175. But the latest Cumulative Update 3 Package is Build 3186. Should we apply 3175? Or we can go for the latest build 3186? Which is recommended?
View 6 Replies View RelatedHi,
Is there anyone know where to get the hotfix to put the "Select All" option back on multi-value parameter list after SP1?
The reason why I didn't install SP2 because it requires to install print control on client side. At the moment our company try to avoid it.
Or is there a way to avoid this print control?
I hope to see some responses from MSFT support team.
Cheers,
XL
I have SP1 on most of my servers. My users however do not. They have been developing using "select all" and are now ready to deploy a major project, I am in the process of installing the hotfix so my question is "they do not have SP1 and I have SP1 along with the hotfix" will that work or does this hot fix require that the client tools have SP1 and the hotfix applied as well"? They do not want to change their development environment since they are so close to deployment of their reports. Thank you!!
View 1 Replies View RelatedHi Guys,
Iam at the completion of my project and iam facing a crash from the sql server 2005 .....Microsoft have agreed it to be their bug in the following article
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124525
I have searched for any fix in the site but unable to find that..........So please give me the fix Iam in emergency and also client is on my neck....Please help me out
Thanks in advance,
Phani
Right now my SQL Server 2005 is on build 3054.I am trying to apply patch SQLServer2005-KB934459-x86-ENU.I am getting error like failed to apply hotfix.
Can you please tell me the exact steps so I can troubleshoot and I can upgrade sql server to build 3159.
I'm running sql server 2005 servicepack 2 build 3042 (32bit)
has anyone had any problems with this hotfix????
http://support.microsoft.com/kb/934459
I am getting the following (MOM) error on 3 of my databases anytime I initiate a backup of the mdf. The database seems to backup as expected. The one thing that has recently changed is I implemented MS Hotfix 2187 on my SQl cluster over the weekend.
Severity: Critical Error
Status: New
Source: MSSQLSERVER
Name: Commit record has already been distributed. Check DBTABLE
Description: Unable to expand message 17055 [-1073724769] 18264 Database backed up: Database: XX03PLUS, creation date(time): 2005/12/06(18:38:50), pages dumped: 23026, first LSN: 18761:44:1, last LSN: 18761:46:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'G: empar03PLUS_fromVCforK1.bak'}).
thanks in advance,
Jerry
Post installation of Hotfix Update 8.00.0679 (for the slammer worm) we've encountered this error on our production server "2003-02-13 09:54:17.14 server Error: 17882, Severity: 18, State: 1
2003-02-13 09:54:17.14 server Error accepting connection request via Net-Library 'SSNETLIB'. Execution continuing..".
This appears to correlate with attempts to access our SQL7 server, which was also patched for the worm (Hotfix 7.00.1030) via any query analyzer linked server reference; in fact the linked server attempt fails on a 'general network failure'.
On the SQL2000 side, the SSNETLIB failure is followed by failures in "Stored function 'xp_enumerrorlogs' in the library 'xpstar.dll' generated an access violation" and then all backups fail on memory allocation failures and major database selects of 100K's records fail on "unable to allocate thread".
Anyone have any thoughts or experiences germane? I'm about to undo the security patch on both servers.
Thanks,
Al
Hi,
I'm planning to install the cumulative hotfix (build 2187) on my sql 2000 clustering server (SP4, 2040). And I would like to know if the cumulative hotfix is able to roll back. If possible, please provide me any information about that. Thanks in advance.
I'm running sql server 2005 servicepack 2 build 3042 (32bit)
has anyone had any problems with this hotfix????
http://support.microsoft.com/kb/934459
Hi. Was hoping to get some advice on applying a hotfix to a SQL Server 2005 failover Cluster.
The hotfix I am applying (KB933508) relates to a Maintenance Plans issue with Server 2005 Service Pack 2. During installation I'm advised that unless the SQL Server and other services are stopped a reboot will be required, although I can still install the hotfix. However the installation is failing. There are error details in the relevant logs created in C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix to the effect that the 'Debug' value in registry key 'SoftwarePoliciesMicrosoftWindowsInstaller' can't be read and that SQL Server was unable to add a user (the account under which SQL Server Agent and Analysis Services run) to a local group (the domain group in which SQL Server logins are contained).
Is this something simple like explicitly shutting down the services first before applying the hotfix or is there something else going on?
Regards,
YaHozna
I've got a 4 node SQL 2008R2 cluster (configured 2 active - 2 passive), and 9 instances, of which all but one are on SP1 (the most recent addition is on SP2).
I need to apply a hotfix (Cumulative Update 6 for SP1) to just one instance. Can I do this by failing over the affected instance to one of the passive nodes, applying the hotfix, and failing it back again or do I need to apply the hotfix to all nodes as detailed in:
SQL Server failover cluster rolling patch and service pack process
i.e. will it involve a little downtime for all instances on the cluster?
is it possible to get all installed Hotfix with a Query?
like this?
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Dear all,
I have recently applied the latest cumulative upgrade 3 for SP2 for SQL Server 2005 (KB939537) to have all the hotfixes needed since the SP2, and to correct a specific one : the 50001440 (SQL Server may fail to generate a plan for a complex query that involves cursors and error 8623 occurs - KB940128).
But it is not included in this latest cumulative upgrade package. I read the new policy about CU but I can not know if the 50001440 hotfix is candidate for the CU :
Cumulative update (CU)
€¢
The update can be requested by any customer, regardless of their support offering.
€¢
The update is released every 2 months.
€¢
The update contains the following:
€¢
All previous critical on-demand hotfixes to date.
Fixes for issues that meet hotfix acceptance criteria. These criteria include workaround availability, customer effect, reproducibility, the complexity of the code that must be changed, and so on.
Another bug, the 50001317 (You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections - KB937745) : it is included in the upgrade 2 for SP2 but not in the upgrade3.
So, is it needed to apply each cumulative upgrade or only the latest CU ? And if it is only the latest CU, why are there missing hotfix ?
Thank you very much
Regards,
Emmanuel
So today I decided I may as well put the latest hotfix package for Sql 2005 onto my laptop.
Unlike SP1 the hotfix actually seemed to know about SQL Express and attempt to install itself only to collapse in a big heap. The log file indicates it can't find a bunch of files it wants to patch.
So how do I apply the hotfixes to Express?
Hi-
Whenever I apply a hotfix to my SQL 2005 install, the folder permissions on :Microsoft SQL ServerMSSQL.1MSSQL are always reset. Any reason why this happens? I have explicit permission set on that directory to allow our DBAs access as they are not admins on the server.
Thanks.
Mike
Ok..So the story is I'm trying to install a SQL Server 2005 SP2 upgrade from http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
I'm sure my computer is either x64 or ia64, and I have downloaded both the installation files but both of them give me the same error, when the installation bar at the start is pretty much full, it gives me a "hotfix.exe is not a valid Win32 application." error.
And instead of installing it to the usual C: directory, it installs to the F: directory..And it does not give me an option to choose which directory I want to install it into..
My operating system is a Windows XP Pro..
Hope somebody can help me out soon..
Thanks in advance.
Hotfix fails to install on server. Msg error message below...
SS2K5 - 9.0.3050 - X64
Running as Local Admin
Referred file does not exist and has never existed.
Any ideas on how to get this to apply?
Thanks - Covi
SQL Server Database Services 2005 (PROD02)
Product Version (Previous): 3050
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB933097_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: E:MSSQL.2MSSQLDATAdistmdl1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
----------------------------------------------------------------------------------
Hi,
We are planning to install the SP2 and the 3152 hotfix in one of our sql 2005 instance. The server has sql 2000 instance(with SP4) also.
Do we need to consider anything before we go with this installation?. Do we have any known issues with 3152 hotfix?.
Thanks
N. Sankar
I know that several hotfixes need you to turn on trace flag 4199 to activate them. But after reading an article on that trace flag, and the way it was worded, I couldn't tell if you still needed to use the trace flag, once that hotfix was incorporated into a service pack.
View 1 Replies View RelatedHi all we applied Hotfix #931821 to a 64 bit machine and now we get a random Internal Report Error. Once this error occurs it usually only requires a refresh to have the report successfully execute. Has anyone else had this experience or know what I can do to fix it. The message below comes from the log file created by the error.
Thanks for any help
-JW
w3wp!runningjobs!b!9/21/2007-17:01:07:: w WARN: Thread pool pressure. Using current thread for a work item.
w3wp!processing!b!09/21/2007-17:01:07:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderReportAction.Render(String format, String deviceInfo)
Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!b!09/21/2007-17:01:07:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
w3wp!library!7!9/21/2007-17:01:13:: i INFO: Cleaned 0 batch records, 0 policies, 8 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
There are special instructions for installing service packs on desktop edition installations -- command line options etc. How do you install hotfix roll-ups? Does build 2187 apply to desktop edition?
View 1 Replies View Related