Link to home
Start Free TrialLog in
Avatar of ja426
ja426

asked on

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?
Avatar of Racim BOUDJAKDJI
Racim BOUDJAKDJI
Flag of Algeria image

Look like an installation problem(maybe corrupt binaries)..Have you tried reinstalling the client tools from some other source?
Avatar of ja426
ja426

ASKER

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...
ASKER CERTIFIED SOLUTION
Avatar of Racim BOUDJAKDJI
Racim BOUDJAKDJI
Flag of Algeria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial