Post reply

Linked server won't work outside RDP connection

  • 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 4 years, 10 months ago by  Wogderese.
    • This topic was modified 4 years, 10 months ago by  Wogderese.

  • 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

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

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