To make the ports static:
This article explains how to configure a static TCP port (1433) for a SQL Server named instance hosting a PDM database. By default, SQL Server uses dynamic ports, which can cause connectivity issues. Follow the steps below to assign a fixed port and restart the SQL Server service.
SQL Server must have a Static IP- Consult your IT department, as this is not managed 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
-
- Verify that the TCP Port field under IP4, IP6, and IPAll is blank (indicating dynamic ports are currently in use).
- Clear the TCP Dynamic Ports field in each IP section (IP1, IP2, IP4, IP6, and IPAll). This disables dynamic port assignment.
- 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
Last reviewed: May 2022. Please verify these steps against your current SQL Server version, as the interface may have changed.