Linked Server Connectivity Test

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Richard Doering » Linked Server Connectivity Test

Linked Server Connectivity Test

Rate Topic

Display Mode

Topic Options

Author

Message

r5d4

Posted Wednesday, March 24, 2010 7:24 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, February 11, 2013 7:58 AM
Points: 267, Visits: 662

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

Post #889469

david_wendelken

Posted Wednesday, March 31, 2010 5:25 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 1:06 PM
Points: 183, Visits: 478

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.

Post #893649

damian.wise

Posted Monday, January 03, 2011 12:07 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 10:26 PM
Points: 4, Visits: 38

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

Post #1042000

« Prev Topic | Next Topic »

Permissions