URGENT: How to create one linked server....

  • Hello,

    Can anyone tell me how can i create one linked server between one SQL Server 2005 and one SQL Server 2000.

    The point is that when i've tried to create de linked server one error appears to me (see .msg that i attached on this post) and can you tell me why when i tried to create the linked server i check that the provider will be Microsoft OLE DB PROVIDER FOR SQL Server and when the error appears tell me that "Provider SQLNCLI....." 🙁

    Thanks and regards everybody.

    JMSM 😉

  • Unable to see error message.

    Please explain the error you are receiving and direction of linked server you are trying to configure.

    Thanks,

    Phillip Cox

    MCITP - Database Administrator

  • Sorry........ rename the .zip to .msg

    Thanks and regards

    JMSM

  • Hi,

    Couple questions:

    1. What service pack level do you have on SQL 2K and SQL 2K5?

    2. What protocols are enabled on the SQL 2K5 server

    Thanks,

    Phillip Cox

    MCITP - Database Administrator

  • Do you have remote connections turned on in the server.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • Hello,

    The SP in the SQL 2005 is SP2.

    Regards,

    JMSM

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

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