Database Access over Internet

I was wondering if any body has used Internet as a WAN (Wide Area
Network) to provide database access. I know about web services but I
like to experiment with using Internet as a extended network (web
server behind one router and database behind another). Any ideas on
where to look for this?

Thanks

Hi

Are you talking about a VPN? Check on whether your firewall(s) will support
this.
Also:
http://support.microsoft.com/defaul...kb;en-us;323441

John

<le_mo_mo@yahoo.com> wrote in message
news:1129345377.971147.100230@f14g2000cwb.googlegroups.com...
>I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
>
> Thanks
>

<le_mo_mo@yahoo.com> wrote in message
news:1129345377.971147.100230@f14g2000cwb.googlegroups.com...
>I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
>
> Thanks

Not the internet, but I used a wide area network a few years ago to
replicate a large SQL Server database across. The WAN ran at 64kbps, and it
struggled but we were replicating across half a dozen production sites.

So be aware that there may be a serious performance hit - it depends a lot
on the upload and download speeds at both ends of the connection and the
types of queries that you might be doing. Timeouts may also be an issue. Do
a serious assessment of the volumes of data you are likely to be moving.

As John has rightly pointed out, use a VPN.

Hope this helps.
--
Brian Cryer
www.cryer.co.uk/brian

le_mo_mo@yahoo.com  wrote:
> I was wondering if any body has used Internet as a WAN (Wide Area
> Network) to provide database access. I know about web services but I
> like to experiment with using Internet as a extended network (web
> server behind one router and database behind another). Any ideas on
> where to look for this?
>
> Thanks
>
Interesting idea,

Personally, I wouldn't trust public access without being able to filter
traffic though a PIX and a web service but please let me know how you
get on.

Regards

Jon