Re: Can I access my private db through my web server?

(bcanavan@xxxxxxxxxxxx) 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@xxxxxxxxxxxxx

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

.

Relevant Pages

  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: MSVC++ app type choice, form design questions
    ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
    (microsoft.public.vc.mfc)
  • Re: SQL Licensing
    ... it depends on the features you used in your database development. ... If your app works with Express, then go with it not to buy license for SQL Server instances. ...
    (microsoft.public.sqlserver.clients)
  • Re: MSVC++ app type choice, form design questions
    ... >> 1) MSVC Project definition requires that for an MFC app I choose ... At startup the end user sees a summary of the database contents. ... MDAC has full built-in support ... >competing with the full version of SQL Server, ...
    (microsoft.public.vc.mfc)
  • Integrated Security in a Workgroup?
    ... I'm trying to set up a development environment for developing an ASP.Net app ... that needs to access an SQL Server 2000 database. ... On machine "B" (where the SQL Server is running) I had no problem setting up ...
    (microsoft.public.sqlserver.security)