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 reference not working. Expand / Collapse
Author
Message
Posted Thursday, July 17, 2008 11:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 8, 2009 11:10 AM
Points: 4, Visits: 13
Hello all,

I have a weird problem I need help on.

I'm developing on local SQL Server 2005 Express database and I need to write a query that needs to get data from a SQL Server 2005 Enterprise database hosted online (no admin access).

I have setup the online db as a linked server on the local db, but everytime I try to run a query through it I get a login timeout exception. The weird part is this:

- if I connect directly to the online db, using the same simple login, from Management Studio, the same simple query works fine.
- if I run the same code on the other side of the lan's firewall/proxy, it works fine and fast, whether I connect directly or go though the linked server reference.
- the firewall actually has an "allow everything" rule set, for the purposes of testing.
- all the code runs fine from my home, which has no firewall on the proxy.

I have no idea what's going on. Can anyone help?
Post #536458
Posted Friday, July 18, 2008 4:04 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 6:45 AM
Points: 563, Visits: 1,000
What are the details of the linked server connection?

Have you got the correct name for the connection? for SQL connections the name of the linked server is used.
Post #536590
Posted Friday, July 18, 2008 5:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 8, 2009 11:10 AM
Points: 4, Visits: 13
Yes, if you read the post, the same code that doesn't work behind the firewall works outside of it and on other networks. I'm just wondering what esle could be preventing the linked server connection from working, especially when I can connect directly to the server in question.
Post #536646
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse