db_owner on content databases farm account


  • We are running SharePoint 2013 enterprise and SQL 2012. I have noticed that the farm account doesn't have db_owner access on all of the content databases. After reading technet the farm account should have db_owner rights on all content databases correct? Just want to make sure since something is causing the farm account to loose db_owner permissions. Thanks, ozsp

    Thursday, March 16, 2017 4:30 PM

All replies

  • Hi ozsp,

    Members of the db_owner fixed database role can perform all configuration and maintenance activities for all databases in the server farm, and can also drop the database in SQL Server.

    If the farm account does have db_owner fixed database role, he cannot perform these options.

    Best regards,

    Linda Zhang

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    Saturday, March 18, 2017 7:41 AM