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;
- DB creator
- Security Admin
The latter was found to be missing in this case.
Hope this helps.