Timeout expired. The timeout period elapsed prior to ...

Question

I am trying to access SQL 2005 database.When I am trying to Login it is throwing the folllowing error.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

I was connected to the DB and was working on the Queries/procs , when suddenly i am unable to access the DB.

One of my Team mate at another center was able to get in. Does it mean i am unable to access only my login? Why does this happen? Is there a rememdy to this?

I am remotely accessing the SQL server via LAN.

Kindly help.

Answer 1

You were actively connected and working and then all of a sudden you got that message?

"Does it mean i am unable to access only my login?"

try another login or ask someone else who has access.

Check with your admin and see if the instance itself is not responsive.

Answer 2

Do you have physical access to the machine to check it's still working? Could be simple hardware failure or power interruption.

Answer 3

It could be a computer-specific issue, rather than SQL server. I've heard of software firewalls causing issues with connecting out on unlikely ports like SQL Server's Management Studio does.

Do you have any software firewalls enabled? It'd most probably be one with Program Control of some form such as Windows Firewall or Zonealarm.

If not, it's worth grabbing a network bod to double check there's nothing else interfering locally.

Answer 4

If you are using a TCP/IP connection to the database server and you know the port number (it is 1433 by default) then you can check the connectivity with this trick:

telnet 127.0.0.1 1433

If the connection establishes then you should get a black screen. If not, you get an error message. This should be enough to check your network connection to the server is working correctly.