Post reply

Problem Creating Linked Server from SQL 2000 to SQL 2005

  • September 16, 2009 at 8:36 am

    #1054492

    Found this thread while searching for the error of my linked server. I know its an old thread but i would like to contribute something people could try when in agony 😛

    I used SSMS 2005 for creating the linked server on my SQL2000 instance to my SQL2005 instance on another server. I solved the Access Denied error by NOT chosing SQLNCLI as the provider, maybe this helps others with the same kind of problem.

    So...

    Linked Server from SQL 2005 -> SQL 2000 use SQLNCLI as provider.

    Linked Server from SQL 2000 -> SQL 2005 use Microsoft OLEDB Provider for SQL Server.

    Works for me like a charm.

  • September 5, 2012 at 11:40 pm

    #1534227

    FWIW I was able to link from SQL200 to a SQL2008 default instance after some difficulty by using an IP address in place of the server name.

Viewing 2 posts - 31 through 31 (of 31 total)

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