August 26, 2008 at 11:13 pm
We have created linked server between
SQL 2005 x86 Server &
SQl 2005 x84 Server.
When i click "Test Linked Server" it is working. Also when i run
SELECT TOP 1 * FROM [LinkedServer].[master].[dbo].sysobjects
It is working!
Now from my desktop i open Management studio and connect to the 2005 x86 Server and run
SELECT TOP 1 * FROM [LinkedServer].[master].[dbo].sysobjects I get results. Now If I leave the session idle for 10 minutes and then run the same query, I get "SQLNCLI: time out expired" and even I click new query window and run the query same error.
If I get into the server and click Testlinked server it works fine and then later If I run the same query from my desktop now it works fine...It looks something strange... Anyone experienced the same? Please share!
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
August 27, 2008 at 10:18 am
Maybe this helps?
http://chopeen.blogspot.com/2006/09/remote-query-timeout.html
August 27, 2008 at 11:22 pm
Hi Sam,
Let me check this when i go to office... I think it is the culprit... Thanks!
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
August 30, 2008 at 5:51 pm
Just curious, Did it worked by changing the remote query time out Seconds?
You mentioned above "even I click new query window and run the query same error"
If that is the case then the issue will not be "remote query time"
If solved that'f fine, otherwise can you tell me which authentication you uses in LinkedServer?
I've faced some error when I used 3rd option "Connect using current login "
It will work from our application and goest time out, But if I connect again inthe amchin using managemnet Studio It works..
August 31, 2008 at 8:32 am
Hi,
I forgot to update the forum... Nope.. It is still not working... I'm using SQL authentication with hardcoded user ID..
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply