sql server connect: Hi Folks,

Did anyone ever come across this ? Go to register a new server in enterprise manager, input the details and get the
above message. Same server can be contacted using query analyser and can be pinged so it is contactable ok. Just can't connect to it (or any other server) in this installation of sql server.

Thanks in Advance (hopefully !)

Eileen.

That error usually indicates a problem with the MDAC components. If you
don't have MDAC 2.6 sp2 already, I would recommend updating the machine.
Make sure that IIS, SQLServer and any other components that use MDAC are
stopped before updating the components.

http://www.microsoft.com/downloads/details.aspx?FamilyID=8e5f816c-4918-4250-
b8bd-3794582c9089&DisplayLang=en

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

You could try just uninstalling and re-installing the client components for
SQL.

Otherwise, you need to do more investigation.

Try running regmon.exe and filemon.exe from www.sysinternals.com
This will help you narrow down the scope of the component.

Regmon.exe will identify the problem component in the registry.
Then, search the registry for the classid provided, you will find
associated dll's
Search under HKEY_CLASSES_ROOT\CLSID
You will find a key
HKEY_CLASSES_ROOT\CLSID\00100100-1816-11D0-8EF5-00AA0062C58F
(or the guid related showin in the error message)
Under the key click on InProcServer32, you will find the dll, associated
with the
GUID.

-Unregister the dll,
-Replace the dll from the CD of the program you are trying to use (In this
case,
SQL 2000 )
-Register the dll,
-If this fixes the problem, you are done.


Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Great! There is a rollback feature with MDAC 2.6, and 2.7

322170 PRB: Rollback from MDAC 2.6 Service Pack 2 Refresh Fails
http://support.microsoft.com/?id=322170


Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.