Create an exception for SQL Server 2005 in Windows Firewall

To create an exception for SQL Server 2005 in Windows Firewall, follow these steps:

• In Windows Firewall, click the Exceptions tab, and then click Add Program.
• In the Add a Program window, click Browse.
• Click the C:\Program Files\MicrosoftSQL Server\MSSQL.1MSSQL\Binn\ sqlservr.exe executable program, click Open, and then click OK.

Note The path may be different depending on where SQL Server 2005 is installed.

MSSQL.1 is a placeholder for the instance ID that you obtained in step 3 of the previous procedure.
Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs an exception.