Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Orion Platform > Orion - Knowledgebase Articles > Using Orion with a MS SQL server listening on a custom port

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

Table of contents
Created by Michael Perez, last modified by Michael Perez on Feb 18, 2017

Views: 1,280 Votes: 4 Revisions: 8

Overview

It is possible for you to 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.  

Environment

All Orion products

Detail

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

 

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.  

 

 

Last modified

Tags

Classifications

Public