Enterprise Manager [SQL-DMO]Code execution exception Error

Hello,

We have SQL Server 2000 running on Windows Server 2003 SP1 and when we try to use Enterprise Manager to look at SQL we get the following error while trying to expand the (local) (Windows NT) node under SQL Server Group:

----
SQL Server Enterprise Manager
----
A connection could not be established to (local).

[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION.

Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the (local) node) and try again.
----


If I do try to right click the node, Enterprise Manager just closes and logs the following in the Application Event Log:

----
Source: Application Error - Category: (100) - Event ID: 1000
----
Faulting application mmc.exe, version 5.2.3790.1830, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de.
----

and we have previously seen this error message:

----
Source: Application Error - Category: (100) - Event ID: 1000
----
Faulting application sqlmangr.exe, version 2000.80.2039.0, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de.
----

Also if we open ODBC Administrator and try to create a new SQL Server data source or edit an existing SQL one then the program just closes and logs the following message:

----
Source: Application Error - Category: (100) - Event ID: 1000
----
Faulting application odbcad32.exe, version 3.526.1830.0, faulting module unknown, version 0.0.0.0, fault address 0x5bb312de.
----


Can anyone throw any light on this problem?
ja426Asked:
Who is Participating?
 
Racim BOUDJAKDJIConnect With a Mentor Database Architect - Dba - Data ScientistCommented:
Then youmay consider reinstalling your ODBC as well...at least that's what's seem to be indicated by your error message...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
Look like an installation problem(maybe corrupt binaries)..Have you tried reinstalling the client tools from some other source?
0
 
ja426Author Commented:
We totally uninstalled SQL Server and reinstalled it and SQL was fine for a day or two, then bang! these errors occur...

We have also tried re-installing MDAC with no success...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.