How to assign a TCP/IP Port Number to the SQL Server Database Engine in SQL Server 2012. How to open a SQL Server instance port using Windows Firewall. For more info, or a copy of any of the scripts used in any of my tutorials, please email me at [email protected]