This article outlines the steps on how to switch a named instance of SQL Express from the default dynamic ports to static port 1433 as outlined in S-051981. When an SQL Express server communicates over a dynamic port, it is allocated a free port number by the operating system rather than communicating exclusively over a specified port, also known as a static port. As a result, even when the appropriate firewall exemptions as seen below have been made for port 1433, client machines are unable to communicate with the server as the server is trying to listen over a blocked port.
Generally, it’s best practice to make the following Inbound/Outbound rules in the firewall to ensure connectivity between SOLIDWORKS PDM server components and PDM client machines.
Example Instance Name: (STD_Express)
About Miguel de Villa
Miguel de Villa is a SOLIDWORKS Elite Applications Engineer with a B.S. in Mechanical Engineering from the University of California, San Diego. He’s been working at GoEngineer since 2017 helping customers with all their SOLIDWORKS, Simulation and PDM needs. In his free time he enjoys working with his 3D printer, playing video games and building model kits.
Get our wide array of technical resources delivered right to your inbox.
Unsubscribe at any time.