Check SQL port for a named instance

When creating a name instance (beside the default one), the sql port is dynamically configured.
You need to change this dynamic port to a fixed one.

• Go to: start menu – Microsoft SQL 2008 r2 – configuration tools – SQL server configuration manager.

• On the left pane: go to SQL server network configuration – protocols for “your named instance”.
• On the right pane: TCP/IP properties, then IP addresses tap.
• You will find the dynamic port in the end at the IPALL section.

• Change it to the desired port (in all IP sections), then restart the SQL service from the same window (sql server services).
• If the firewall is on, you need to open the port for this instance: netsh firewall set portopening TCP xxx "SQLServer"