open ports for incoming traffic in SQL Server Configuration and "Windows Firewall"

open ports for incoming traffic in SQL Server Configuration and "Windows Firewall"

These instructions will help identify what port SQL is using

1. Click Start -> Programs -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager
2. In SQL Server Configuration Manager, expand SQL Server Network Configuration and then select Protocols for <instance name> on the left panel. To identify the TCP/IP Port used by the SQL Server Instance, right click on TCP/IP and select Properties from the drop down as shown below.
sql server configuration manager port number
3. In TCP/IP Properties window click on the IP Addresses tab and you will see the Port used by the instance of SQL Server in either TCP Dynamic Ports for a dymanic port or TCP Port for a static port as highlighted in the snippet below. set the TCP dynamic port to "1433" and press ok




How to Open a Ports in the Firewall

Open a port for incoming traffic in Windows Firewall:

Windows Firewall is designed as a security measure for your PC. To put it simply, a firewall analyzes incoming and outgoing connections to determine whether or not they're threats. If you suspect that your Windows Firewall is causing connectivity issues, you can open a port for incoming traffic. Here's how:

  1. Right-click the Start button
      2. Click Search.

      3. Type Windows Firewall.

Click Search. Type Windows Firewall.
      4. Click Windows Firewall.

      5. Click Advanced settings.

Click Windows Firewall. Click Advanced settings.

      6. Click Inbound Rules in the left frame of the window.

      7. Click New Ruleā€¦ in the right frame of the window.


Click Inbound Rules. Click New Rule.

      8. Click Port.

      9. Click Next.


Click Port. Click Next.

      10. Click TCP.

      11. Click Specific local ports and type "1433" and click next

                                                                                   




      12. Click Allow the connection.

      13. Click Next.



Click Allow the connection. Click Next.


      14. Click any Network types you would like to allow the connection over.

      15. Click  Next.

Click any network types. Click Next.


      16. Type a Name for the rule.

      17. Click Finish.


                                                                                                                        

18. Click on New rule again and then again click on port and next.

                                                                              

19. Now this time select "UDP" and select specific ports as "1434" and click next.

                                                                                                                        

20. Select Allow the connections and click next

                                                                        Click Allow the connection. Click Next.
21. Click any Network types you would like to allow the connection over and click next.

                                                                                    Click any network types. Click Next.
22. Now select the name and click finish.

                                                                                                            
    • Related Articles

    • Identify Port used by SQL Server Database Engine Using SQL Server Configuration Manager

      These instructions will help identify what port SQL is using 1. Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager 2. In SQL Server Configuration Manager, expand SQL Server Network ...
    • Fail to connect SQL Server

      If you ever see this error when starting the ADEL software, follow the steps below to restart SQL: Windows 10 – Open ‘Computer Management’ by right-clicking the start icon (bottom left) NOTE: For Windows 7 – Left-click on the start icon and ...
    • Install SQL Server for Lock-S

      The first step when installing Lock-S software is to install the server. Follow the steps below. If you get stuck, free support is available during Business Hours  Step # 1 Download SQL Click on the URL to Download the SQL setup file.  SQL Server ...
    • Download and Install KAS SQL Auto Backup Tool (Windows only)

      KAS SQL Database Backup Tool Please click on the following link to download the KAS Auto Backup Tool:  Download Backup Tool Double click on the KAS Back Tool setup  Click Next Keep clicking Next until you see the following screen and then click ...
    • Connecting to the SQL Server from the different computer

      Before connecting  make sure your local computer (where lock-S software is installed) and your Server computer (where your SQL database is installed) are both on the same network. Step # 1: Double click on the lock-s software and you will see the ...