Linked server won't work outside RDP connection

• Wogderese

  SSC Veteran

  Points: 217

  More actions

  June 11, 2019 at 7:12 pm

  #3652465

  I have setup a linked server that works fine when I'm RDP'd into the SQL server. However, if I connect to the instance via SSMS from my laptop or else where, I can't see the databases. Any idea what could cause this? The linked server is configured under security to "connections will be made using the login's current security context". This works fine if I use "use this security context"and pass sql account and password but I am trying to avoid using sql logins.

  • This topic was modified 6 years, 1 month ago by Wogderese.
  • This topic was modified 6 years, 1 month ago by Wogderese.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  June 11, 2019 at 7:25 pm

  #3652470

  As a guess, it's related to Kerberos. Go through the following article which explains how it works with linked servers and which accounts need to have delegation allowed:

  SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication

  Sue