Migrating A Cluster SQL Instance To A Standalone SQL Instance On A Virtual Machine


PROBLEM

· Help in migrating a cluster SQL instance to a standalone SQL instance on a virtual machine


RESOLUTION

1. Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0

2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from SQL Configuration Manager

3. Change IP Address of node which will host the standalone SQL instance to old SQL Server Virtual IP Address

4. Change Computer Name of node which will host the standalone SQL instance to old SQL Server Virtual Server Name

5. Reboot the server

6. After reboot, you will be able start SQL Server and connect from client machines using Named Pipes

7. Take a backup and delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Cluster

8. In the TCP/IP properties in the configuration Manager change “Listen All” to YES

9. In the IP Address TAB change Enabled to “NO” for the IP which had Virtual SQL Server IP Address.

Note: The above steps were performed in our test environment for our internal test purpose. In case if the above steps didn’t work, we need to follow the supported method by uninstall cluster SQL instance and install SQL Standalone instance.


Maybe this info will help somebody else out, and save them $250 if they don't have a support contract. :D 

Source: https://arstechnica.com/civis/viewtopic.php?t=1248501