I have a SQL server 2014 instance running on Windows 2012 R2. If I turn off the Windows FW for domain, I'm able to connect to the SQL instance remotely using SSMS. If I turn it on, I cannot connect. I get an error stating the connection timeout has expired. I have added SQL rules for 1433 and 1434 on the FW to no avail. I have even gone as far as to add any/any rules inbound and outbound on the server FW, also to no avail. It seems as though regardless of the FW settings, if it's on, I can't connect to SQL remotely. Any help would be greatly appreciated!
The principal steps to allow access are:
Configure the Database Engine to use a specific
TCP/IPport. The default instance of the Database Engine uses port 1433, but that can be changed. The port used by the Database Engine is listed in the
SQL Servererror log. Instances of
SQL Server Express,
SQL Server Compact, and named instances of the Database Engine use dynamic ports. To configure these instances to use a specific port, see Configure a Server to Listen on a Specific
TCP Port(SQL Server Configuration Manager).
Configure the firewall to allow access to that port for authorized users or computers.