Firewall Exceptions for SQL Server

Firewall Exceptions for SQL Server

Overview

SQL Server uses both TCP and UDP ports for communication. It is necessary to allow these ports through the firewall. 

TCP Incoming Ports

  1. 1433
  2. 4022
  3. 135
  4. 1434

UDP Incoming Ports

  1. 1434

    • Related Articles

    • Troubleshooting a SQL Server Connection

      Overview If you are unable to connect to a SQL database, you can perform what's called a UDL test which uses a built-in SQL Server OLE DB provider to test SQL connections. This is done independent of any software application and is a great ...

    • How to Allow Ping Responses on a Windows Computer

      Overview If you're unable to ping a computer that is confirmed to be on the network, try some of these solutions. Requirements Local Administrator Rights General Knowledge of Windows Network and Firewall Options to Allow Ping Responses Set network ...

    • How to Enable .NET Framework 3.5

      Overview Windows 10 and 11 no longer comes with .NET 3.5 enabled by default. In addition, it may not allow you to install .NET 3.5 from an installer. You can enable it via Windows Features. To enable .NET Framework 3.5 on Windows Server OS, you must ...

    • How to Use NETSTAT to Locate TCP Socket Connections

      Overview Locating an application that is using a TCP Socket is vital to troubleshooting a conflict. NETSTAT is a built in Windows tool. Requirements Local Administrator Rights Experience with Command Prompt Using NETSTAT Open an elevated Command ...