Firewall – How to open ports on Windows Server 2003 RTM from the command prompt

command-line-interfacefirewallportwindows-server-2003

I want to open the port number 1433 in Windows Server 2003 Enterprise Edition (5.2, Build 3790) without any Service Pack with out having Firewall, exists a way for achieve this via prompt?

EDIT: I dont have Service Pack 1, so I cant use the firewall option in netsh..

thanks!

Best Answer

If you are running the RTM build you're probably using the Internet Connection Firewall (ICF). KB317530 describes how to open a port if you are using ICF (see step 6).

Edit: I just saw you want to do this via the command line. AFAIK there is no built-in command line interface for ICF. However you could use the Internet Connection Firewall Utility for this. (It's for Windows XP Embedded but it should work on Windows Server 2003.) This MSDN article describes how to use the tool.

Related Solutions

Firewall – Remote connection sql server not working but if firewall disabled it does

Probably you forgot to execute this command:

 netsh firewall set portopening TCP 1433 "SQLServer"

You could try out the new "Fix it" feature of this Microsoft support article: How do I open the firewall port for SQL Server on Windows Server 2008?

The page also contains a script, delete the lines, if you don't need SQL Service Broker, debugger, https etc.

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer" 
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection" 

...

netsh firewall set portopening UDP 1434 "SQL Browser" 
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

Windows – What’s the command-line utility in Windows to do a reverse DNS look-up

ping -a w.x.y.z

Should resolve the name from the IP address if the reverse lookup zone has been set up properly. If the reverse lookup zone does not have an entry for the record, the -a will just ping without a name.

Best Answer

Related Solutions

Firewall – Remote connection sql server not working but if firewall disabled it does

Windows – What’s the command-line utility in Windows to do a reverse DNS look-up

Related Topic