Configure Notification Server to communicate with a SQL Server using a non-standard port
Last Updated March 13, 2008
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.
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.
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:
Click Start > Run and type cliconfg in the run box and click OK.
Click the Alias tab on the SQL Server Client Network Utility screen.
Click the Add button.
In the Server Alias screen enter the name you wish to use to reference your SQL Server.
Click the TCP/IP radio button under Network Libraries.
Enter the SQL Server Name\Instance in the Server Name box.
To specify the specific port, uncheck the Dynamically Determine Port box and input the correct port.
Click the OK button.
On the main SQL Server Client Network Utility Screen click the OK button.
On the SQL Server configuration screen of the Notification Server setup enter the alias name.
Imported Document ID: HOWTO8632
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe