Post reply

How to find all Linked Servers pointing to our instance?

  • November 3, 2020 at 5:14 pm

    #3803965

    Hi all.

    We are preparing for migration, and scripting all our Linked Servers. But how to find all other Linked Servers, that originate on different instances but leading to ours?

    Thanks

     

     

  • November 3, 2020 at 5:36 pm

    #3803967

    Scrape the connection logs, will at least give an idea what linked services are connecting within the log retention period.

    😎

     

  • November 3, 2020 at 5:55 pm

    #3803968

    I tried SQL Server Logs which is under Management folder, it does not have this info. Where I can find connection logs?

    Thanks

     

  • November 3, 2020 at 10:11 pm

    #3804037

    this is almost impossible, unless 1)both successful login and failed login were logged(default to failed only); and 2)linked server to your instance uses a special user that's not used for any other application(for example, web application), otherwise, you cannot tell if a connection is via linked server or from your web application. Even in this case, a very old linked server could still be lingering somewhere, but rarely connects.

Viewing 4 posts - 1 through 3 (of 3 total)

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