Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SPN Settings Expand / Collapse
Author
Message
Posted Thursday, February 7, 2013 12:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:08 AM
Points: 102, Visits: 416

I have windows 2003 Server with SQL Server 2005 and Windows 2008 with SQL 2008 R2

Is there any difference in SPN registration ?(setspn)

When I put SETSPN -L service account I found multiple entry for the MSSQLSVC for the same server with port number and without portnumber.Would it cause any issue?

Post #1416834
Posted Thursday, February 7, 2013 1:19 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 128, Visits: 424
Why don't you just show us your list of SPNs?

The most important entries are:
setspn -A MSSQLSvc/<Fully qualified domain name of the server>:1433 domain\Account
setspn -A MSSQLSvc/<servername without domain>:1433 domain\Account
(Reporting Services)
setspn -A HTTP/<Fully qualified domain name of the server>:80 domain\Account
setspn -A HTTP/<servername without domain>:80 domain\Account

Greetz sql pizza


Greetz
Query Shepherd
Post #1416854
Posted Thursday, February 7, 2013 1:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:08 AM
Points: 102, Visits: 416
Found this

MSSQLSvc/SQL405.lds.asp..com:1433

MSSQLSvc/SQL405.lds.asp..com
Post #1416864
Posted Thursday, February 7, 2013 1:40 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 128, Visits: 424
I don't think it hurts. I would say you don't need the entry without the port, but as long as it makes no troubles leave it like it was.

Better get a second opinion bout that !


Greetz
Query Shepherd
Post #1416871
Posted Thursday, February 7, 2013 2:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, November 1, 2014 6:54 AM
Points: 5,221, Visits: 5,118
I take it the ..com is a typo, or is that really your domain extension?

The first one is ok, the second is the FQDN when it just needs to be the NetBIOS name, so I would remove it and just create it as SQL405 without the domain extension

SETSPN -A MSSQLSvc/SQL405:1433 Domain\Account
SETSPN -A MSSQLSvc/SQL405.lds.asp.com:1433 Domain\Account




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1416891
Posted Thursday, February 7, 2013 3:35 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:08 AM
Points: 102, Visits: 416
thanks all for the help.

As per my knowledge SQL Server will unregister SPN during shutdown and reregister during startup.

Some of my SQL Servers there is no spn.exe(Windows support tools not installed).Then How this unregister & re register would work ?
Post #1416925
Posted Thursday, February 7, 2013 3:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, November 1, 2014 6:54 AM
Points: 5,221, Visits: 5,118
The service accounts need access to do the SPN registration unregistrations in AD, if it doesnt then it will have to be a manual registration unregistration.





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1416926
Posted Thursday, February 7, 2013 4:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:08 AM
Points: 102, Visits: 416
setspn.exe would be normally in C:\Programfiles\Supporttools\

In my case this folder and setspn.exe not there.it seems support tools for windows not installed.
How do the registration works ? windows support tools is mandatory ?
Post #1416953
Posted Thursday, February 7, 2013 4:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, November 1, 2014 6:54 AM
Points: 5,221, Visits: 5,118
It communicates directly with your AD server as an automatic request if it has the right permissions to do so, it doesnt need the SetSPN tool to be installed.

SetSPN tool is only required for manual requests.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1416956
Posted Thursday, February 7, 2013 4:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:00 PM
Points: 6,618, Visits: 14,182
The only time the auto registering of SPNs will work when running as a domain account is if the account is an administrator or it has been granted readServicePrincipalname and writeServicePrincipalname permissions. Since the user account is low privilege this doesnt usually happen.

You can also use ADSIEdit to directly access the AD catalog and enter the values or grant the permissions mentioned above.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1416962
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse