Skip to main content

Questions tagged [spn]

The tag has no usage guidance.

8 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
2k views

SQL Server could not register the Service Principal Name (SPN) ... without membership in Domain Admins

A separate domain account was created for the database engine service of a SQL Server Failover Cluster Instance. Server Principal Names (SPNs) were added manually via the SetSPN.exe command line tool. ...
Dave Mason's user avatar
2 votes
0 answers
833 views

Enabling Kerberos for Microsoft SQL Server Reporting Services

I am trying to enable Kerberos for MS SQL Server Reporting Services. I am fairly familiar with Windows security and how it works. However, I am new to Scale Out Deployment and Clustering of Windows ...
lawlesm's user avatar
  • 21
2 votes
0 answers
2k views

SQL Server SPNs not being created, state: 43

I'm trying to configure a SQL Server 2014 (12.0.5000.0) instance to use a regular user account in AD and Kerberos auth. During installation the default accounts (local system ones) were used, and the ...
Samuel Harmer's user avatar
1 vote
0 answers
656 views

SSIS 2017 KerberosSupport - Double Hop Issue

I am having an issue with what appears to be a kerberos double hop issue with SSIS 2017. The setup consists of a backend database cluster servers (DBSERVER01\02) an Application\SSIS server (...
David's user avatar
  • 11
1 vote
1 answer
452 views

Connection to database causes SSPI context error

I have migrated a SQL server from another server box that was decommissioned. They have the same name and also same IP address. However, when I connect to the server from an application using trusted ...
damola's user avatar
  • 11
0 votes
0 answers
212 views

Kerberos client authentication times out with SQL error 87

Apologies for the length of this but I'm app developer, not a SQL DBA nor network Admin, so I'm out of my area and just wanted to be sure I documented everything as well as I could. This is a problem ...
DooHickey's user avatar
0 votes
0 answers
2k views

Why SQL Server Kerberos authentication does not work?

I am trying to find out why there is no Kerberos authentication on my SQL instance : SELECT COUNT (auth_scheme) as nb, auth_scheme --net_transport, client_net_address FROM sys.dm_exec_connections ...
Mickael's user avatar
  • 325
0 votes
0 answers
235 views

SSRS 2008R2 SQL Service Account Connection Issue

In our SSRS report manager page we get the below error on the Datasources. This all worked fine previously and seems to suddenly have stopped working. I have no idea what the issue could be. All SPN ...
K09's user avatar
  • 1,394