Linked Server from SQL 2005 to SQL 2005

• lijusmail

  Default port

  Points: 1486

  More actions

  December 22, 2008 at 3:49 am

  #195362

  Hi

  I have a server with SQL Server 2005 in one domain(test1.domain.com) and another sql server 2005 in another domain(test2.domain1.com)

  How can i make a Linked Server in test1 pointing to test2.

  I am getting error message "Could not open connection to SQL Server[53]"

  THanks

  Liju

• barsuk

  SSChampion

  Points: 12280

  More actions

  December 23, 2008 at 4:36 pm

  #917156

  How do you connect to that server? I have linked servers running in 3 domains without ( well, almost) problems. Can you verify that there are no blocking on, say port 1433. Make sure that you are connecting to the other server thru qualifying name: myserver.mydomain.com

• TimothyAWiseman

  SSCrazy Eights

  Points: 8819

  More actions

  December 23, 2008 at 5:27 pm

  #917163

  Are you using the Fully Qualified Domain name?

  Also, how do the domains communicate?

  ---
  Timothy A Wiseman
  SQL Blog: http://timothyawiseman.wordpress.com/

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  December 24, 2008 at 6:01 am

  #917329

  please read below articel..you will idea to configure Linked server

  http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/5/

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)