Skip to content
Docs

Configure MSSQL TCP Port for Secure Connections

SQL Server Express does not enable TCP/IP by default. Mideye Server requires a TCP connection to the database, so you must enable it manually.

Steps

Section titled “Steps”
  1. Open SQL Server Configuration Manager.
  2. Expand SQL Server Network Configuration.
  3. Right-click TCP/IP and select Enable.
  4. Open Properties for TCP/IP.
  5. Select the IP Addresses tab.
  6. Scroll to IPAll at the bottom.
  7. Set TCP Port to 1433.
  8. Click OK and restart the SQL Server service.

Verify connectivity

Section titled “Verify connectivity”

From the Mideye Server, test the connection:

Terminal window
telnet <sql-server-ip> 1433

A successful connection shows Connected to <sql-server-ip>.

Section titled “Related links”