x

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
more ▼

asked Sep 12, 2010 at 04:50 AM in Default

Vineet gravatar image

Vineet
1 2 2 2

(comments are locked)
10|1200 characters needed characters left

6 answers: sort voted first

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.
more ▼

answered Sep 12, 2010 at 06:44 AM

Tim gravatar image

Tim
36.4k 39 41 139

this is the error i get on screen "hotfix has encountered a problem and needs to close" and sql server goes offline first.... any one has faced this kind of issue ever?
Sep 12, 2010 at 07:11 AM Vineet
(comments are locked)
10|1200 characters needed characters left

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?
more ▼

answered Sep 12, 2010 at 07:23 AM

Tim gravatar image

Tim
36.4k 39 41 139

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

Sep 12, 2010 at 07:36 AM Vineet
(comments are locked)
10|1200 characters needed characters left
Read over this article and see if it applies to your situation. http://www.bigresource.com/Tracker/Track-ms_sql-tHdwK7Pz/
more ▼

answered Sep 12, 2010 at 07:45 AM

Tim gravatar image

Tim
36.4k 39 41 139

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.
Sep 12, 2010 at 11:22 AM Vineet
(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Sep 12, 2010 at 01:11 PM

Tim gravatar image

Tim
36.4k 39 41 139

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x75
x69

asked: Sep 12, 2010 at 04:50 AM

Seen: 1951 times

Last Updated: Sep 13, 2010 at 02:49 AM