Posted by Erland Sommarskog on 04/18/07 22:17

ahsan kabir (ahsan_kabir@rediffmail.com) writes:
> osql command is not executing on Remote server(by using link server)
> osql -S ucmain -U sa -P abc -l 2 -Q
>
> ucmain is remote
> abc password
>
> After executing the above command I got time out expire messsage
> What is the reason ?
> It is noted that 35 server is connected with the gateway where the osql
> command is executing. when I want to execute the command only 2 server
> shows time out message but all other going fine.

This is probably a problem with your network. I was faced with the same
mystery today. I was connected to a server in Query Analyzer, and I was
able to run queries against it. But for some five minutes I was not able
to connect to the server through an application or through OSQL. I had
the same problem yesterday.

One thing I tried was to ping the target server. What I noticed was
that the lines in the output came several seconds apart, despite the
response time being listed as < 1 ms. I also noticed that TTL (Time to
Live) was as low as 125.

Note that when OSQL cannot reach the server at all, the error message
is different. When you get "timeout expired", I assume that OSQL is
able to get a connection to the server, but ia nor able to fully
open it in due time.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]