Is it required to add firewall Exception for LocalDB seperately

• IT researcher

  SSCertifiable

  Points: 7600

  More actions

  August 14, 2023 at 11:18 am

  #4260819

  I have set up the required firewall exception rules for SQL Server Express to function properly. Do I need to create separate firewall exceptions for the Local DB?

  Will the Local DB utilize the firewall exceptions that have already been defined for SQL Server, or does it require its own set of firewall rules?

  Is there a necessity to establish additional firewall exception rules to ensure the proper functioning of LocalDB?

   

  • This topic was modified 1 year, 3 months ago by   IT researcher.
  • This topic was modified 1 year, 3 months ago by   IT researcher.
  • This topic was modified 1 year, 3 months ago by   IT researcher.

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  August 14, 2023 at 12:57 pm

  #4260889

  The SQL Server service is what manages the databases, so yes, if that is appropriately in place, you should be able to connect to the database.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning