To Establish Linked Server

Question

Hi ,

How to created a linked server between Server 1( Internet zone) and Server 2 (Intranet zone) ?

I am trying to create a linked server in server 1(Internet zone say xxx.xx.xxx.xxx) of server2(Intranet zone yyy.yy.yyy.yy). The port number 1433 has been open already and still not able to add the server2 in server 1.

Please advice..

Thanks,

Arul

Answer 1

Hi,

The first thing you need is that you can access you other server from this server.

Try to use SSMS and connect to yyy.yy.yyy.yy from xxx.xx.xxx.xxx if you connected successfully you can create your link server by Right click on server object -> Linked Server choose new linked server.

I hope this is helpful.

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid

MCTS: SQL Server Administration/Development

MyBlog

Answer 2

1) Try to telnet port 1433 from Server 1 to server 2

2) Share the error message you are getting while creating linked server

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

Answer 3

It has been a couple of days since you posted.   Have you had any progress? 

You might find the answer from Steph.Gibbs useful in this post. He mentions port 1436 and a blog from the SQL Protocols team.  (Tip:  Always check SQL Protocols for issues like this.)

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/1046d98e-b1fc-4964-8a6e-08c406032d7e

Hope it helps,

RLF