Post reply

Linking to a SQL2000 server from a SQL2016 server

  • August 22, 2018 at 9:00 am

    #376759

    I have set up a link to a SQL2000 server from a SQL2016 server, details as follows:

    • I have used a SQLNCLI10 connection
    • Here is the relevant code for that, that I have used:
      EXEC master.dbo.sp_addlinkedserver @server = N'SQL2000', @srvproduct=N'', @provider=N'SQLNCLI10', @provstr=N'DRIVER={SQL Server};SERVER=SQL2000;'
      /* For security reasons the linked server remote logins password is changed with ######## */
      EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'SQL2000',@useself=N'True',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL
    • Both servers are set to mixed mode
    • I have SA access on both servers
    • I do not want to use a local sql login, I am using a domain login
    • The error I am getting is:
      Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
      OLE DB provider "SQLNCLI10" for linked server "pebbles" returned message "Invalid connection string attribute".
    • I have set up this exact same link from another SQL2016 server to the same SQL2000 server, and that is completely successful
    • The only difference between the SQL2016 server that CANNOT connect and the one that CAN is:
      The one that CANNOT is SP2, and the one that CAN is SP1
    • The SQL2016 servers are both on NT6.3 64 bit
    • The SQL2000 server is on NT5.2 32 bit
    • All of the servers are on the same domain

    Does anyone have any ideas as to why it is that I cannot successfully link from one SQL2016 server to a SQL2000 server, but I can successfully link from another SQL2016 server to the exact same SQL2000 server?

    Thanks in advance.

  • August 22, 2018 at 12:14 pm

    #2002898

    I'd think here that the other server is having issues validating the domain account. It might have lost the connection with the domain controller it uses. Could be time is off or something else. Maybe an SPN error from the NT5 machine.

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

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