Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbrown7232
Starting Member
22 Posts |
 Posted - 2012-01-13 : 11:12:46
|
| Hi,I am runningMicrosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) on Windows Server 2008 R2Service Pack 1Both nodes are owners of everything besides SQL Server and the SQL Server Agent. When I right click on the properties of these 2 and go to the advanced Policies tab. It shows only one node listed instead of the two nodes. How can I add my second node so that I can failover my cluster? This is so frustrating why this node would even fall off from being an owner of these SQL resources. Any help would be greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jbrown7232
Starting Member
22 Posts |
Posted - 2012-01-13 : 13:42:53
|
| The cluster was built and working fine. In order to setup the cluster it had to run through the checklist. Both nodes had 100% control of all resources. All of a sudden now Node 2 isnt an owner of the SQL application. How can I add node 2 to be an owner? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
2 Node Cluster -One Node Not Owner Of SQL Resource