Firewall on the Server

When you select server installation, the system will automatically open a path for the SQL Server in Windows Firewall, if it is used. You can find the settings for this in the Windows control panel, under Windows Firewall.

If you use other program software with Firewall, you must enter exceptions within the Firewall. How to enter exceptions in your firewall depends on which software you are running. The same exceptions must be entered regardless of what kind of firewall software you are using. Please refer to the documentation for your firewall for further instructions.

Windows Firewall

Below you will find the configurations for Windows Firewall.These are set automatically during the installation. You can check the settings and change them if necessary.

Read more about changing the Windows Firewall settings on Microsoft's website.

How to check the Windows Firewall settings in Windows 7 and above:

1. Open the settings for Windows Firewall via the Windows Control Panel.
2. From the menu on the left, select Allow a program or feature through Windows Firewall.

   

3. Select SQL and click Details.
   • Check the following settings for SQL:
     • Port number: 1433
     • Protocol: TCP

       

4. Click OK.
5. Select sqlbrowser.exe and click Details.
   • Check the following settings for sqlbrowser.exe:
     • Path: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

       

6. Click OK.
7. Select sqlservr.exe and click Details.
   • Check the following settings for sqlservr.exe:
     • Path: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe

       Note! The number after MSSQL can vary dependent on your installation.

       

8. Click OK.
9. If all settings are correct, click OK and close the Control Panel.

You have now checked and, if necessary, adjusted, the settings in the Windows Firewall.

Read more about:

About Multi-user Installations