Microsoft Entra Domain Services | 5.8 Windows Firewall konfigurieren

Öffnen sie auf dem vm-sql-prod-001 die Windows Defender Firewall with Advanced Security >

Fenster "Windows Defender Firewall with Advanced Security"

Inbound Rule > (Rechte Maustaste)

New Rule… >

Fenster "New Inbound Rule Wizard - Rule Type"

Auswahl [x] Program

Next >

Fenster "New Inbound Rule Wizard - Program"

[x] This program path

Browse… > 

Fenster "Open"

Navigieren sie im Windows Explorer Fenster in den Pfad "C:\Program Files\Microsoft SQL Server\MSSQL15.TIMESAFE\MSSQL\Binn"

Wählen sie die sqlservr.exe aus >

Open >

Fenster "New Inbound Rule Wizard - Program"

[x] This program path

Next > 

Fenster "New Inbound Rule Wizard - Action"

[x] Allow the connection

Next >

Fenster "New Inbound Rule Wizard - Profile"

[x] Domain

[x] Private

[x] Public

Next >

Fenster "New Inbound Rule Wizard - Name"

Eingabe Name "TIMESAFE SQL Server"

Finish > 

SQL Browser Dienst zulassen

Fenster "Windows Defender Firewall with Advanced Security"

Inbound Rules > (Rechte Maustaste)

New Rule… >

Fenster "New Inbound Rule Wizard - Rule Type"

[x] Program

Next >

Fenster "New Inbound Rule Wizard - Program"

[x] This program path

Browse… >

Fenster "Open"

Navigieren sie in den Pfad "C:\Program Files (x86)\Microsoft SQL Server\90\Shared"

Auswahl sqlbrowser.exe >

Open >

Fenster "New Inbound Rule Wizard - Program"

Next >

Fenster "New Inbound Rule Wizard - Action"

[x] Allow the connection

Next >

Fenster "New Inbound Rule Wizard"

[x] Domain

[x] Private

[x] Public

Next >

Fenster "New Inbound Rule Wizard - Name"

Eingabe Name "TIMESAFE SQL Browser"

Finish >

Fenster "Windows Defender Firewall with Advanced Security"

Die beiden benötigten Firewall Regeln wurden somit erstellt.

Damit die Einstellungen und Firewallregeln wirklich ziehen empfiehlt es sich einen Neustart des Servers durchzuführen.

Neustart des Servers durchführen