I have an instance of MS SQL Server 2014 (call it
MSSQL) on a Windows 10 machine (call it
Running SSMS on
WINTEN, I can connect to both the local SQL Server and also to SQL Server instances on other machines on the private network.
However, I cannot make connections from SSMS on any other machine to the SQL Server instance
WINTEN\MSSQL unless I completely turn off Windows Defender Firewall.
Following all instructions I could find I added two Inbound Rules to the Windows Firewall on
WINTENas shown here:
However, even with those rules in place, as soon as I enable the Windows Defender Firewall all SSMS connections to
WINTEN\MSSQL fail with the following message:
What is the correct way to configure Windows Defender Firewall to allow other private network machines to connect to MS SQL Server?
Update per first suggestion: I already had TCP Port 1433 Enabled for the SQL Server as shown here: