How to register SPN for SQL service account or SSPI error

  • iLearnSQL

    SSChasing Mays

    Points: 619

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

    • This topic was modified 3 months, 1 week ago by  iLearnSQL.
  • sindhursai

    Valued Member

    Points: 55

    User should be a Domain Admin to perform this.

  • Cebisa

    Valued Member

    Points: 53

    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