troubleshooting Question

SQL Linked Server Issue

Avatar of L-Plate
L-Plate asked on
Active DirectoryMicrosoft SQL Server
2 Comments1 Solution76 ViewsLast Modified:
Have the following issue

User trying to establish “Link Server” connection. It  fails.

Running select auth_scheme from sys.dm_exec_connections where session_id=@@spid returns NTLM

If SPN is registered for SQL service in AD assume issue is NTLM

What remedial action is required to make connection work?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros