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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-02 : 09:03:57
|
| andy writes "I run an dating site - www.loveandfriends.com - that uses SQL7 on Windows 2000. Occasionally it would be useful to access the SQL data on our live server (on the other side of town) from our backup Webserver (in our office). Basically I want to send out lots of emails from the backup machine when the 'live' server's SMTP connection goes down. Otherwise all the members have to wait until our ISP fixes whatever SMTP promlem they have for their messages to be sent out.So is there any way to remotely connect to the SQL Server on our live webserver (which has a static IP address) and grab the data off it?Andy Maccabe" |
|
|
|
|
|
accessing a SQL SErver via the internet