Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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. :)