“AddNode” operation while setting up SQL 2005 Cluster fails with an error: “Error String : The setup has encountered an unexpected error while Preparing Installation Wizard. The error is: Fatal error during installation. Error Number : 29528”
Recently, I was working on one of the customers on an issue. The resolution is simple but I don’t see much resources online on this.
So, wanted to write a blog on this quickly.
He’s using SQL 2005 (I didn’t say interesting because it is 2005 ;)) and installed SQL on a node (say Node-A) and now trying to do the obvious next step: yes, you guessed it right (‘AddNode’ on the other node).
While doing that he encountered with an error message like
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0020_XXXX_WI.log
Last Action : SetClusterDialogs
Error String : The setup has encountered an unexpected error while Preparing Installation Wizard. The error is: Fatal error during installation.
Error Number : 29528
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
So, I quickly looked in the SQLSetup0020_XXXX_WI.log file, as pointed by the error message above – and it says
MSI (c) (90:88) [11:56:10:530]: Note: 1: 1729
MSI (c) (90:88) [11:56:10:530]: Transforming table Error.
MSI (c) (90:88) [11:56:10:530]: Note: 1: 2262 2: Error 3: -2147287038
MSI (c) (90:88) [11:56:10:536]: Transforming table Error.
MSI (c) (90:88) [11:56:10:537]: Transforming table Error.
MSI (c) (90:88) [11:56:10:537]: Note: 1: 2262 2: Error 3: -2147287038
MSI (c) (90:88) [11:56:10:537]: Transforming table Error.
MSI (c) (90:88) [11:56:10:545]: Note: 1: 2262 2: Error 3: -2147287038
MSI (c) (90:88) [11:56:10:545]: Product: Microsoft SQL Server 2005 (64-bit) -- Configuration failed.
MSI (c) (90:88) [11:56:10:545]: Windows Installer reconfigured the product. Product Name: Microsoft SQL Server 2005 (64-bit). Product Version: 9.4.5000.00. Product Language: 1033. Reconfiguration success or error status: 1603.
MSI (c) (90:88) [11:56:10:550]: Grabbed execution mutex.
MSI (c) (90:88) [11:56:10:550]: Cleaning up uninstalled install packages, if any exist
MSI (c) (90:88) [11:56:10:551]: MainEngineThread is returning 1603
I remember dealing with similar issues earlier, configuration fails by spitting out the “transforming table errors” when we have more than an IP resource configured in the Windows cluster.
And I see from the same log that they have 2 IP resources in the cluster
<Func Name='ValidateIpAddress'>
<Func Name='ValidateIpAddressX'>
Server1 XXX.XXX.XXX Clients 1
<EndFunc Name='ValidateIpAddressX' Return='0' GetLastError='0'>
<EndFunc Name='ValidateIpAddress' Return='0' GetLastError='0'>
<Func Name='IPAddressHelperAddToListView'>
MSI (c) (90!A0) [11:54:48:655]: Note: 1: 2262 2: ListBox 3: -2147287038
<EndFunc Name='IPAddressHelperAddToListView' Return='0' GetLastError='0'>
<Func Name='IPAddressDlgHelperRemoveFromCombo'>
<EndFunc Name='IPAddressDlgHelperRemoveFromCombo' Return='0' GetLastError='0'>
<Func Name='ValidateIpAddress'>
<Func Name='ValidateIpAddressX'>
Server1 YYY.YYY.YYY.YYY Clients 1
<EndFunc Name='ValidateIpAddressX' Return='0' GetLastError='0'>
<EndFunc Name='ValidateIpAddress' Return='0' GetLastError='0'>
<Func Name='IPAddressHelperAddToListView'>
I masked the IPs as XXX.XXX.XXX.XXX and YYY.YYY.YYY.YYY – you actually will see two different IPV4 addresses there.
As soon as I confirmed this, I asked him to follow the sequence of steps below
Remove an IP address -> do the “addNode” -> add the IP back
He did that and you know the outcome – it worked :)
As always, please feel free to get in touch with me with your comments or feedback.
Regards,
Chandra
Comments
- Anonymous
August 09, 2015
You saved my day. Solution confirmed. :)