SQL Server Open To Internet

From: Alquin (alquin@mail.com)
Date: 03/02/03


From: "Alquin" <alquin@mail.com>
Date: Sat, 1 Mar 2003 21:00:04 -0800


Hello,

I am pretty new to SQL Server and security, but I was
wondering if someone could help me understand this a
little more.

Where I work, we have SQL Server hosted remotely. We can
connect to it using Enterprise Manager, but the firewall
that the SQL Server is behind will only allow inbound
traffic coming from my work;s IP address.

My question is...
Do people run SQL Server on the internet, without this
kind of firewall protection?

Would I be putting myself in harms way to allowing querys
against my server by applications that are running in
different locations? ( I know that it would be MORE
risky, but is this something that people do, or am I crazy
to be doing it? )

I need people to be able to do mail merges on their local
machine from data on the SQL Server. I could write an
application that grabbed the data from the server and
saved it locally for them, or they could use Enterprise
Manager to connect and export the data to their local hard
drive.



Relevant Pages

  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • RE: Upgrading to SQL 2005 ENT
    ... I left the reporting services off. ... It gives a good step by step how to on upgrading to SQL Server 2005. ... some SQL Server features will not be available for installation. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • RE: Upgrading to SQL 2005 ENT
    ... Microsoft SQL Server 2005 9.00.1399.06 ... some SQL Server features will not be available for installation. ... not the sql server management studio or enterprise manager. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)
  • RE: Upgrading to SQL 2005 ENT
    ... Microsoft SQL Server 2005 9.00.1399.06 ... some SQL Server features will not be available for installation. ... not the sql server management studio or enterprise manager. ... It has the same version from the Enterprise Manager. ...
    (microsoft.public.sqlserver.server)

Quantcast