?
Solved

Enterprise Manager [SQL-DMO]Code execution exception Error

Posted on 2006-05-18
5
Medium Priority
?
2,336 Views
Last Modified: 2013-12-03
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?
0
Comment
Question by:ja426
  • 2
3 Comments
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 16707357
Look like an installation problem(maybe corrupt binaries)..Have you tried reinstalling the client tools from some other source?
0
 

Author Comment

by:ja426
ID: 16707429
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
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 1000 total points
ID: 16707573
Then youmay consider reinstalling your ODBC as well...at least that's what's seem to be indicated by your error message...
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question