Posted by Erland Sommarskog on 10/01/60 11:25

(bcanavan@bmghomes.com) writes:
> Web server: win2003 server with iis6
> DB: sql server 2000
>
> I have 50+ remote offices running an Access 2002 app which connects
> directly to sql server at a 3rd party hosting company, in part using an
> odbc connection on the workstation.
>
> We recently moved our database (and our web site) in-house. The new
> database is inside the firewall but outside the dmz, where it lives
> along side the company's most sensitive databases. IT's policy won't
> allow us to connect directly from the internet. I'm trying to avoid
> buying another copy of sql server for the Access app, which I one day
> hope to drop anyway in favor of
>
> The web server uses port 1433 to talk to the database. I was wondering
> if there is a simple way to route requests from the Access app through
> the web server.

Have you considered setting up a VPN?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Why the performace differs?
• Prev in forum: Re: How to "undo" a delete with cascades
• Thread view: Re: Can I access my private db through my web server?

[Reply to this message]