January 26, 2011 at 11:31 am
I have a 2 node SQL 2008 SP1 cluster.
The sql engine is running under a domain service account.
I need to register SPN's which I have been told will require me to restart the sql service.
The cluster nodes are named sqlnode1 and sqlnode2 and the cluster is named sqlcluster.
I have a couple of questions:
Do I need an 6 SPN's?
1) sqlnode1 netbios name
2) sqlnode1 fqdn
3) sqlnode2 netbios name
4) sqlnode2 fqdn
5) sqlcluster netbios name
6) sqlcluster fqdn
And lastly, what is the process for restarting the sql service on each node so the spn's will kick in?
Thanks.
January 26, 2011 at 3:35 pm
I don't have the link handy, but Brian Kelley has an article on this site about setting up and configuring Kerberos.
As to which SPN's you need to set up - it all depends on how your systems are accessed. If they are accessed always using the FQDN, then that would be the only one you need.
However, I highly doubt that is the case - so you probably need several. At a minimum, you will need the FQDN.
You do not need each individual node - just the SQL Cluster VIP.
And finally, you don't need to cycle SQL Server to add/remove SPN records to have them available for use. But, just in case - all you need to do to cycle SQL Server in a cluster is to either move the group or take the resource offline in cluster administrator.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 26, 2011 at 4:02 pm
Thanks for your response, I will search for that article by Brian Kelly. If you happen to come across it, can you post it here?
thanks again.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply