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 |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2006-03-05 : 15:20:10
|
| Hi,I would like to transfer my SQL Database very often to my Web site hosted somewhere in USA. I want to use DTS for that using SQL Server ENTPRISE MANAGER.Now I have everything in place, I know the IP address of the remote server, and I have created the database there as well.But problem is here, when i wen to register that Remote sql server, that it says access denied. I asked my local admin, how can I access to that remote server, then he says that you need to provide the protocol and port, so that he can allow it from firewall. can i know what protocol SQL Server uses to communication? i think TCP/IP and port by default 4333? am I right?and at last, I need to know the best practise to update my data on remote web server? I mean syncronizing.Thanks heaps.ByeSKR |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-03-05 : 16:28:07
|
| protocol is TCP/IP Port is 1433 by default unless changed by your remote host.To register your server use the domain name of your MS SQL server and not the IP. |
 |
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2006-03-05 : 21:02:37
|
| Thx It is sorted, allowing it at firewall end.What about the best proctise to transfer data? due to DTS or SQL server Replication?Thanks very muchSKR |
|
|
|
|
|
|
DTS to Remote servers