It may happen if your server is configured with differnt protocols
try one of these..

disable named pipes and enable only the tcp/ip.

-----Original Message-----
From: Franz Zoister
[mailto:mssqldba-ezmlmshield-x13062256.[Email address protected]
Sent: Wednesday, June 30, 2004 1:40 PM
To: LazyDBA Discussion
Subject: RE: "Timeout expired" error from query analyser


Can be many reasons.
Is a ping on the server working ?
Is it possible to create a DSN (ODBC Data Source Name) for this server ?
...


-----Original Message-----
From: prakash
[mailto:mssqldba-ezmlmshield-x7200635.[Email address protected]
Sent: Mittwoch, 30. Juni 2004 08:36
To: LazyDBA Discussion
Subject: "Timeout expired" error from query analyser


I get the following error when trying to connect to Sql server from
Query Analyser during login.


"[ODBC SQL Server Driver]Timeout expired"


I tried changing the query time out values in connections tab in Server
configuration.It didn't help.


Any help appreciated.

Regards,

Prakash Somasundaran




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page