We had a requirement to change the SQL Server Fail over cluster group Virtual server name. We did that change through the cluster administrator. That SQL Server was 2008 Enterprise running on Windows 2008 Enterprise cluster. The change was successfully made from one node and the SQL server came online after that. But when we did fail over testing, we noticed that the SQL Server service is not coming online on the other node. The SQL Server error-log gave below errors while trying to start-up.
Check the Registry entry shown below on the node in which the SQL Server cluster was not coming online. If the key is not updated with the new Virtual network name, update the same and try to bring SQL Server resource online. Yeah !. It comes online Successfully.
Still Facing Issue?
Check the SQL Server Configuration manager on the failing node and see if the TCP/IP is enabled and VIA is disabled. At least this should fix that issue. If you still have problem, Please send me your complete error-log. I will try my best to find the solution. Thank You.