Windows 10: Windows Firewall - rules presedence - problems connecting to SQL server on local network

Discus and support Windows Firewall - rules presedence - problems connecting to SQL server on local network in Windows 10 Gaming to solve the problem; I was trying to allow SQL server traffic through the firewall of a Windows 10 computer. I ran the following in PS:New-NetFirewallRule -DisplayName... Discussion in 'Windows 10 Gaming' started by myalo, Jul 18, 2023.

  1. MYALO
    myalo Win User

    Windows Firewall - rules presedence - problems connecting to SQL server on local network


    I was trying to allow SQL server traffic through the firewall of a Windows 10 computer. I ran the following in PS:New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action AllowThe results showed in the detailed list of rules in the Firewall app.The settings of the Firewall for the "public" local network wereFirewall state: On inbound connections: Block outbound connections: Allow default. My understanding is that specific rules take precedence over the general rules.With these settings, I could not connect to the SQL serve

    :)
     
    myalo, Jul 18, 2023
    #1
  2. FEETWET
    feetwet Win User

    Unblocking Windows 10 Defender Firewall for MS SQL Server 2014

    I have an instance of MS SQL Server 2014 (call it MSSQL) on a Windows 10 machine (call it WINTEN).

    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:


    Windows Firewall - rules presedence - problems connecting to SQL server on local network Rdffw.png


    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:


    Windows Firewall - rules presedence - problems connecting to SQL server on local network dtwnW.png


    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:


    Windows Firewall - rules presedence - problems connecting to SQL server on local network Q0ONY.png
     
    feetwet, Jul 18, 2023
    #2
  3. D7577423-33C7-4F00-A334-CAB1E4B2AD70
    d7577423-33c7-4f00-a334-cab1e4b2ad70 Win User
    SQL Server remote connection fails

    I'm trying to install SharePoint 2019 and the remote connection to my SQL Server is failing. I've set up the firewall rules on SQL Server, allowed TCP and UDP ports 1433 and 1434 and have allowed the sqlservr.exe program in the inbound rules.

    The user that's being used in the SP install wizard is an active AD domain user. I can ping the server by IP address and by name but it seems that SQL Server never receives the connection attempt.

    As a test I set up a .udl file on the SharePoint host and tried to connect to the SQL Server and the connection still failed. It's not just the SP installer but something is preventing connections to SQL. I've searched the web and tried every tutorial and
    suggestion but it's still failing.

    Is there anything else I can check? This should not be as difficult as it has been and I'm wondering if something else is preventing the connection.

    I appreciate any help.
     
    d7577423-33c7-4f00-a334-cab1e4b2ad70, Jul 18, 2023
    #3
  4. ALPHAGHOST.141
    AlphaGhost.141 Win User

    Windows Firewall - rules presedence - problems connecting to SQL server on local network

    DPM 2016 Installation With Remote SQL Server

    Hi Guys

    I'm trying to install DPM 2016 with a SQL 2014 Running on different Machine. I've created Firewall rules for necessary ports and Executables. But I'm stuck with one rule. Can someone help me how to Check the following rule? Thanks in advance

    Set up firewall rules so that the DPM server can communicate with the SQL Server computer:

    • Make sure TCP/IP is enabled with default failure audit and enable password policy checking.
     
    AlphaGhost.141, Jul 18, 2023
    #4
Thema:

Windows Firewall - rules presedence - problems connecting to SQL server on local network

Loading...

  1. Windows Firewall - rules presedence - problems connecting to SQL server on local network - Similar Threads - Firewall rules presedence

  2. Disable network multiplexor or add local firewall rules

    in Windows 10 Gaming
    Disable network multiplexor or add local firewall rules: I inherited a remote machine at work. It is a Windows server 2016It has the Windows Network Multiplexor Adapter applied and utilizes two network portsHow can I disable or modify it so that I can add local firewall rulesI have tried adding firewall rules but whatever rules I...

  3. Disable network multiplexor or add local firewall rules

    in Windows 10 Software and Apps
    Disable network multiplexor or add local firewall rules: I inherited a remote machine at work. It is a Windows server 2016It has the Windows Network Multiplexor Adapter applied and utilizes two network portsHow can I disable or modify it so that I can add local firewall rulesI have tried adding firewall rules but whatever rules I...

  4. Windows Firewall - rules presedence - problems connecting to SQL server on local network

    in Windows 10 Software and Apps
    Windows Firewall - rules presedence - problems connecting to SQL server on local network: I was trying to allow SQL server traffic through the firewall of a Windows 10 computer. I ran the following in PS:New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action AllowThe results showed in the detailed...

  5. Apply local firewall rules

    in Windows 10 Gaming
    Apply local firewall rules: Hi We have a group policy and what it does is it allows local firewall rules for public and private profile.How do I do this via Intune?I attached an image.RegardsShaun...

  6. Apply local firewall rules

    in Windows 10 Software and Apps
    Apply local firewall rules: Hi We have a group policy and what it does is it allows local firewall rules for public and private profile.How do I do this via Intune?I attached an image.RegardsShaun...

  7. Apply local firewall rules

    in Windows 10 Network and Sharing
    Apply local firewall rules: Hi We have a group policy and what it does is it allows local firewall rules for public and private profile.How do I do this via Intune?I attached an image.RegardsShaun...

  8. Firewall rules

    in Windows 10 Network and Sharing
    Firewall rules: [ATTACH] Does this symbol mean I have blocked outbound traffic for an application? If so why did the app just check for an update and confirm its current version? https://answers.microsoft.com/en-us/windows/forum/all/firewall-rules/870791a0-328a-4d5c-ad0a-be99f93dfdb0

  9. Firewall Rules

    in Windows 10 Network and Sharing
    Firewall Rules: Can you setup exceptions for firewall rules? For example, if I have a port blocked inbound for ALL via GPO, can I create an exception to that rule to allow just certain IP addresses to get through the port being blocked? Win 10 ENT in a domain environment....

  10. Firewall rules

    in AntiVirus, Firewalls and System Security
    Firewall rules: I accidentally deleted outbound windows firewall rules. Will these reappear? Can this be dangerous? Please help. Thanks https://answers.microsoft.com/en-us/windows/forum/windows_10-security/firewall-rules/1f7cbdda-d9e2-435a-96cb-6caef7699b88"