Every now and then when installing a new instance of SQL Server you may want to connect to it from other machines via Management Studio. Here are the instructions on how to do that.
To add a program exception to the firewall using the Windows Firewall item in Control Panel.
- On the Exceptions tab of the Windows Firewall item in Control Panel, click Add a program.
- Browse to the location of the instance of SQL Server that you want to allow through the firewall, for example C:\Program Files\Microsoft SQL Server\MSSQL11.
\MSSQL\Binn, select sqlservr.exe, and then click Open.
- Click OK.