March 24, 2014 at 2:44 pm
How should I register SPN for SQL Server 2008?
1. It is a cluster environment
2. It is named instance
3. It is not using default tcp port.
Would the followings be good enough? Thanks in advance.
C:\>setspn –A MSSQLSvc/<servername>:<instanceName> <serviceaccount>
C:\>setspn -A MSSQLSvc/<servername>:44444 <serviceaccount>
March 25, 2014 at 5:27 am
Grace09 (3/24/2014)
How should I register SPN for SQL Server 2008?1. It is a cluster environment
2. It is named instance
3. It is not using default tcp port.
Would the followings be good enough? Thanks in advance.
C:\>setspn –A MSSQLSvc/<servername>:<instanceName> <serviceaccount>
C:\>setspn -A MSSQLSvc/<servername>:44444 <serviceaccount>
Do you have permission within AD to create SPNs?
Check firstly for any duplicates SETSPN -X
and remove them, then register the SPN against the clustered instance virtual networkname.
For TCP\IP connections to a clustered named instance SQLCLUST01\INST1 running under account mydomain\sql-srv using TCP port 58001 you would use
setspn –A MSSQLSvc/SQLCLUST01.mydomain.com:58001 mydomain\sql-srv
setspn –A MSSQLSvc/SQLCLUST01:58001 mydomain\sql-srv
You'll also need to enable the account for delegation in AD
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 26, 2014 at 7:39 am
I have found this... have your AD person grant this right to the service ID write ServicePrincipalName
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply