troubleshooting Question

SQL 2005 x64 install failover cluster fails - unexpected error while completing Commit - fatal error

Avatar of Florescu
FlorescuFlag for United States of America asked on
Microsoft SQL Server 2005
5 Comments1 Solution1340 ViewsLast Modified:
I have 2 Windows Server 2003 Enterprise x64 and I have configured them for clustering using the following article:

http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx

I tested the failover between the two nodes and everything was successful.  

I then started installing SQL 2005 Enterprise x64 (Failover cluster) using the following article

http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

Everything was going fine and then about half way thru, I started getting error messages:

1.  The SQL Server Service failed to start.  

-->I verified that the account I was using was a member of the local administrators on both nodes, tried Local System account by going to Services and Properties of that service but that didn't work either.  I just said "Cancel" on that first error.

2.  The setup has encountered an unexpected error while Completing Commit.  The error is Fatal error during installation.

I then looked at the setup log.  here's what I found:

MSI (s) (FC:14) [23:17:58:434]: Note: 1: 1708
MSI (s) (FC:14) [23:17:58:434]: Product: Microsoft SQL Server 2005 (64-bit) -- Installation failed.

Then I searched for "value 3" and here's the 10 lines above that:

MSI (s) (FC:14) [23:17:57:856]: MsiProvideAssembly is returning: 1607
MSI (s) (FC:14) [23:17:57:856]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SString,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (FC:14) [23:17:57:856]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (FC:14) [23:17:57:856]: MsiProvideAssembly is returning: 1607
MSI (s) (FC:14) [23:17:57:856]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Smo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (FC:14) [23:17:57:856]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (FC:14) [23:17:57:856]: MsiProvideAssembly is returning: 1607
MSI (s) (FC:14) [23:17:57:872]: No System Restore sequence number for this installation.
MSI (s) (FC:14) [23:17:57:872]: Unlocking Server
MSI (s) (FC:14) [23:17:57:872]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 23:17:57: INSTALL. Return value 3.



What to do?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros