I have a server running SQL 2005 as the default instance, and sql server 2000 running as a named instance called SQL2000. When I try to connect to my SQL instance Servername\SQL2000, i am actually connected to my SQL 2005 instance. When I connect using SQL 2000's Entreprise manager, i get the error saying you need to use SQL 2005 connectivity tools. Any Ideas?
You can connect to SQL2K using 2K5 tools. Follow the directions at this link:
http://msdn2.microsoft.com/en-us/library/ms345332.aspx
|||
Sorry, but when i connect to the sql2000 instance using 2005 tools, i connect to the defuaalt SQL instance on this machine which is sql2005.
When I use Entreprise manager from the local system, i can connect to the sql 2000 instance just fine.
|||Can you post the exact steps your doing including exactly what you're typing in and where?
Cheers,
Dan
No comments:
Post a Comment