This should be easy but maybe I have forgot a lot about version 2000.
On a 2000 instance, I created a linked server to a 2005 instance on another server. The Linked Server uses a very restricted SQL Server login.
But I am not able to test the connection on the 2000 server because I cannot register the server using the local login because it gives error "A server with that name already exists".
(I created a linked server on my 2005 instance to 2000 and that worked fine. But I need to go the other way, 2000 to 2005)
What am I missing?
Thanks, John
On a 2000 instance, I created a linked server to a 2005 instance on another server. The Linked Server uses a very restricted SQL Server login.
But I am not able to test the connection on the 2000 server because I cannot register the server using the local login because it gives error "A server with that name already exists".
(I created a linked server on my 2005 instance to 2000 and that worked fine. But I need to go the other way, 2000 to 2005)
What am I missing?
Thanks, John
