• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

SQL Linked Server Issue

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?
0
L-Plate
Asked:
L-Plate
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
User trying to establish “Link Server” connection. It  fails.
What's the error returned?
0
 
L-PlateAuthor Commented:
thanks for you comment, issue sorted
0

Featured Post

 Email signature solution for Office 365

Easily set up a company-wide email signature in Office 365 that works with every email client. Add personalized email signatures to every email in your company. Let users preview their server-level signature in Outlook.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now