“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”

  • Article

 

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