InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 00:04:16 GMT20http://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxThe 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.Thu, 07 Feb 2013 04:44:00 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxIt 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.Thu, 07 Feb 2013 04:31:43 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxsetspn.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 ?Thu, 07 Feb 2013 04:23:17 GMTAkkarehttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxThe 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.Thu, 07 Feb 2013 03:37:27 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxthanks 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 ?Thu, 07 Feb 2013 03:35:40 GMTAkkarehttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxI 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 extensionSETSPN -A MSSQLSvc/SQL405:1433 Domain\AccountSETSPN -A MSSQLSvc/SQL405.lds.asp.com:1433 Domain\AccountThu, 07 Feb 2013 02:03:35 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxI 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 :-)!Thu, 07 Feb 2013 01:40:44 GMTSQL Pizzahttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxFound this MSSQLSvc/SQL405.lds.asp..com:1433 MSSQLSvc/SQL405.lds.asp..comThu, 07 Feb 2013 01:32:23 GMTAkkarehttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxWhy 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\Accountsetspn -A MSSQLSvc/<servername without domain>:1433 domain\Account(Reporting Services)setspn -A HTTP/<Fully qualified domain name of the server>:80 domain\Accountsetspn -A HTTP/<servername without domain>:80 domain\AccountGreetz sql pizzaThu, 07 Feb 2013 01:19:25 GMTSQL Pizzahttp://www.sqlservercentral.com/Forums/Topic1416834-1550-1.aspxI have windows 2003 Server with SQL Server 2005 and Windows 2008 with SQL 2008 R2Is 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?Thu, 07 Feb 2013 00:30:28 GMTAkkare