Home / server / Questions / 1144585
Accepted
JukEboX
Asked: 2023-09-27 23:56:09 +0800 CST

Set SPN To SQL With NT AUthority

  • 772

I am trying to add SPN entries for my SQL server but SQL server is running under an NT Authority account like SYSTEM or LOCAL SERVICE.

When I put in the setspn code it says it can't find the user. Is this possible to do? Trying to run the following:

setspn -L MSSQLSvc/SQLSERVER1 "NT AUTHORITY\LOCAL SERVICE"
sql

2 Answers

  1. The NT authority accounts are local computer accounts, and setspn is for domain account. So you need to the spn for the computer account:

    setspn -S MSSQLSvc/myserver.mydomain.local:1433 myserver.mydomain.local
    • 3
  2. Best Answer

    Thanks for the help from ACE but the parameters were a bit wrong. For a local service account on a server use the following:

    setspn -S MSSQLSvc/server.domain.network:1433 domain\ServerName$
    • 1