April 26, 2011 at 5:32 am
Last night I had application users reporting an error that there database connection had been interrupted. Is there a log file somewhere that I could go and look at to try and figure out what happened at that time.
This is a SQL Server 2005 database.
Any troubleshooting advice you could offer would be greatly appreciated. Thank you!
April 26, 2011 at 6:03 am
I would look first at the SQL Server error log. You can see that in the Management folder in SSMS. I would also look at the Event Viewer on the server itself. Between these two you're as likely to find information as anywhere.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 12, 2012 at 12:28 pm
HI ,
I am working on same error....front users getting error"Database connection has been interrupted.please attempt to restart application"
we have SQL server 2008R2 .
Can you tell me what steps you have taken to solve this ?
Any idea how to solve this ?
Thanks
April 16, 2012 at 9:07 am
Are you sure that this is not the application causing this error rather than a database issue?
If this is a new issue or error try and establish what's changed: This is big question as it covers everything from the user's PC to the database server. A software update or patch? Configuration policy on a server maybe?
I had a similar issue a few months ago where users were reporting that connection had been lost between a web application and the SQL Server.
After questioning user's further it transpired the slow down and connection loss was occurring during the afternoon.
The cause was degraded DISK IO between the hours of 2pm and 4pm.
This was caused by a server administrator who carelessly set a full DB backup, shrink operation and maintenance to run during the PM instead of the AM.
OK, this is a long answer but hopefully you get the idea that if you can't find fault with the database or it's hardware, extend your investigation outwards!
:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply