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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-06-28 : 08:28:20
|
| Hi,How can I setup a replication for a database over the firewall over non-trusted NT domains ?Both the servers at the source and the destination are SQL Server 2000 with SP1 . Currently port 1433 is enabled on the firewall and i am able to connect to the destination server only through sa login and password . My replication works well . But i am concerned about the security aspects . The destination SQL server in on the Internet , and i don't know how far it is safe .How can i use NT authentication in such cases . Any help will be appreciated in this regard . Thanks . |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-28 : 08:53:15
|
| Well, the only consequence of having the domains trust each other is that credentials issued by one domain may be used (depending on configuration) to authenticate in the other. Since your domains have no such trust relationship, you'll need to use credentials specific to the domain you're accessing.I would certainly change the port # from the default 1433, and would seriously consider using VPN to carry the traffic.Jonathan Boott, MCDBA |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2002-07-01 : 10:10:58
|
| Hello ,Extremely thanks for your reply . Further can you briefly highlight as to what kind of credentials i need to apply on the domains so that they can only be used for SQL server replication only and not for any other purpose . Is there any way i can connect to the destination SQL Server through Enterprise Manager with the above solution rather than just connecting it through sa login ?How safe is sa login from the above ? Can you please explain to me in brief as i have no expertise in this field. Many thanks. |
|
|
|
|
|
|
Replication over non-trusted NT domains .