Post reply

Linked Server Problem between SQLServer 7 & 2000

  • May 25, 2005 at 8:16 am

    #164818

    We are running several SQL Servers at my company.

    We have most on SQL Server 7 on a Windows 2000 Server and two on SQL Server 2000 on Windows 2003 Server.

    I have set up a linked server between the two Sql Server 2000 machines fine and a linked server from the SQL Server 2000 server to the SQL Server 7 server.

    I have tried to set up a linked server from the SQL Server 7 machine to either of the SQL Server 2000 machines and I get the Error 17 : SQl Server does not exist or access denied.

    I'm not sure what the problem is ?

    J.

  • May 25, 2005 at 9:27 am

    #561001

    Are SQL Server 2000 running as named instances?

  • May 25, 2005 at 9:32 am

    #561003

    I have done a query on this and the instance name is NULL.

    J.

  • May 25, 2005 at 1:56 pm

    #561089

    If it is a default instance, youcan run sp_addserver 'servername' and register the server. for named instance, you will have to run sp_addserver 'servername\instance_name'

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

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