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 - 2003-07-28 : 04:49:15
|
| Hi ,I have a Webserver and Database server , but both are in different zones seperated by Firewall . There is no comm. possible between them except through 1433 . During normal transactions , the webserver talks to the database server only through 1433 port . What I am looking for is whether there is any utility in SQL server where I could copy some text files fom the Webserver to the DB server . Actually I have a log file which needs to be imported into the database server which will be massaged to get the required output in text file again and put it back on the web server . But all this is not possible as there is no way of communication between these two servers except for 1433 . Can i use any any of the SQL server tools or features ( Isql , bcp or xp_cmdshell )where I could put the file on the DB server through only 1433 ? I tried xp_cmdshell to copy but still it does not use 1433 , i believe . Thanks .I keep trying to lose weight but it always finds me. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-07-28 : 05:12:34
|
| To use xp_cmdshell to copy files you would need port 113 open for Windows networking.You could use BCP or DTS to open a text file locally and send the data to a remote server.You would actually be in a safer position though if you closed 1433 and set up a VPN between the 2 servers.Damian |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-07-28 : 05:43:15
|
| Hello Merkin ,Thanks for your reply . But even BCP and DTS will use 1433 SQL port ,will they use 1433 port for communication ? Thanks once again .I keep trying to lose weight but it always finds me. |
|
|
|
|
|
|
Copy files through SQL utilities !! Possible ??