CODEWITHSUNDEEP
sqlsql-server-2005
vas
vas

Reputation: 2096

Timeout expired. The timeout period elapsed prior to

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.

Upvotes: 1

Views: 1506

Answers (4)

Thomas Bratt
Thomas Bratt

Reputation: 52062

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.

Upvotes: 1

Stu Pegg
Stu Pegg

Reputation: 1327

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.

Upvotes: 1

MartW
MartW

Reputation: 12548

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

Upvotes: 0

Gratzy
Gratzy

Reputation: 9389

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.

Upvotes: 1

Related Questions