Problem:
When you’re add a additional cluster node, you got error on SQL installation
Failover instance MSSQLSERVER cluster group not found
Cause:
It is most common cause by your SQL cluster not setup well on first node. A SQL server Agent services should be missing or failed.
Solution:
In First cluster node: Remove SQL cluster node by SQL installation media—Maintenance Tab.
Then Reinstall again. Make sure SQL agent services start & running.
Workaround 2 from other post
1. Open a command prompt and type this command to add a resource type:
cluster restype “SQL Server Agent” /create /DLL:sqagtres.dll
2. Change all the values from 2 to 1 in registery under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState
3. In the Failover Cluster Management used Add Resource to add the SQL Server Agent resource.
4. Right-clicked on the resource and clicked on Properties. Added Virtual Server name (YOUR VIRTUAL NAME) and Instance name (MSSQLSERVER)
5. Add the SQL Server service as dependency for SQL Server Agent Service. and click ok!
6. Right click the resource and click on “bring this resource online”
7. once, the resource is online, you can go ahead and add the the second node
http://blogs.msdn.com/b/wael/archive/2009/12/07/cannot-add-a-second-node-to-an-sql-server-2008-failover-cluster.aspx
Be the first to like this post.
No comments:
Post a Comment