June 13, 2010 at 11:26 am
I am attempting to add 2 new nodes to our existing 2 node cluster. We have a total ot 8 virtual servers running on the nodes to seperate different applciations to their own instance. This was done to consolidate multiple standalone instances into the cluster.
The instances named V01 throu V08 all run SQL of course, and V06 allso runs SSAS.
Per SQL I was running the Change Application Software task once for each instance and choose to add both of the new nodes to the instance. I successfully added nodes 3 and 4 to V01 through V06 and also added nodes 3 and 4 to the SSAS for V06. As soon as the SSAS change was completed I could do no more changes. The followng is from the bootstrape file.
<snip>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.4035.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
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 "ComputerList" {"SqlComputers", "", ""} 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 a cluster group that owned shared disk: C:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Mon Nov 17 17:05:55 2008
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0046_IRVSQLCLN01_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0046.cab" Error Code : 2
Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0046_IRVSQLCLN01_SCC.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0046.cab" Error Code : 20
Running: UploadDrWatsonLogAction at: 7da/5/a 12:23:e
Message pump returning: 2
<snip>
It would appear that the C drive is now thought to be a cluster drive, but it is not, rather it is the default drive for each of the nodes. I can not cluster either V07 or V08 to the two new nodes. I also can not use the change application task to install the client tools of SSIS to the new nodes and I can not patch the new nodes to the appropriate build level for our site.
Any idea where to look for the problem?
One last piece of information. The two new nodes had been part of another cluster. The nodes were ejected and the registry settings cleaned manually and the MSSQL.x folders all deleted prior to the nodes being added to the cluster.
Short of ejecting the nodes from the cluster and having the drives formated and the OS reinstalled I am at a loss for ideas.
June 14, 2010 at 6:55 am
I was going to say raise this as a problem with Microsoft, then I saw you had moved the servers from another node and hoped you had cleaned out all the relevant registry settings.
My advice would be to reinstall Windows on the nodes you want to add. Otherwise it could be difficult to isolate the cause of any issues you have with the patched-in nodes.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply