all groups > sql server connect > july 2004 >
You're in the

sql server connect

group:

Enterprise Manager: The connection to SQL Server <server> has been broken.


Enterprise Manager: The connection to SQL Server <server> has been broken. rkinnie01 NO[at]SPAM excite.com
7/31/2004 7:22:35 AM
sql server connect: All~

I am currently running the most recent version of MSDE and using EM as
a front end interface. In EM, I go to look at the databases I had
previously created, but receive the message:

The connection to SQL Server <server> has been broken. The connection
to the SQL Server is broken. Do you want to try reconnection...

I am unable to start SQL Agent, but I am not sure whether this is the
cause. I am able to connect via the Query Analyzer facility fine. I
get the following SQLDump [truncated].

What is the EXCEPTION_ACCESS_VIOLATION and how can I fix it?
....
**
*
* BEGIN STACK DUMP:
* 07/31/04 09:59:24 spid 0
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
....

Your help is greatly appreciated.
Re: Enterprise Manager: The connection to SQL Server <server> has been broken. Sue Hoegemeier
8/2/2004 8:45:38 PM
Check your SQL Server error logs for more information. Also
check the SQL Agent log and see if you find any errors
related to that issue. You may also want to check the stack
dump and compare it with that mentioned in the following
article:
PRB: Removal of Guest Account May Cause Handled Exception
Access Violation in SQL Server
http://support.microsoft.com/?id=315523

-Sue

On 31 Jul 2004 07:22:35 -0700, rkinnie01@excite.com (Richard
[quoted text, click to view]
AddThis Social Bookmark Button