How Can I Change The Port To Monitor SQL Server?

The default TCP/IP port for SQL Server is 1433.

When a different TCP/IP port is used, a SQL Server client needs be defined.

This configuration is done outside of any ODBC program.

Nothing needs to be changed in the Argent product.

Do the following the Argent Guardian Monitoring Engine server.

  1. Start Client Network Utility.

    Click For Full Size

  2. At General tab, ensure TCP/IP is a supported network protocol.

    Click For Full Size

  3. On the Alias tab, add the SQL Server machine name or its IP address.
  4. Select the TCP/IP network library, uncheck the option Dynamically determine port and specify the port number.

    Click For Full Size

  5. Save the changes.

    Click For Full Size

  6. Verify the settings using SQL Server Enterprise Manager or by testing the SQL-specific Relator in the Argent Guardian.See Also: What TCP Ports Does Argent Use?