July 10, 2011 at 1:42 pm
I tried to instal sp2 on named instance of sql 2005 cluster..
Actually it was multiple instance cluster but i did not see default instance resources (like sql virtual name,virtual ip,sql disks,sql services,sql agent service ) ,data and log files in both nodes.i saw default sqlserver details in control panel and services.msc ,configuration manger in stopped mode.
when i was trying to instal sp2 on named instance it failed for database engine with fallowing error.
Registry: Opened registry key "Software\Policies\Microsoft\Windows\Installer"
Registry: Cannot read registry key value "Debug", error 0
MSP Error: 29527 The setup has encountered an unexpected error in datastore.
The action is RestoreSetupParams. The error is : Source File Name: datastore\cachedpropertycollection.
cpp
Compiler Timestamp: Mon Nov 17 17:05:55 2008
Function Name: CachedPropertyCollection::findProperty
Source
Line Number: 130
----------------------------------------------------------
Failed to find property "OwningGroup"
{"VirtualServerInfo", "", "defaultinstanevirtualname "} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler
Timestamp: Mon Nov 17 17:05:55 2008
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line
Number: 888
----------------------------------------------------------
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Mon Nov 17 17:05:55 2008
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
----------------------------------------------------------
Failed to find
06/22/2011 09:46:55.555 Attempting to continue the 32 bit ngen queue
06/22/2011 09:46:55.730 Attempting to continue the 64 bit ngen queue
July 12, 2011 at 1:36 am
First of all find the Instance name or if default,you can check this information in the Failover management tool on each SQL Server resources,double click on it and then check the last one tab it will show the instance name MSSQLSERVER or named instance
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 12, 2011 at 7:38 am
It is named instance in cluster management tool.there is no entry of default instance in cluster mgt tool
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply