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.
| Author |
Topic |
|
iwin369
Starting Member
13 Posts |
 Posted - 2010-08-31 : 12:11:25
|
| Hi All,I tried login to the database server and got “Database Connection Timeout” error. Wondering what exactly the problem with DB.it is occuring once in a while.And sometimes while connecting to the server through SQL Server enterprise manager I am getting a connectivity error like " Aconnection could not be established to server"Reason : Time out expiredThis seems to be an intermittent/reoccurring issue. We have not observed any issues in the database log till now and work around given till now is the restart of the database server.Can someone please help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
iwin369
Starting Member
13 Posts |
Posted - 2010-08-31 : 12:23:42
|
| hi tkizer, Thanks for your reply I have done all the checks which you mentioned below everything went fine from my side just wannna find the root cause for this. wanted to find out wht exactly causing it to occur at certain times.Any suggestions please .... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
iwin369
Starting Member
13 Posts |
Posted - 2010-09-01 : 02:17:49
|
| Hi tkizer, FYI both the application and the database are residing on the same server and there is no point of network issue.When the user is connecting to the server through the sql enterprise manager he is able to see the following error" A connection could not be established to server"Reason : Time out expired Sometimes they are able to connect successfully to the database and then when they are issuing some queries they agin see the error stating. Database Connection Timeout” error As per your suggestion I asked them to change the Connection timeout from 15sec-60sec(Thanx for that).But i need to give some solution the former error mentioned above this.Any more suggestions Have done the ODBC connectivity check and its going fine. Sql services running fine No problem with the port No Blk by sessions identified CPU usage less than 30% No errors found in the error log All the processors are running fine. If Any other things to tested please keep posting me... Many Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
iwin369
Starting Member
13 Posts |
Posted - 2010-09-07 : 07:41:27
|
| Hi Tara, Sorry for the delay.There is no much increase in the memory utilisation.We have raised a Problem ticket for the same issue.It was not yet resolved.Many thanks for your help |
|
|
|
AKA
Starting Member
1 Post |
Posted - 2010-09-17 : 23:33:49
|
| Hi friends, I m working in a Govt. Office. In my office SQL 2000 Server edition is running on server. 3 days back the sql server in service manager automatically got stopped during working and did not restart even after restart the servie and server. Why it happend and what is the solution to this prob. Can any guy help me.RegardsAnand |
|
|
|
|
|
|
Intermittent