How to register SPN for SQL service account or SSPI error

Question

Post reply

How to register SPN for SQL service account or SSPI error

iLearnSQL

Right there with Babe

Points: 715
More actions
June 15, 2020 at 3:08 pm

#3763172
Comments posted to this topic are about the item How to register SPN for SQL service account
- This topic was modified 4 years, 5 months ago by iLearnSQL.

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

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

sindhursai Valued Member Points: 55 More actions · Answer 1

sindhursai

Valued Member

Points: 55

July 24, 2020 at 4:33 am

#3774314

User should be a Domain Admin to perform this.

Cebisa SSC Enthusiast Points: 151 More actions · Answer 2

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