2016-08-25 05:43 AM
We're working on SMSP implementation and currently have some issues.
One main error is being seen on application servers / frontend severs.
According the error, the Agent account doesn’t have db_owner permissions.
The thing is that the agent user is the farm admin, we checked on SQL MGMT Studio and it seems to have all the permissions (on user mapping, “dbo” appears on the reported database, and on the SharePoint databases).
Also, Farm is not being seen via the Backup tab. I guess it’s related to the errors described in Health Analyzer.
Will be happy if you suggest ways to troubleshoot this.
This is the error message (for both modules “Connector” and “Storage Manager”: