SQL Server Port

Scenario 1:

SQL is not connecting via Management studio locally after a fresh Installation:

1. After a fresh Installation of SQL  and opening the port in the Firewall you may not be able to connect via SQL management studio.

Note: Installing SQL and opening the port in Firewall will not listen to the service/port. Its obvious that no service will listen even If the port is opened in the firewall. The application must listen to the service.

2. After Installing SQL, go to SQL Enterprise Manager in case of 2005, 2008, SQL server Network Utility If the version is 2000.

3. Go to TCP/IP, make sure the default localhost IP and the IP in which your server must listen to the SQL service should use the SQL port.  Restart the SQL services. Read more