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:
- 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.
Thanks for your feedback. Let us know if you have additional comments below. (requires login)