It is possible, but I wouldn't recommend it.
First of all, it may be problematic to set up. You need to open ports in the firewall (1433 if you're using Sql Server) on both ends of the connection.
Secondly, it may not perform very well. When your database is on the same machine as the web server, or at least in the same network, you have a high-speed, reliable connection. However, when you connect to your database over the internet, things may become slow or unreliable.
Finally, it may be a security risk to open Sql Server ports on your server and web site.
One way to fix this is to use a private (possibly VPN) line between you and the ISP. We have done that in the past and it solves a few of the problems.
Another alternative is to bring the site in, instead of with the ISP. Depending on the site, that may not be a workable solution though.
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|