SQL2005 - SQL2000 LinkedServer

• CliveW

  SSC Veteran

  Points: 279

  More actions

  May 28, 2012 at 9:02 am

  #262117

  I'm trying to set-up a LINKEDSERVER between our LIVE database (2005) within a DMZ to another LIVE Database (SQL2000) outside of the DMZ.

  I have had the ip address and port (1433) made available within the DMZ and able to telnet to the server hosting the SQL2000 database from the server hosting the SQL2005 database.

  Now when I try and create the Linked Server getting.

  Named Pipes Provider: Could not be open a connection to SQL Serber [53]

  OLEDB provider "SQLNCLI" for linked server "SQL2000" returned message "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."." (Microsoft Sql Server Error:53)

  Allow connections is enabled on both servers.

  Both Servers are running under administration accounts

  using SQL user for the LINKED Server.

  Any help or suggestions will be great.

  Thanks

  Clive

• CliveW

  SSC Veteran

  Points: 279

  More actions

  May 30, 2012 at 2:51 am

  #1494499

  Have fixed this now, needed to add the complete domain at the end of the server and port, also needed to use a sysadmin account not a user account.