Skip to main content

Setting up Tenant Services on a Non-Standard Port

If you're not installing tenant services on the default port (a port other than 5432), there are some configuration steps you must complete.

If you are using the default port, you can skip this section.

If you have one instance in SQL, in the tenant service defaults.json file, remove instanceName from the modelServer section and add "port": <port number>.

If you have two or more instances in SQL, do not remove the instanceName field. Instead, add the SQL instance where the model is located.

If the port you are using is less than 1024, then you must run the project with admin privileges.

If port is not provided, the default behavior is "port": 1433.

  1. Run the SQL Server Configuration Manager.

  2. Select the SQL Server Network Configuration.

  3. From the list, select the instance that you want to configure to listen to a specific port.

  4. To change the port assignment, right-click the TCP/IP protocol and select Properties.

  5. Click the IP Addresses tab.

    Note

    Both IP5 and IP6 are disabled and the TCP Dynamic Ports setting is set to “0”, which means that the database engine is listening on dynamic ports.

  6. Type the port number you want to use instead of 1433.

  7. Turn off the dynamical port number setting by removing the “0” mark in the TCP Dynamic Ports field.

  8. To finish the adjustment, select SQL Server Services, click SQL Server and restart it.