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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Transaction Replication to DMZ

Author  Topic 

amsqlguy
Yak Posting Veteran

89 Posts

Posted - 2011-03-21 : 17:58:10
Guys,

Is there any standard procedure to setup SQL 2008 Transaction to DMZ - like what prots are recommended, should sql borwser need to be turned off on SQL Instance in
DMZ etc.

Any suggestions/inputs would help.

Thanks

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2011-03-25 : 11:26:53
important is if the servers involved are not members of the same domain or they do not have trusted connections between them, you should use certificates

not sure if you want to turn on the DMZ though especially if you've taken your time to evaluate what is the best tcp port for your sql instances as sql browser will aid in connecting with only the instance name without the port number

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -