Error when creating Search Service Application - User does not have permission to perform this action

I was contacted by a SharePoint Administrator with an issue relating to SharePoint Search. The user encountered the following error when provisioning a Search Service Application.

The resolution is simple;

Ensure that SharePoint Farm Service Account has the following roles in SQL;

1. DB creator
2. Security Admin

The latter was found to be missing in this case.

Hope this helps.