Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Connection Loss

Author  Topic 

raguyazhin
Posting Yak Master

105 Posts

Posted - 2011-03-07 : 01:37:33
Hi,

Suddenly Clients are didn't connect the Database Server.
What are the scenarios? as a DBA What shall i do the Next Steps?


--
Ragu Thangavel
Junier Sql Server DBA

krishnakantj
Starting Member

2 Posts

Posted - 2011-03-09 : 01:08:03
Connection loss can occur due to below problems.

1)Network Problem
2)SQL Server Service Down at server
3)Too many requestes at server ( more than allowd concurrent session )

Next you can take below action to find out the problems.

1)Ping to the DB server
2)If connected then look for DB service
3)Try Login into the DB

Hope it will help...!!


Krishnakant Joshi
Software Engineer
Go to Top of Page
   

- Advertisement -