To make the ports static:
- SQL Server must have a Static IP
- Consult with your IT department, this is not Administered by the PDM Administration Tool.
Steps:
- Open SQL Server Configuration Manager from your Windows Start menu
- Under SQL Server Network Configuration
- Select "Protocols for <Named Instance>" (As highlighted below), this will be the SQL Instance hosting your PDM Database.
- Open TCP / IP
- Navigate to the IP Addresses tab
-
- TCP Port (Inside IP4 / IP6 / IPAll is blank)
- Remove the "TCP Dynamic Ports" value from the relevant section. This disables the Dynamic port usage.
- Set the relavent TCP port to 1433 as a static value (as per screenshot below)
Note:
The port 1433 can possibly already be in use - confirm with your IT department if you are unsure.
Once the port has been set to the static value. You will be required to restart the SQL Server Service. To do this from the SQL Server Configuration Manager follow the steps below:
- Navigate to SQL Server Services
- Right click on the relevant service i.e. SQL Server (SQLPDM)
- Restart
Date: 13/05/2022