SPN Settings

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SPN Settings

SPN Settings

Rate Topic

Display Mode

Topic Options

Author

Message

Akkare

Posted Thursday, February 07, 2013 12:30 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 11:42 PM
Points: 89, Visits: 374

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

SQL Pizza

Posted Thursday, February 07, 2013 1:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

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
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1416854

Akkare

Posted Thursday, February 07, 2013 1:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 11:42 PM
Points: 89, Visits: 374

Found this

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

MSSQLSvc/SQL405.lds.asp..com

Post #1416864

SQL Pizza

Posted Thursday, February 07, 2013 1:40 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

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 Smile

!

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1416871

anthony.green

Posted Thursday, February 07, 2013 2:03 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

Akkare

Posted Thursday, February 07, 2013 3:35 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 11:42 PM
Points: 89, Visits: 374

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

anthony.green

Posted Thursday, February 07, 2013 3:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1416926

Akkare

Posted Thursday, February 07, 2013 4:23 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 11:42 PM
Points: 89, Visits: 374

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

anthony.green

Posted Thursday, February 07, 2013 4:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1416956

Perry Whittle

Posted Thursday, February 07, 2013 4:44 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 10:32 AM
Points: 5,204, Visits: 11,159

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" Wink

Post #1416962

« Prev Topic | Next Topic »

Permissions