Configure Microsoft SQL Server to use a static custom port to secure database communications for ePO - On-prem.
Open SQL Server Configuration Manager.
Expand SQL Server Network Configuration, then select Protocols for [Instance Name].
Important
Select the specific database instance used by your ePO - On-prem server.
Right-click TCP/IP, then select Properties.
Select the IP Addresses tab, locate your target IP configuration section, and configure the port settings based on your active Listen All status:
Listen All Setting
Required Actions
If set to Yes
Navigate to the IPAll section.
Delete any existing value in the TCP Dynamic Ports field (ensure it is not left at 0).
Enter your target port number in the TCP Port field.
If set to No
Navigate to your specific IP section (such as IP1 or IP2).
Set Enabled to Yes.
Enter the correct IP address for your environment.
Delete any existing value in the TCP Dynamic Ports field (ensure it is not left at 0).
Enter your target port number in the TCP Port field.
Click OK, then restart the SQL Server service to apply the configuration changes.