How to register SPN for SQL service account or SSPI error

  • Comments posted to this topic are about the item How to register SPN for SQL service account

    • This topic was modified 7 months ago by  iLearnSQL.
  • User should be a Domain Admin to perform this.

  • To get information for this, you can query with T-sql:

    Select auth_scheme,  local_tcp_port, @@servername, SERVERPROPERTY('MachineName'), SERVERPROPERTY('InstanceName') From sys.dm_exec_connections where session_id = @@spid

    And

    Select servicename service_account from sys.dm_server_services

     

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

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