Ensure 'SQL Server Browser Service' is configured correctly

NiskaNivo 1Ručni pregledmssql

Opis

No recommendation is being given on disabling the SQL Server Browser service. In the case of a default instance installation, the SQL Server Browser service is disabled by default. Unless there is a named instance on the same server, there is typically no reason for the SQL Server Browser service to be running. In this case it is strongly suggested that the SQL Server Browser service remain disabled. When it comes to named instances, given that a security scan can fingerprint a SQL Server listening on any port, it's therefore of limited benefit to disable the SQL Server Browser service. However, if all connections against the named instance are via applications and are not visible to end users, then configuring the named instance to listening on a static port, disabling the SQL Server Browser service, and configuring the apps to connect to the specified port should be the direction ta...

Kako se proverava

Metod provere: Ručni pregled

Ova preporuka se ne može proveriti automatski. Skeniranje je navodi sa ovim uputstvima kada prosledite --include-manual.

Check the SQL Browser service's status via services.msc or similar methods.

Kako se ispravlja

Metod ispravke: Smernica ili zakrpa infrastrukture

Enable or disable the service as needed for your environment.

Svojstva

Operativni sistemi: Bilo koji
Oznake: mssqlsqlserver-2022
Referenca: CIS Microsoft SQL Server 2022 Benchmark v1.3.0 - 8.1 Ensure 'SQL Server Browser Service' is configured correctly