How to configure Windows Firewall on Windows XP or Windows Server 2003

In some cases the Windows Firewall on the server may be blocking access to IRIS from the workstations. In these cases it may be necessary to set exclusions for the SQL Server within the Windows Firewall.

It assumed that the default posts 1433 and 1434 are in use by SQL Server.  Please refer to the topic entitled Understanding SQL Server TCP Ports to establish which ports are in use.

1. Click Start, Control Panel.

2. Open the Windows Firewall:

3. Select the Exceptions tab.

4. Click Add Port.

5. In the Name box enter SQL.

6. In the Port number box enter 1433.

7. Select the TCP option.

8. Click OK.

9. Click Add Port.

10. In the Name box enter SQL.

11. In the Port number box enter 1434.

12. Select the UDP option.

13. Click OK.

14. Click Add Program.

15. Click Browse.

16. Browse to the SQL Server executable file in Program Files.

•  The default location for the SQL Server 2005 Executable files is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn.

•  The default location for the SQL Server 2008 Executable files is C:\Program Files\Microsoft SQL Server\ MSSQL10.IRISPRACTICE \MSSQL\Binn

17. Select sqlservr.exe and click Open.

18. Click OK.