• turfnsurf4me (10/18/2010)


    MSSQLsvc/<machine name>:1433 and with the FQDN

    This is incorrect, when running SQL Server under the context of a user account the SPN is bound to that user and not the server name. Like so

    SETSPN -A MSSQLSvc/computer.domain.com:TCPPort domain\useracct

    So for my test domain UKTRADING and SQL Server MYSERVER with SQL Server instance using port 1608 I would bind to user account SQL-Service-srv like so;

    SETSPN -A MSSQLSvc/myserver.UKTRADING.co.uk:1608 UKTrading\SQL-Service-srv

    Delete the SPN against the computer name and re register as above!

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

    "Ya can't make an omelette without breaking just a few eggs" 😉