This section helps troubleshoot the issues related to enabling and configuring TCP/IP networking for SQL Server on Windows, especially when integrating with Atatus database monitoring.

​
Prerequisites

  • Administrator access to the SQL Server host
  • SQL Server installed (version 2016 or later recommended)
  • SQL Server Configuration Manager available

​
Step 1: Open SQL Server Configuration Manager

Press Windows + R, type the relevant version command and press Enter:
  • For SQL Server 2019: SQLServerManager15.msc
  • For SQL Server 2017: SQLServerManager14.msc
  • For SQL Server 2016: SQLServerManager13.msc

​
Step 2: Enable TCP/IP Protocol

  • In the Configuration Manager, navigate to:
    • SQL Server Network Configuration → Protocols for <YourInstanceName>
  • Right-click on TCP/IP and select Enable.

​
Step 3: Restart SQL Server Service

Restart the SQL Server service to apply network settings:

​
Step 4: Verify TCP Port 1433 is Listening

Run the following in Command Prompt to confirm that SQL Server is listening on port 1433:
A successful configuration will show LISTENING on 0.0.0.0:1433 or the relevant IP.

​
Step 5: Test SQL Connectivity

Use sqlcmd CLI to confirm database connectivity over TCP port 1433: