Assistance

From: hdonovan (hdonovan@pyrontechnologies.com)
Date: 10/12/02 

From: "hdonovan" <hdonovan@pyrontechnologies.com>
Date: Fri, 11 Oct 2002 20:53:02 -0700

Hello

First of all I want to thank anyone for any assistance
that they might be able to offer.

My question is how to maintain security over a public
network with 2 sql servers and 1 web server (IIS).

Currently, one sql server and web server are on the same
machine. It is currently running various functions for
the website ( content management, navigation, etc. ).
Another sql server is located at their location which
handles their day to day business. Currently, they want
to tie in some real time data located at their remote
location with the functionality of their current website.
This would include orders and product information for
example. So orders from the web would be handled in their
inventory receiving, and any new products would be seen
on the website, instantly.

The website application is currently programmed using
ASP. If I connect to a remote location sql server using
IP and connectionstring, will I be compromising security
over the internet? If so, how can I resolve this?

One solution that was discussed was synchronization of
the 2 databases. When sql servers communicate with each
other through DTS,import/export, etc, is this
communication encrypted?

Any suggestions will greatly be appreciated.

Thanks

Relevant Pages

  • Re: Firewall Affecting Website Page Load Speed?
    ... all of the others have one or two images on the page. ... I am hosting this website at home on a machine running Windows XP Pro ... You're using IIS on Windows XP. ... You have SQL Server running on the same box. ...
    (comp.security.firewalls)
  • Re: Cannot connect to database
    ... when you use iis, its uses the aspnet account which is local and is probably not set up to access your sqlserver. ... I open Visual Web Developer 2008 express on desktop and Select File>open Website, and browse to a folder on DevBox. ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.dotnet.framework.aspnet)
  • access internal SQL server from 3rd party web server
    ... We publish our pages in a 3rd party web server, so they host our website. ... traffic needs go through our router before reach the SQL server, ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Replacing ISAPI web authentication filter with .NET solution?
    ... and give the user access to our website. ... SQL Server ... With the current setup, user id, password and the network user id are ... our web server. ...
    (microsoft.public.dotnet.general)
  • How to connect to our internal SQL Server from outside webserver
    ... We publish our pages in a 3rd party web server, so they host our website. ... traffic needs go through our router before reach the SQL server, ...
    (microsoft.public.sqlserver.connect)