Re: Ports to open in Windows Firewall for SQL Server 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

That's the trick! Enable the SQL Browser and Port 1433 in the Windows
Firewall and you get both connectivity and the ability to remotely
administer. Thanks!


--
Michael Hockstein


"Roger Wolter[MSFT]" wrote:

> I meant is sqlbrowser enabled through the firewall.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "michael" <howlinghound@xxxxxxxxxxxxx> wrote in message
> news:D7E1B295-425A-47F9-9B9F-7E439508C1A9@xxxxxxxxxxxxxxxx
> > Yes it is enabled and running. I can establish connections if I disable
> > the
> > Windows Firewall on the machine with the SQL Server instance.
> >
> > --
> > Michael Hockstein
> >
> >
> > "Roger Wolter[MSFT]" wrote:
> >
> >> Did you also enable and start the sqlbrowser service?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm
> >>
> >> "michael" <howlinghound@xxxxxxxxxxxxx> wrote in message
> >> news:171212F6-D91C-4A02-AB42-23BEC0C325EB@xxxxxxxxxxxxxxxx
> >> > I'm running the Develpers version of SQL Server 2005 on my developer
> >> > machine.
> >> > I want to test an application from another machine but can neither log
> >> > on
> >> > nor
> >> > use the SQL Server Management Studio from the remote machine unless I
> >> > turn
> >> > off the Windows Firewall on the development machine. (I made sure to
> >> > enable
> >> > remote connections via the Surface Configuration Tool too).
> >> >
> >> > Though I seem to have the correct services listed in the "Exclusions"
> >> > of
> >> > the
> >> > Windows Firewall, I think that I should probably explicitly open the
> >> > ports
> >> > that SQL Server and the Management Studio use. What are the correct
> >> > ports
> >> > or
> >> > is there a better way to work through the Windows Firewall. (This
> >> > problem
> >> > should only exist in my development environment because I would not use
> >> > the
> >> > Windows Firewall in a production setting on the Server)
> >> >
> >> >
> >> > --
> >> > Michael Hockstein
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Home Networking
    ... I can see why you're not getting much connectivity. ... no network adapters or that your network adapters ... OS= Windows XP Home Edition SP1 ... Firewall= Windows Firewall ...
    (microsoft.public.win2000.networking)
  • Re: Printer offline
    ... connectivity by pinging. ... Windows Printing Team ... have a Canon PIXMA MX700 printer connected by a CAT5 cable to the router. ... In order to accomplish the Install I did have to turn off my firewall. ...
    (microsoft.public.windowsxp.print_fax)
  • Re: Automatic Private IP Addressing (APIPA)
    ... This way, if your link will go down, Windows ... I've since learned that CA's eZ Firewall is ... Before I lost connectivity, I noticed my ... base about disabling APIPA but I don't like to mess with the registry. ...
    (microsoft.public.win2000.networking)
  • Re: computer not accessable
    ... I think the problem here coule be with the windows Firewall. ... recommend you to check for the connectivity by disabling the firewall on the ...
    (microsoft.public.windowsxp.network_web)
  • Re: Guide to secure installtion of IIS 5
    ... don't forget a well-configured firewall. ... Do not put the computer onto the network or the Internet until after the ... Follow the instructions for hardening Windows and IIS at ... Install all service packs and security fixes from Microsoft and otherwise ...
    (microsoft.public.inetserver.iis.security)