6. srpna 2012 5:23
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.
6. srpna 2012 5:38
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
8. srpna 2012 13:19
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!
- Upravený RohitGargMicrosoft Community Contributor 8. srpna 2012 13:19
8. srpna 2012 15:37
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.)
Hope it helps,
- Označen jako odpověď Iric WenModerator 13. srpna 2012 9:10