Firewall Port 1433 not opening

1. Probably port 1433 is disabled, so enable it using MS WIndows firewall.

or just use

netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT

2. Probably MS SQL Server Browser Service is not running. So go to Services and start it.

or just execute under Run menu

%windir%\system32\services.msc

3. Probably TCP/IP channel is disabled under SQL Server 2008/2014 Configuration Manager. SO go there and enable all TCP/IP options.

4. Just in case at the same place (SQL Server 2008/2014 Configuration Manager) make sure you have 1433 port.

5. Make sure that SQL server is configured to allow remote connections. Use MS SQL Management Studio and right click on the top node which server itself.

In the SQL Server Configuration Manager->SQL Server Network Configuration->Protocols, check that named pipes and tcp/ip are enabled.

If that doesn't work then it may be your firewall blocking it, try this link: http://msdn.microsoft.com/en-us/library/cc646023.aspx

This may be useful too: http://support.microsoft.com/kb/287932

If named pipes and TCP/IP access are already enabled in SQL Server Configuration Manager, then you need to either add a rule for UDP port 1434, or a rule for sqlbrowser.exe so that the SSMS client can talk to the SQL Server Browser service.

I actually see people having this problem surprisingly often so I wrote up an explanation here: http://blog.dereenigne.com/microsoft-sql-server-dynamic-ports-windows-firewall-and-you/