≡ Menu

Unexpected error (0x80070002) while installing SQL 2005 named instance

While installing cluster instance, it is failing at the initial stage of setup with unexpected error message pop-up. I reviewed the “C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGsummary.txt” log file and it has the below error.

Microsoft SQL Server 2005 9.00.4035.00
OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Time : Fri Oct 16 12:53:22 2009

NODE1 : To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.
NODE1 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.

There can be two reasons here…

1) Improper directory structure in SQL installation source
2) You are trying to install different version of SQL than what you have on cluster.

If you find both the above are not applicable in your case, then go to “C:\Program Files\Microsoft SQL Server90\Setup\Bootstrap\LOGFiles\SQLSetup0018__Core(Patched).log” log file and see what it says. In my case, I have below error message in the logs which is indicating problems with reading one of the shared drive Q:. Sometime back I have moved system databases from one drive to another for a cluster instance and deleted the old drive. But the regkey(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.9SetupSetupDataRoot) is still containing the old drive letter. Cluster setup is trying to read this key and failing because it cannot find the cluster drive Q: which I deleted some time back.

Failed to find property “ComputerList” {“SqlComputers”, “”, “”} in cache
Source File Name: datastoreclusterinfocollector.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: datastoreclustergroupsproperties.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:Q:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Now I went ahead and changed the registry key value to new drive name in all cluster nodes and restarted the setup. It worked like a champ and I continued with my work. I am posting here it to help others who stuck with same problem. This may not be the cause always but I am just outlining the procedure for troubleshooting.

Happy learning…,
Sitaram Pamarthi

Comments on this entry are closed.

  • Joe Manini August 6, 2011, 2:28 am

    Great post….After reading this I did realize that I had a drive offline in my cluster. Once I brought it online all was well once again with my newest instance. Thanks

  • Hitesh Hansalia February 1, 2014, 8:47 am

    You forget to mention registry that needs to be changed.
    The main key you’re looking for is DataDir under
    HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.2\Setup. It should be on a shared drive
    Like X:\Microsoft SQL Server\