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


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:

enter image description here

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?

1 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).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.