Can't Use SQL Server with Firewall

[Neil Ginsberg]

My ISP recently had me reset my TCP/IP stack. After that, Norton Personal
Firewall prompted me twice that SQL Server was trying to access the
Internet. Both times I responded to allow it to and to always use that
action. Now I am not able to use SQL Server with NPF enabled. If I disable
NPF, SQL Server works fine.

I am using the desktop edition of SQL Server 7, on a standalone PC, not
connected to a server. I have been using SQL Server and NPF together for
over a year. Now, since my TCP/IP stack was reset, NPF interferes with SQL
Server.

Anyone have any experience with this?

Thanks,

Neil

[Neil Ginsberg]

Re: Can't Use SQL Server with Firewall

Not sure how to do that. Can allow an IP to be trusted, but don't see how
one specifies a port.

"Michael Culley" <mculley@NOSPAM optushome.com.a u> wrote in message
news:e7EaQbtZDH A.2932@tk2msftn gp13.phx.gbl...[color=blue]
> You probably need to open port 1433.
>
> --
> Michael Culley
>
>
> "Neil Ginsberg" <nrg@nrgconsult .com> wrote in message[/color]
news:gzC0b.560$ lw4.409@newsrea d3.news.pas.ear thlink.net...[color=blue][color=green]
> > My ISP recently had me reset my TCP/IP stack. After that, Norton[/color][/color]
Personal[color=blue][color=green]
> > Firewall prompted me twice that SQL Server was trying to access the
> > Internet. Both times I responded to allow it to and to always use that
> > action. Now I am not able to use SQL Server with NPF enabled. If I[/color][/color]
disable[color=blue][color=green]
> > NPF, SQL Server works fine.
> >
> > I am using the desktop edition of SQL Server 7, on a standalone PC, not
> > connected to a server. I have been using SQL Server and NPF together for
> > over a year. Now, since my TCP/IP stack was reset, NPF interferes with[/color][/color]
SQL[color=blue][color=green]
> > Server.
> >
> > Anyone have any experience with this?
> >
> > Thanks,
> >
> > Neil
> >
> >[/color]
>
>[/color]

[Allan Mitchell]

Re: Can't Use SQL Server with Firewall

Here is a response from John Gose MS PSS

For SQL and a firewall, the general rule is 1433 in ( or whatever port your
SQL Server is listening on) and any out. See first reference. As far as
DTC, if you are using it, the second article should help

287932 INF: TCP Ports Needed for Communication to SQL Server Through a
Firewall

http://support.microsoft.com/?id=287932

250367 INFO: Configuring Microsoft Distributed Transaction Coordinator
(DTC) to

http://support.microsoft.com/?id=250367

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA

https://www.SQLDTS.com

I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Neil Ginsberg" <nrg@nrgconsult .com> wrote in message
news:EHG0b.824$ lw4.154@newsrea d3.news.pas.ear thlink.net...[color=blue]
> Not sure how to do that. Can allow an IP to be trusted, but don't see how
> one specifies a port.
>
> "Michael Culley" <mculley@NOSPAM optushome.com.a u> wrote in message
> news:e7EaQbtZDH A.2932@tk2msftn gp13.phx.gbl...[color=green]
> > You probably need to open port 1433.
> >
> > --
> > Michael Culley
> >
> >
> > "Neil Ginsberg" <nrg@nrgconsult .com> wrote in message[/color]
> news:gzC0b.560$ lw4.409@newsrea d3.news.pas.ear thlink.net...[color=green][color=darkred]
> > > My ISP recently had me reset my TCP/IP stack. After that, Norton[/color][/color]
> Personal[color=green][color=darkred]
> > > Firewall prompted me twice that SQL Server was trying to access the
> > > Internet. Both times I responded to allow it to and to always use that
> > > action. Now I am not able to use SQL Server with NPF enabled. If I[/color][/color]
> disable[color=green][color=darkred]
> > > NPF, SQL Server works fine.
> > >
> > > I am using the desktop edition of SQL Server 7, on a standalone PC,[/color][/color][/color]
not[color=blue][color=green][color=darkred]
> > > connected to a server. I have been using SQL Server and NPF together[/color][/color][/color]
for[color=blue][color=green][color=darkred]
> > > over a year. Now, since my TCP/IP stack was reset, NPF interferes with[/color][/color]
> SQL[color=green][color=darkred]
> > > Server.
> > >
> > > Anyone have any experience with this?
> > >
> > > Thanks,
> > >
> > > Neil
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Neil Ginsberg]

Re: Can't Use SQL Server with Firewall

Thanks.

"Allan Mitchell" <allan@no-spam.sqldts.com > wrote in message
news:OtsXhqvZDH A.1640@TK2MSFTN GP10.phx.gbl...[color=blue]
> Here is a response from John Gose MS PSS
>
> For SQL and a firewall, the general rule is 1433 in ( or whatever port[/color]
your[color=blue]
> SQL Server is listening on) and any out. See first reference. As far as
> DTC, if you are using it, the second article should help
>
> 287932 INF: TCP Ports Needed for Communication to SQL Server Through a
> Firewall
> http://support.microsoft.com/?id=287932
>
> 250367 INFO: Configuring Microsoft Distributed Transaction Coordinator
> (DTC) to
> http://support.microsoft.com/?id=250367
>
>
> --
>
> ----------------------------
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
>
> "Neil Ginsberg" <nrg@nrgconsult .com> wrote in message
> news:EHG0b.824$ lw4.154@newsrea d3.news.pas.ear thlink.net...[color=green]
> > Not sure how to do that. Can allow an IP to be trusted, but don't see[/color][/color]
how[color=blue][color=green]
> > one specifies a port.
> >
> > "Michael Culley" <mculley@NOSPAM optushome.com.a u> wrote in message
> > news:e7EaQbtZDH A.2932@tk2msftn gp13.phx.gbl...[color=darkred]
> > > You probably need to open port 1433.
> > >
> > > --
> > > Michael Culley
> > >
> > >
> > > "Neil Ginsberg" <nrg@nrgconsult .com> wrote in message[/color]
> > news:gzC0b.560$ lw4.409@newsrea d3.news.pas.ear thlink.net...[color=darkred]
> > > > My ISP recently had me reset my TCP/IP stack. After that, Norton[/color]
> > Personal[color=darkred]
> > > > Firewall prompted me twice that SQL Server was trying to access the
> > > > Internet. Both times I responded to allow it to and to always use[/color][/color][/color]
that[color=blue][color=green][color=darkred]
> > > > action. Now I am not able to use SQL Server with NPF enabled. If I[/color]
> > disable[color=darkred]
> > > > NPF, SQL Server works fine.
> > > >
> > > > I am using the desktop edition of SQL Server 7, on a standalone PC,[/color][/color]
> not[color=green][color=darkred]
> > > > connected to a server. I have been using SQL Server and NPF together[/color][/color]
> for[color=green][color=darkred]
> > > > over a year. Now, since my TCP/IP stack was reset, NPF interferes[/color][/color][/color]
with[color=blue][color=green]
> > SQL[color=darkred]
> > > > Server.
> > > >
> > > > Anyone have any experience with this?
> > > >
> > > > Thanks,
> > > >
> > > > Neil
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]