Post reply

create SPN

  • September 21, 2022 at 9:52 am

    #4090235

    how to create  SPN  for  sql  named instance  . SQL service  account is configured  with NT service  account ?

  • September 21, 2022 at 10:33 am

    #4090253

    You must use a domain based account to register SPNs in the domain.

    Once you have done that you can grant the needed permissions to the domain account so that it can read and write the SPNs itself rather than you having to manually do it.

    If you do need to manually do this, ensure you set the names instance to use a static port and not dynamic.

    Then you can use the SETSPN command line tools to register

    MSSQLSvc/Servername:port

    MSSQLSvc/Servername:InstanceName

    MSSQLSvc/Servername.fqdn:port

    MSSQLSvc/Servername.fqdn:InstanceName

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply