Changing TDS port from 1433 - wiltondb/wiltondb GitHub Wiki
On this page:
- Prerequisites
- Default port taken by MSSQL
- Changing the port using Configuration tool
- Connecting to custom port from SSMS
Prerequisites
Default port taken by MSSQL
When WiltonDB installation is completed and the Windows service is started, it tries to bind to port 1433 to listen to TDS connections. If MSSQL is running on the same machine:
then port 1433 may be alredy taken by it, you can check this in SQL Server Configuration Manager:
In this case WiltonDB service will start successfully, but will only listen on PostgreSQL 5432 port.
Changing the port using Configuration tool
Run the WiltonDB Configuration tool using <install_dir>/bin/wdb_config.exe path:
Enter the password and press "Load Settings" button:
In the left top drop-down menu instead of "All Settings" select "Networking Only":
Double-click the babelfishpg_tds.port setting, change the value from 1433 to some other port number (for example: 7433) and press "Apply change" button:
When the change is applied, note the "DB restart required: YES" message:
Restart WiltonDB service using Windows Service Control Manager:
Press "Reload settings" button to check the the setting value has actually changed:
Connecting to custom port from SSMS
To connect to custom TDS port from SSMS use hostname,port syntax, note that the comma ',' is used as a delimiter instead of a colon ':':