SQL Server 2012 Linked Server to SQL Server 2000

• Qira

  SSCommitted

  Points: 1930

  More actions

  December 24, 2014 at 3:10 am

  #313311

  Hi,

  My SQL Server Instance as following,

  

  I want to setup Linked Server in EPZNS-APP\ZAKATDB (SQL Server 2012). So, I can write query in EPZNS-APP\ZAKATDB to retrieve data or perform transaction in 192.168.1.11 (SQL Server 2000)

  My ODCB with successful connection to 192.168.1.11 as following,

  

  However, my Linked Server was failed. Actually, I do not know - How to fillup the parameter as follow,

  

  It is possible, SQL Server 2012 communicate with SQL Server 2000?

  If yes, please help.

• Shafat Husain

  SSCrazy

  Points: 2754

  More actions

  December 24, 2014 at 3:20 am

  #1766314

  Hi Qira,

  Please refer to the below mentioned link for help on how to create a linked server.

  http://learnsqlwithbru.com/2012/01/06/create-linked-server-to-connect-to-another-sql-server-part-i/

  Very descriptive, Will surely Help.

  Regards,
  Shafat Husain
  🙂
  And Your Lord Never Forgets...!! (64:19 -- Quran)