How Do I Create An Exception for SQL Server 2008 in Windows Firewall?

Article ID

ias-6183

Article Name

Created Date

28th April 2008

Product

Problem

If you are running a firewall on the computer that is running SQL Server 2005, external connections to SQL Server and the SQL Server Browser service can communicate through the firewall. You must create an exception for each instance of SQL Server 2005 that you want to accept remote connections.

Resolution

In Windows Firewall

Click the Exceptions Tab

Click Add Program

Click Browse

Locate and Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program

Click Open

Click OK NOTE: The path may be different depending on where SQL Server 2008 is installed. MSSQL.1 is a placeholder for the instance ID that you obtained in KB IAS-6177 NOTE: It may be necessary to repeat these steps should other instances of SQL Server be in place. Related Articles KB IAS-6184 : How Do I Create An Exception for SQL Server Browser in Windows Firewall? KB IAS-6219 : How To Configure Windows Firewall For UDP Port 1434 KB IAS-6220 : How To Configure Windows Firewall For TCP Port 1433 KB IAS-6221 : How To Configure Windows Firewall For TCP Ports

Share This Page

Thank you for your feedback.

Was this useful?

Yes No

We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.

Escalate to Support?

First Name *

Last Name *

Company Name *

Email Address *

Phone Number *

IRIS Feedback *

For information on how we manage your data please view our privacy policy