Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server Connectivity Test Expand / Collapse
Author
Message
Posted Wednesday, March 24, 2010 7:24 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:59 AM
Points: 267, Visits: 689
Comments posted to this topic are about the item Linked Server Connectivity Test
Post #889469
Posted Wednesday, March 31, 2010 5:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 19, 2013 2:00 PM
Points: 183, Visits: 479
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
Posted Monday, January 3, 2011 12:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 10:46 AM
Points: 4, Visits: 43
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 »

Add to briefcase

Permissions Expand / Collapse