Configure SQL Express/Server Host – Enable TCP/IP & Firewall Settings

SQL Server and/or Express need to be permitted to use the TCP/IP protocol, then you’ll need to create local firewall rules on the HOST PC to permit TCP/IP via port 1433, and UPD via port 1434.

Enable TCP/IP via SQL Server Configuration Manager

SQL Server Configuration Manager is part of the SQL Server Management Studio (SSMS) suite of tools.

The following is an excerpt from http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote-tcp-ip-connections-on-port-1433.aspx, copied here for convenience and posterity.

1) Click Start, Programs, Microsoft SQL Server 20xx and select SQL Server Configuration Manager. (Older version screen shots shown)

2) Select SQL Server Network Configuration

3) Double click on Protocols for SQLEXPRESS.

4) If not enabled already, right click TCP/IP and choose “Enable”(screen shot below shows it’s already enabled)

5) Click OK

6) Make sure that port: 1433 is enable on your firewall.

7) Mixed mode authentication must also be enabled for remote connections.

8) Make sure that the SQL Browser service is enabled and running.

Configure Host PC Firewall Rules

The SQL HOST PC must permit TCP/IP via port 1433, and UPD via port 1434.  Here is a link to Microsoft’s related KB article.


« Back to the Knowledgebase
Posted in .