Linked Server Connectivity Test

  • r5d4

    SSCrazy

    Points: 2499

    Comments posted to this topic are about the item Linked Server Connectivity Test

  • david_wendelken

    SSCrazy

    Points: 2328

    Some linked servers are set up to only work for a given set of windows authentications.

    So, the job needs to be set up to run as one of those users.

    There may be some system admin tasks that have to be done to jiggle with the account settings so that will work.

    It's also possible to loop thru the list of linked servers and automatically test all of them either don't require a specific login connection or which require one but you are on the list.

    Don't have sql server up and running at the moment, but there are two system views, both obvious as dirt because of their names, that you can use for that purpose.

  • damian.wise

    SSC Rookie

    Points: 46

    A cut and paste of the generating code from Safari (and Explorer) browser to SSMS on Windows 7 copies a number of invisible characters and corrupts the code. I don't know what the characters are but they are at the beginning of some lines and are not tabs, spaces.

    -Shrug-

    Damian

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

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

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