Cant Use SQL Server with Firewall

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,

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

"Michael Culley" <mculley@.NOSPAMoptushome.com.au> wrote in message
news:e7EaQbtZDHA.2932@.tk2msftngp13.phx.gbl...
> You probably need to open port 1433.
> --
> Michael Culley
>
> "Neil Ginsberg" <nrg@.nrgconsult.com> wrote in message
news:gzC0b.560$lw4.409@.newsread3.news.pas.earthlin k.net...
> > 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|||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
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@.newsread3.news.pas.earthlin k.net...
> 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@.NOSPAMoptushome.com.au> wrote in message
> news:e7EaQbtZDHA.2932@.tk2msftngp13.phx.gbl...
> > You probably need to open port 1433.
> > --
> > Michael Culley
> > "Neil Ginsberg" <nrg@.nrgconsult.com> wrote in message
> news:gzC0b.560$lw4.409@.newsread3.news.pas.earthlin k.net...
> > > 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
> >|||Thanks.

"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OtsXhqvZDHA.1640@.TK2MSFTNGP10.phx.gbl...
> 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
> 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@.newsread3.news.pas.earthlin k.net...
> > 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@.NOSPAMoptushome.com.au> wrote in message
> > news:e7EaQbtZDHA.2932@.tk2msftngp13.phx.gbl...
> > > You probably need to open port 1433.
> > > > --
> > > Michael Culley
> > > > > "Neil Ginsberg" <nrg@.nrgconsult.com> wrote in message
> > news:gzC0b.560$lw4.409@.newsread3.news.pas.earthlin k.net...
> > > > 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
> > > > > >