Post reply

Linking SQL Server 2000 to 2005

  • February 9, 2012 at 7:39 pm

    #251347

    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

  • February 10, 2012 at 5:57 am

    #1445491

    John Bates-251278 (2/9/2012)

    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

    I think, if you have one way either 2005 to 2000, it should be fine.

    Is there any particular reason why you want the other way 2000 to 2005 ??

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 10, 2012 at 6:39 am

    #1445512

    Thanks for your reply.

    The consultant asked to be able to connect from the 2000 server.

    And because his software is installed on that server, that is also my preference.

    At this point, I would like to better understand why it doesn't work both ways.

    Thanks, John

  • February 10, 2012 at 5:40 pm

    #1445839

    The Linked Server connection is working well without me making any changes.

    We can close this post.

    Thanks, John

  • February 13, 2012 at 6:31 am

    #1446201

    John Bates-251278 (2/10/2012)

    The Linked Server connection is working well without me making any changes.

    We can close this post.

    Thanks, John

    How come ??

    Regards,

    Skybvi

    Regards
    Sushant Kumar
    MCTS,MCP

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply