SQL server 2000

**Erland Sommarskog** · Apr 18 '07, 10:25 PM

Re: SQL server 2000

ahsan kabir (ahsan_kabir@re diffmail.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@sommarsk og.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

SQL server 2000

SQL server 2000

Comment