SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014:
- Go to Start, Programs, Microsoft SQL Server 2008 / Microsoft SQL Server 2008 R2 / Microsoft SQL Server 2012 / Microsoft SQL Server 2014, Configuration Tools, SQL Server Configuration Manager
- Expand SQL Server Network Configuration, and highlight Protocols for MSSQLSERVER
- In the details pane, right click TCP/IP, and select Properties
- Select the IP Addresses tab
Note: In addition to the above TCP port, UDP 1434 must also be opened to allow discovery of the TCP port.
For more information, see How to Configure a Windows Firewall Database Engine Access
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.