Configure Notification Server to communicate with a SQL Server using a non-standard port

book

Article ID: 181533

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Problem
I am attempting to set up a Notification Server that communicates with my corporate SQL Server that uses a non-standard TCP/IP port for communication.

Environment

Notification Server 6.0.6074 SP3
Windows Server 2003 R2
Off box Microsoft SQL Server 2005 communicating on TCP/IP port 10001

Cause
Notification Server expects to communicate with the SQL Server using the default TCP/IP port of 1433.

Resolution

In order for the Notification Server to be able to communicate with a SQL Server using a non-standard port a SQL alias needs to be created. The alias will contain the necessary information about the SQL Server, including servername/instance and port number.

Perform the following steps on your SQL Server:
  1. Click Start > Run and type cliconfg in the run box and click OK.
  2. Click the Alias tab on the SQL Server Client Network Utility screen.
  3. Click the Add button.
  4. In the Server Alias screen enter the name you wish to use to reference your SQL Server.
  5. Click the TCP/IP radio button under Network Libraries.
  6. Enter the SQL Server Name\Instance in the Server Name box.
  7. To specify the specific port, uncheck the Dynamically Determine Port box and input the correct port.
  8. Click the OK button.
  9. On the main SQL Server Client Network Utility Screen click the OK button.
  10. On the SQL Server configuration screen of the Notification Server setup enter the alias name.