Network Management

Using Orion with an MS SQL server listening on a custom port

A customer can configure Microsoft SQL to listen on a custom port.

First published date

11/15/2018 3:44 PM

Last published date

2/18/2022 10:16 AM

Overview

You can configure Microsoft SQL to listen on a custom port. Refer to this article.

This article reviews the special considerations that must be taken into account in this scenario.

Product section

Orion Platform

Resolution

Note: This is not required if for a named instance. The custom port must allow bidirectional TCP communication if there is any firewall between the Orion server and the SQL server.

By default, Orion speaks to the MS SQL server over port 1433 TCP and 1434 UDP. However, when a custom port is used, you may need to alter the connection string to utilize that port. The example below can be used when specifying what SQL server Orion will use during the Configuration Wizard.

Server(comma)portnumber

Example:  DatabaseServer,17723

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.