How to Setup Your SQL Port Settings

This article will discuss which SQL ports need to be open in order for our SOLIDWORKS products to talk to their defined database.

By default SQL communicates over ports 1433/1434.

There are several scenarios that can have an effect on the port traffic. We'll cover each one individually and how to set up the ports accordingly.

SOLIDWORKS database components are all installed in the same SQL instance.

Because the SQL instance is the same for all components the database can use the default TCP port 1433

SOLIDWORKS database components are installed on the same server but have a unique instance of SQL.

In this scenario 1 database can use the default ports but all could be manually configured to use a unique port.

To update a static port use the SQL Server Configuration Manager and set the port manually. Be sure the port is available before assigning it.

Step 1:

Open the SQL Server Configuration Manager.

Step 2:

Expand SQL Server Network Configuration.

Step 3:

Select the SQL server instance and right click the TCP/IP line from the Protocol Name column and select properties.

Step 4:

Select the IP Addresses tab.

Step 5:

If the port is set to dynamic we will see a 0 in the TCP dynamic ports. (if already blank skip to Step 6) Clear all TCP Dynamic Ports. Do this for each active IP.

Step 6:

Insert the new port number in the TCP Port field. Do this for each active IP.

SOLIDWORKS database components are installed to unique server.

Because the pointed server has a unique name the default ports can be left alone.

Configured SQL Ports

After configuring the ports for your SQL server it's always advisable to reboot the server and begin testing. If your testing shows positive results you and your team will be ready to take your SQL server live.

Thanks for checking out the Alignex blog! Make sure to subscribe down below to have more content like this delivered straight to your inbox!