Ports to open in Windows Firewall for SQL Server 2005



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: Ports to open in Windows Firewall for SQL Server 2005
    ... Windows Firewall on the machine with the SQL Server instance. ... >> remote connections via the Surface Configuration Tool too). ... >> Michael Hockstein ...
    (microsoft.public.sqlserver.connect)
  • Re: Ports to open in Windows Firewall for SQL Server 2005
    ... Did you also enable and start the sqlbrowser service? ... > use the SQL Server Management Studio from the remote machine unless I turn ... > off the Windows Firewall on the development machine. ... What are the correct ports ...
    (microsoft.public.sqlserver.connect)
  • Re: Copy Database Wizard and Windows Firewall
    ... Database Wizard to copy a database from machine B to machine A. Both ... If Windows Firewall is ... you would need to open the port on which SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Copy Database Wizard and Windows Firewall
    ... Database Wizard to copy a database from machine B to machine A. Both ... If Windows Firewall is ... you would need to open the port on which SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Ports to open in Windows Firewall for SQL Server 2005
    ... If your connecting fine to the database and it accepts data exchange, ... > the SQL Server Management Studio. ... >>> off the Windows Firewall on the development machine. ... >>> ports ...
    (microsoft.public.sqlserver.connect)

Loading