Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I Just want to open the 1433 port for SQL Server locally, please I dont know who config this server so when I try netsh firewall , prompt saids "the command not exits" by the way routing and nat are disabled

I cannot find Windows Firewall Option on this Server, thats the most rarely!

Server Version : Windows Server 2003 Enterprise Edition (5.2, Build 3790) without any Service Pack

Thanks!

alt text

share|improve this question

4 Answers 4

up vote 4 down vote accepted

According to the Wikipedia article the Windows Firewall for Windows Server 2003 was introduced with Service Pack 1. Therefore it is not included in the RTM build which you are running.

After the installation of Service Pack 1 (or better Service Pack 2) you should be able to access the feature.

This Technet page describes the changes to the firewall in Service Pack 1 in more detail.

share|improve this answer

Try opening the Windows Firewall UI from the Start Menu's Run command:

  • Start-> Run
  • firewall.cpl

You should have the Windows Firewall now.

If the Windows Firewall isn't able to run on your system, consider updating your system to Windows 2003 Service Pack 2 or better.

share|improve this answer
    
please check the image above –  Angel Escobedo Jul 18 '09 at 18:50
    
Thanks to Albic, it appears there IS no Windows Firewall pre-SP1. Of course, it's always recommended to keep up with security fixes. Are you able to apply those service packs? –  p.campbell Jul 18 '09 at 19:54

Go to the Control Panel and double-click on Windows Firewall. It will ask you if you want to start ICS, say yes, then you should be able to add the exception there. Don't forget to add exceptions for RDP and www if you use it.

share|improve this answer
    
I cant find Windows Firewall on Control Panel thanks –  Angel Escobedo Jul 17 '09 at 22:24
    
Not sure how, but it sounds like the Windows Firewall has been removed. Does the Windows Firewall service exist in the service list? –  mrdenny Jul 17 '09 at 22:33
    
omg not exists! –  Angel Escobedo Jul 17 '09 at 22:37
    
Hm that is no good. Do you have an Anti-Virus program installed? If not, install AVG or something and give it a scan. The firewall is not something that can be easily installed/uninstalled. –  Adam Brand Jul 17 '09 at 22:38
    
When I begin with this since 2 months ago... MacAffe was installed nowadays the AV is NOD32 –  Angel Escobedo Jul 17 '09 at 22:42

Looks like you may not have the Windows Firewall afterall... :)

But your main goal seems to be to enable connectivity to your SQL Server instance. Since I don't know what version/edition of SQL Server you have but I am guessing that you have SQL 2005 as 2008 would not install on Win2003 RTM. So here is a useful link: http://support.microsoft.com/kb/914277/en-us

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.