Solid Edge Solid Edge Standard Parts Microsoft SQL Server installation - which ports to exclude from the Firewall?

On a Solid Edge Standard Parts server you need to exclude TCP/IP ports from the Windows Firewall.
How to find out the correct ports to be excluded.

Solution

To find out which ports to exclude you can use the command 'netstat'.

In order to determine which ports are used by the services 'SQL server' (* and 'SQL browser') open a command prompt and execute 'netstat -a -b >netstatResult.txt'.
 
Open the resulting text file netstatResult.txt using, for example Notepad++ and search for 'sql'.
You should find several entries for 'sqlservr.exe' (* and 'sqlbrowser.exe').


In the above example, all 'sqlservr.exe' are using ports 1433 and 1434, hence these ports are to be excluded from the Windows Firewall to allow SQL connection from a client to this server.

Notes and References

As far as is known the service 'SQL browser' is not started by default and is only needed when using a named instance and not the default instance 'SQLEXPRESS'.  In a basic server installation as described in the StandardPartsInstallationGuide you do not need the service 'SQL Browser'.

Note: If the contents of the file is 'The requested operation requires elevation.' then you do not have the required rights to run netstat.

Hardware/Software Configuration

Platform: INTL64
OS: windows
OS Version: 1064
Product: SOLID_EDGE
Application: APPLICATION
Version: V220.0
Function: STANDARD_PARTS

Ref: 002-8016875