Installing on SQL Non Standard Ports

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.