Firewall – Port 1433 seems to be closed, but it’s enabled on Windows Server 2003 SP1

firewallsql serverwindows-server-2003

today I update the RTM build without any Service Pack to SP1, so Windows Firewall comes available, when I add a new Exception for SQL Server (local) like on Windows XP, I think that it will be work fine than on my local pc but it went wrong, I can ping and do remote desktop connections (3389) also on telnet this port is working but when I try with SQL Default port (1433) it seems to be closed or not mapped cause every configuration on SQL is accepting by default (1433).

Thanks for helpings me to solve this issue.

Best Answer

It would have helped it you had said which version of SQL Server you are trying to install. If you are using SQL 2000 on Windows 2003 you have to install SP2 or higher before SQL can be connected to remotly.