Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL Express Named Instance - Firewall Issue

已答覆 SQL Express Named Instance - Firewall Issue

  • Monday, October 08, 2012 8:40 PM
     
     
    Sign In to Vote
    0

    I am running a named instance on SQL Server 2008 R2 Express and attempting to configure my Windows Firewall to be enabled on the server.

    When attempting to connect to the database through the application, if the firewall is disabled I am able to connect to the server, with the firewall is enabled I am unable to connect to the server, so it is narrowed down to a firewall issue.

    When the firewall is enabled, the firewall log shows that it is dropping connections to my workstation on ports in the high 50,000 to low 60,000 range. I understand this is due to the named instance being handed off to dynamic ports after establishing the connection on port 1433 and 1434, correct?

    To remedy this I have verified on my server that TCP port 1433 and UDP port 1434 are allowing inbound connections. I have also used the network configuration manager to change TCP/IP for the instance to a static port by removing the 0 from Dynamic and assigning a static port, I then add that static port to the firewall rule. The connections still drop.

    For testing purposes I created a firewall rule to allow all connections, specifying the source workstation IP. The connection succeeds, but that is not a solution as the workstations are numerous and are using dynamic IP configurations.

    I can't imagine that Microsoft would design SQL server to not allow you to have the firewall enabled while using a named instance, so what is the solution I am missing?

    Thanks.





    • Edited by bigdogchris Monday, October 08, 2012 8:40 PM
    • Edited by bigdogchris Monday, October 08, 2012 8:41 PM
    • Edited by bigdogchris Monday, October 08, 2012 8:41 PM
    • Edited by bigdogchris Monday, October 08, 2012 8:42 PM
    •  
     

All Replies

  • Monday, October 08, 2012 9:00 PM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    1

    Would you please check-out

    Steps to troubleshoot SQL connectivity issues

    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    • Proposed As Answer by retracement Tuesday, October 09, 2012 3:03 PM
    • Marked As Answer by Shulei ChenModerator Tuesday, October 16, 2012 1:59 AM
    • Unmarked As Answer by bigdogchris Wednesday, November 07, 2012 4:46 PM
    •  
     
  • Tuesday, October 09, 2012 10:38 AM
     
     Answered
    Sign In to Vote
    2

    Hi bigdogchris,

    Please try to open the setting of the Firewall, then add the SQLServr.exe( C:\Program Files\Microsoft SQL Server\MSSQL10.named instance\MSSQL\Binn\sqlservr.exe) to the allowed list.

    please try to refer to the information about how to configure the Firewall for SQL Server Access : http://technet.microsoft.com/en-us/library/ms175043(v=sql.100).aspx.

    Regards,

    Amy Peng

    Amy Peng

    TechNet Community Support

     
  • Wednesday, November 07, 2012 4:47 PM
     
     
    Sign In to Vote
    0

    Amy,

    I forgot to update this. You were right, thank you for the help!