TMAegis
More rules for sharepoint

TMA-SHAREPOINT-2.5

Ensure the SharePoint farm service account (database access account) is configured with the minimum privileges on the SQL server.

HighLevel 1Manual reviewsharepoint

Description

The SharePoint farm service account (database access account) must be configured with the minimum privileges on the SQL server Manual review.

How it is checked

Audit method: Manual review

This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.

In SQL Server Management Studio on the farm's SQL instance open Security > Logins > <farm service account> > Server Roles. Verify only dbcreator and securityadmin are checked (plus public). Get-SPFarm | Select DefaultServiceAccount shows the account.

How it is fixed

Fix method: Guidance or infrastructure patch

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

Properties

Operating systems
Any
Tags
sharepointservice-accountssql
Reference
CIS Microsoft SharePoint 2019 Benchmark v1.0.0 - 2.5 Ensure the SharePoint farm service account (database access account) is configured with the minimum privileges on the SQL server.