Problem with MOM using DMO to connect to SQL 2000 instance

Question

Since the bank holiday weekend the following error message have been generated in MOM

The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL2000 instance running on server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION"

Could not connect using SQLDMO to SQL Instance 'SQL 2000 instance running on server' . However, the instance is currently running.

I have carried out fixes as per MS details ie registered sqldmo.dll and checked for user accounts being denied and the error continues

and now I have the following error appearing:

The SQL Server management pack script "SQL Server 2005 Service Availability" is unable to successfully connect to the SQL Server instance "SQL 2005 server running on the same server". The error message returned is "[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION"

I have another server with the same SQL2000 and SQL2005 instances set up which is monitored in the same manner but is not reporting these errors

 

Answer 1

Can you write a seperate DMO app and see what the error is? You can take any sample from BOL. It will be interesting to see the entire exception.