This project has moved and is read-only. For the latest updates, please go here.

Farm account SP_Farm is not the db_owner of all the SharePoint tables. Is this correct?

Topics: General Questions, Support
Mar 5, 2015 at 4:27 PM
Edited Mar 5, 2015 at 7:18 PM
I am a newbee in SharePoint world... I used the AutoSPInstaller to setup a SharePoint on one single server with the database setup on the same server.

While checking the installation result, I noticed that the farm account (SP_Farm ) is not the db_owner of all the SharePoint databases. It is the owner for some, but not all.

But following Microsoft's document: (under 'SharePoint farm service account' section)
The farm account should be:
db_owner for all SharePoint databases

Will this current configuration cause any problem later? I shall leave this here or manually fix this?

SharePoint 2013 with SP1
SQL Server 2012 with SP1
Windows Server 2008 R2 with SP1