Re: SQL Server / Firewall Security

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 03/10/03 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Mon, 10 Mar 2003 08:01:59 -0600

Below is a link to the thread Denny referred to. This situation is why
the same question shouldn't be posted independently to multiple groups.

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&th=94a5039dc612cf74&rnum=1 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"V" <fortleeder@yahoo.com> wrote in message
news:01a501c2e70a$ed341d60$3401280a@phx.gbl...
> Denny,
>
> I need the similar help as well.
> Your answer is like no answer.  Would you please be more
> specific about looking the responces in
> microsoft.public.sqlserver.server.......
> Please give us the subject title or by sent date in the
> database for us to search the similar help.
>
> Your extra effort will be highly appreciated.  Thanks.
>
> V
>
>
> >-----Original Message-----
> >See responces in microsoft.public.sqlserver.server
> >
> >--
> >Denny Cherry
> >Database Administrator
> >GameSpy Industries
> >
> >"MarkA-UK" <mark@nospamineed.nospam> wrote in message
> >news:u34bIkm4CHA.2240@TK2MSFTNGP10.phx.gbl...
> >> People,
> >>
> >> Before I start with the main question please just
> assume the term firewall
> >> can be any type of firewall not necessarily ISA,
> Checkpoint or anything
> >like
> >> that specific.
> >>
> >> If I have an SQL server on the internal side of the
> firewall containing my
> >> full database and a SQL server on the outside of my
> firewall containing a
> >> public sub set of my main internal database data for my
> website, what
> >ports
> >> etc do I need to open up on my firewall if I want to
> replicate data from
> >the
> >> internal server to the external (PUSH)?
> >>
> >> I know that the standard port is 1433 but I am guessing
> that's a real
> >> security risk. If I was the change the SQL server ports
> would that affect
> >> all my internal users?? if so then I cant do that.
> >>
> >> You thoughts / ideas / suggestions on best practices
> would be greatly
> >> appreciated.
> >>
> >> Cheers
> >> Mark.
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: SQL Server / Firewall Security
    ... database for us to search the similar help. ... >See responces in microsoft.public.sqlserver.server ... >> can be any type of firewall not necessarily ISA, ... >> If I have an SQL server on the internal side of the ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Workgroup Edition
    ... First of all, when you create a database, you can always specify the path. ... But I believe you can change this at Setup as well. ... Currently it does not work unless I turn off the firewall. ... But you are not planning to expose SQL Server on the Internet, ...
    (microsoft.public.sqlserver.setup)
  • RE: unknown error - after months of working
    ... "Marc Pelletier" wrote: ... I can't even log in to the database. ... I've disabled the firewall. ... > I'm a programmer who only occasionally uses sql server, ...
    (microsoft.public.sqlserver.msde)
  • Re: web server dmz sql server
    ... on the lan for the database. ... how I like to do it is to put SQL on a dedicated port of the ... firewall. ... traffic into the SQL server, but prevent the SQL server from being able ...
    (microsoft.public.sqlserver.security)
  • Re: Connectivity Issues - Bizzare
    ... Sounds like firewall to me. ... >I am trying to connect to a default instance of SQL Server 2000 Enterprise ... I create a SqlDataAdapter on the web form, ... I take the same connection string from the web app, ...
    (microsoft.public.sqlserver.connect)