SQL alwaysOn for sharepoint 2013 not able to open central admin

Question

In our SharePoint 2013 environment we are performing SQL AlwaysOn activity. We have followed some MSDN blogs:

https://blogs.msdn.microsoft.com/sambetts/2015/04/24/setting-up-sharepoint-disaster-recovery-sites-with-sql-alwayson/

like this. And successfully failover our current database to DR site database. So now the application is in our current site and databases are moved to DR site. We checked our portal is up and working. But when we try to open Central Admin we get this error:

From the error it seems like it is the permission issue on the DR site database. But we checked the user permissions, the permissions are also the same as our current site database. We are using farm account which has Sysadmin permission on the database.

Can someone suggest something for this?

Answer 1

You must manually add your SharePoint service accounts to the SQL Server Logins along with the appropriate fixed role, if any (e.g. the Farm Admin service account needs securityadmin and dbcreator).