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

Information

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

Rationale:

Having the SharePoint setup account be configured with the minimum necessary privileges
on the SQL server would help reduce the risks related to account misuse. When excessive
roles are given to any SQL server accounts, the potential impact of actions performed
through the account increases. Malicious action performed by compromised accounts in
the control of an attacker, or even honest mistakes and gaffes performed by valid users can
have vast devastating consequences, depending on the roles and privileges given.

Solution

1. Launch SQL Server Management Console and navigate to Security > Logins.
2. Select the SharePoint Setup User account.
3. Click on Server Roles and check only dbcreator and securityadmin.

See Also

https://workbench.cisecurity.org/files/2395