asked
SqlServer 2005 CU7 Patching
Hi, This is the error i am getting while installing cu7 any ideas? Product Installation Status Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 4035 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB976951_sqlrun_sql.msp.log Error Number : 29527 Error Description : MSP Error: 29527 The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is : Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Fri Oct 30 08:23:59 2009 Function Name: ClusterInfoCollector::collectClusterGroups Source Line Number: 391 ---------------------------------------------------------- Failed to determine disk information Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Fri Oct 30 08:23:59 2009 Function Name: ClusterInfoCollector::collectClusterGroups Source Line Number: 390 ---------------------------------------------------------- Enum*Disks() returned : 2147944126
I haven't tried installing CU7, I did install CU8 on a few boxes and had issues where it would go through the installation with no issue but not update the version. I downloaded CU4 which I knew worked fine on another installation and installed it on the instance I was trying to update to CU8. CU4 installed fine, updated the version, I then applied CU8 and it worked perfectly. I'm not saying this will help you but it might be worthwhile to backup a couple of releases and install on, then try CU7 again.
Can you tell us what is the in the log file located on C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB976951_sqlrun_sql.msp.log Also couple of other things, do you have plenty of disk space and are you logged in as a server admin and SQL admin?
have close 40 GB free so this should be the issue and the accoutn has been added to server admin and sql admin. Pl find the error below: Doing Action: RestoreSetupParams PerfTime Start: RestoreSetupParams : Sun Sep 12 10:56:20 2010 Failed to find installation media path due to datastore exception in FindSetupFolder() MSI (s) (1C!E8) [10:56:20:182]: Note: 1: 2203 2: C:\WINNT\system32\Setup\SqlRun.msi 3: -2147287038 Loaded DLL: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\xmlrw.dll Version: 2.0.3609.0 Failed to find installation media path due to datastore exception in FindSetupFolder() Failed to find installation media path due to datastore exception in FindSetupFolder() Failed to find installation media path due to datastore exception in FindSetupFolder() Failed to find installation media path due to datastore exception in FindSetupFolder() MSI (s) (1C!E8) [10:56:21:777]: PROPERTY CHANGE: Adding SqlInstanceName property. Its value is 'MSSQLSERVER'. MSI (s) (1C!E8) [10:56:21:777]: PROPERTY CHANGE: Adding INSTANCENAME property. Its value is 'MSSQLSERVER'. Loaded DLL: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version: 2005.90.4035.0 Failed to enumerate disks. HRESULT: 0x 800706be The remote procedure call failed. MSI (s) (1C!E8) [10:56:32:846]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:846]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:862]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:862]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:862]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:862]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:862]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:862]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:862]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:862]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:862]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:862]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:862]: Note: 1: 2262 2: Error 3: -2147287038 Error Code: 29527 MSI (s) (1C!E8) [10:56:32:877]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:877]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:877]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:893]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:893]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:893]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:893]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:893]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:893]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:893]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:893]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:893]: Transforming table Error. MSI (s) (1C!E8) [10:56:32:893]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (1C!E8) [10:56:32:893]: Product: Microsoft SQL Server 2005 -- Error 29527. The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is : Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Fri Oct 30 08:23:59 2009 Function Name: ClusterInfoCollector::collectClusterGroups Source Line Number: 391 ---------------------------------------------------------- Failed to determine disk information Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Fri Oct 30 08:23:59 2009 Function Name: ClusterInfoCollector::collectClusterGroups Source Line Number: 390 ---------------------------------------------------------- Enum*Disks() returned : 2147944126 Error 29527. The setup has encountered an unexpected error in datastore. The action is RestoreSetupParams. The error is : Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Fri Oct 30 08:23:59 2009 Function Name: ClusterInfoCollector::collectClusterGroups Source Line Number: 391 ---------------------------------------------------------- Failed to determine disk information Source File Name: datastore\clusterinfocollector.cpp Compiler Timestamp: Fri Oct 30 08:23:59 2009 Function Name: ClusterInfoCollector::collectClusterGroups Source Line Number: 390 ---------------------------------------------------------- Enum*Disks() returned : 2147944126
Read over this article and see if it applies to your situation.
http://www.bigresource.com/Tracker/Track-ms_sql-tHdwK7Pz/
I have gone through the article but no where i am able to link this with my issue. What i am concerned about is that when we install the spac it shuts sql server down and gives this msg on screen "hotfix has encountered a problem and needs to close". Have uninstalled the spac started a fresh install even that is not working.
Do you have your mssqlsystemresource.mdf, mssqlsystemresource.ldf, distmdl.mdf, distmdl.ldf, and master database all in the same folder? Many folks move their system databases to different drives or LUNS and forget about the mssqlsystemresource and distmdl databases. If they are not in the same location as Master hotfixes will fail. Your error message isn't stating this exact error but it is worth mentioning here to make sure that isn't an underlying cause.
