Use a non-default port for SQL Server

The default port for SQL Server is 1433. If you want to use a different port number, use SQL Server Configuration Manager to set the port number.

If you are using the SQLData object to store and retrieve data, you will need to enter the non-default SQL Server port number as you enter other database connection information. See the SQLData Object help file, available through the System Platform IDE, for additional information.

To change to a non-default SQL Server port number

1. If you are upgrading from a prior version of System Platform, upgrade all nodes. See Basic upgrade sequence for more information. If this is a new installation, continue to step 2.

2. Launch SQL Server Configuration Manager.

3. Select SQL Server Network Configuration, then select Protocols for MSSQLSERVER.

4. In the list of protocol names to the right, select and open TCP/IP Properties.

   

5. In the TCP/IP Addresses tab, scroll down to IPAll.

   

6. Change the TCP Port number from 1433 to the desired number.

7. Click OK or Apply to commit the changes.

8. Reboot the GR node.