This article provides basic instructions on how to add exceptions for SQL-related processes to Microsoft Windows Firewall to prevent issues operating CS Professional Suite SQL-based applications. Additional questions about setting firewall exceptions should be directed to your firm's IT professional. You can also refer to the Firewall guidelines for CS Professional Suite applications for more information.
Creating rules
- Open the Control Panel.
- Click Administrative Tools. The path there depends on whether Control Panel is in Category, Small icons or Large icons view.
- In Category view, choose System and Security and then Administrative tools.
- In Small or Large icon view, choose Administrative tools.
- Open Windows Firewall with Advanced Security.
- Click Inbound Rules on the left side of the window and then New Rule on the right side.
- In the New Inbound Rule Wizard dialog, use the following information to create a port exception.
- Select Port
- Select TCP and specify port 1433
- Allow the connection
- Choose all three profiles (Domain, Private & Public)
- Name the rule "SQL Server TCP 1433"
- Click New Rule again and use the following information to create another port exception.
- Select Port
- Select UDP and specify port 1434
- Allow the connection
- Choose all three profiles (Domain, Private & Public)
- Name the rule "SQL Server UDP 1434"
- Click New Rule again and use the following information to create a program exception.
- Select Program
- Click Browse to select sqlservr.exe at the applicable location. Show me.
- Allow the connection
- Choose all three profiles (Domain, Private & Public)
- Name the rule sqlservr.exe
- Click New Rule again and use the following information to create another program exception.
- Select Program
- Click Browse to select sqlbrowser.exe at this location: C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe. If you're working on a 64-bit computer, the sqlbrowser.exe will be in C:\Program Files (x86).
- Allow the connection
- Choose all three profiles (Domain, Private & Public)
- Name the rule sqlbrowser.exe
If connecting a named instance through a firewall, you may need to configure the Database engine to listen to a specific port, so that port can be opened in the firewall. For more information, refer to the Microsoft topic: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)(What's this?).
Was this article helpful?
Thank you for the feedback!
If a firm asks for help beyond the steps listed in this article, this is beyond the scope of support. See Internal: Overcoming objections during systems troubleshooting for positioning on the scope of support.
Users can be directed to this external article regarding scope of support, Contacting our Support team.