Ensure the SharePoint setup account is configured with the minimum privileges on the SQL server.

ВисокаНиво 1Ручни прегледsharepoint

Опис

The SharePoint setup account must be configured with the minimum privileges on the SQL server. Manual review.

Како се проверава

Метод провере: Ручни преглед

Ова препорука се не може проверити аутоматски. Скенирање је наводи са овим упутствима када проследите --include-manual.

In SQL Server Management Studio on the farm's SQL instance open Security > Logins > <SharePoint setup account> > Server Roles. Verify only dbcreator and securityadmin are checked (plus public). sysadmin or other roles are non-compliant.

Како се исправља

Метод исправке: Смерница или закрпа инфраструктуре

In SSMS > Security > Logins > setup account > Server Roles, check only dbcreator and securityadmin (ALTER SERVER ROLE <role> DROP MEMBER [DOMAIN\setup] for others).

Својства

Оперативни системи: Било који
Ознаке: sharepointservice-accountssql
Референца: CIS Microsoft SharePoint 2019 Benchmark v1.0.0 - 2.4 Ensure the SharePoint setup account is configured with the minimum privileges on the SQL server.