Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
junior.carls
Starting Member
7 Posts |
 Posted - 2009-03-09 : 16:02:59
|
| Hi all,We have a set up where we have a database on the outside of our firewall and one on the inside. We want to establish a link between them (linked server) but want to ensure that only the internal server can initiate connections to the outside server and not the other way around. So my question is this... is that possible woth linked servers and what ports need to be opened on the firewall both inbound and outbound.Cheers. |
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-09 : 18:25:29
|
| Lo :)...You'll need to open port 1433 for communication. As for initiating communication; only link the server on your internal server and not external. So create a new login on external server which the internal server can map to. This way only time information is exchanged when internal server asks for something. To the external server it just looks like another remote connection. Thanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
 |
|
|
|
|
|
Linked Servers and Firewal Configuration