How to add an IP table rule to use SQL Server port 1433

Only the default SQL Server port 1433 can be used for the Airflow metadata SQL server database AutomationSuite_ProcessMining_Metadata. If your organization policies or firewall rules do not allow using port 1433, you can redirect incoming traffic directed at port 1433 of the SQL Server IP address to a new SQL Server IP and port.

Use the following Linux command to add a nat rule in the IP tables PREROUTING chain:

iptables -t nat -A PREROUTING -d <sql server IP> -dport 1433 -j DNAT --to-destination <sql server ip>:<sql server port>

Replace <sql server IP> and <sql server port> with your respective SQL Server IP address and port number.

Note:

This command should be run as a root user or a sudo user.