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:

copy
icon/buttons/copy 
net stop MSSQLSERVER
net start MSSQLSERVER

Step 4: Verify TCP Port 1433 is Listening

Run the following in Command Prompt to confirm that SQL Server is listening on port 1433:

copy
icon/buttons/copy 
netstat -ano | findstr 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:

copy
icon/buttons/copy 
sqlcmd -S <YourServerName>,1433 -U <YourUsername> -P <YourPassword>