Thursday, March 22, 2012

Enterprise Mgr quits after SQL2005 registering

I have both SQL2000 (default) and SQL2005 (second instance) on my laptop. Just to see if it could be done, I registered my (Local) SQL2000 default instance in the Registered Servers part of SQL2005 Mgmt Studio. It worked fine. I can see all the SQL2000 databases, etc in the Mgmt Studio.

But now the SQL2000 default instance will not connect in Enterprise Mgr nor can any of the programs that used to connect to the SQL2000 databases now connect to them. The (local) instance shows in Ent Mgr with the green arrow like it is there but Ent Mgr cannot connect when icon is clicked.

Is there anything I can do to bring the default SQL2000 instance back to be able to connect with anything other than the SQL2005 Mgmt Studio?

Do you get an error ? Which one ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

The local node shows in the tree with a white circle with a green arrowhead inside the circle. Which indicates to me that the SQL instance is running and the Ent Mgr sees it. But when I click on the plus beside the node, I get the error:

A connection could not be established to (LOCAL)

Reason: SQL Server does not exist or access denied
ConnectionOpen(Connect())....

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

But I can go to the SQL2005 Mgmt Studio and click on (LOCAL) and see all the stuff in it. In Mgmt Studio, the properties for (LOCAL) show version 8.x of SQLServer.

No comments:

Post a Comment