Possible owners Windows 2008 R2 Cluster

In the Microsoft advice for applying a SQL Server 2008 R2 service pack on a cluster, it states that it is very important to “remove nodes from the possible owner nodes list in the failover cluster instance.”   This was frustrating, because I didn’t know what that meant.  Plus, I had trouble finding this in the Cluster Manager tool in Windows Server 2008 R2.

One problem I have in understanding this was that there are many possible services where you can remove Possible Owners.  I chose to only do this on the cluster name, but maybe you would want to remove possible owners on the SQL Server service.  Some more clarity is needed in the Microsoft documentation (obviously, otherwise I wouldn’t have had to write this blog post).

Eventually I poked around enough to find the Possible Owners check boxes.  Under services and applications, navigate to Services and Applications, then SQL Server (MSSQLSERVER).

In the right-hand pane, right click on the server name, and select Properties.

Go to the Advanced Policies tab, and remove the possible owner, according to the instructions from Microsoft.     Continue to follow the directions from Microsoft to install the service pack.

Preferred Owners are a different thing, and that is done in the left pane by right-clicking on SQL Server (MSSQLSERVER), then the preferred owners checkboxes will show up on the General tab.

This entry was posted in Database Administration and tagged . Bookmark the permalink.

8 Responses to Possible owners Windows 2008 R2 Cluster

  1. Pingback: SQL Server Failover Cluster Rolling Patch and Service Pack Process | viruk67

  2. Dan says:

    Thanks for blogging about this, saved me some sanity.

  3. Jeff says:

    Rock on! THANK YOU for clarifying this muddy point!

  4. Betty says:

    Very useful, I had same issue 🙂

  5. Anonymous says:

    great help, thank you!

  6. Anonymous says:

    Thanks for your Help Man!!!

  7. Anonymous says:

    THANKS Many Many of them.

  8. Anonymous says:

    Thanks – Very Useful

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s