0

In sharepoint 2010 and sql server 2012 r2 which permissions need on sharepoint databases and sql server roles for below service accounts.

service accounts:

  • Spfarm account
  • spadmin account
  • search service application account
  • Web application Pool account
  • Service application pool account

Databases:

  • Configuration database
  • Search Service application databases
  • Content databases
  • Service applications database(managed metadata)

SQL Server Roles above service accounts:

  1. is Spfarm account should be db_owner for all above databases?
  2. Search service should be db_owner for all search databases?
  3. Search service and spfarm account need any permissions on master and tempdb also?
2

Spfarm account and spadmin account following accounts required the SecurityAdmin and DB_Creator on SQL Server.When you provision any service using the farm account then SharePoint will set the permission. All the required permissions, Role automatically fixed during the provisioning process. I never saw any issue to manually set the permission within farm.

I do see the issue when you have separate Services farm.

  1. is Spfarm account should be db_owner for all above databases? Yes
  2. Is Search service should be db_owner for all search databases? Yes
  3. Search service and spfarm account need any permissions on master and tempdb also? No
  • Hi for some reason some default permissions for sharepoint dbs including search and content dbs removed, and crawling was stuck in search content sources and spadmin user can not create any databases in this farm, really Search service and spfarm account not require any permissions on master and tempdbs?? – adilahmed May 18 '16 at 20:19
  • Nope they dont need any permission, rather you have to make sure that Farmadmin account has Dbcreator and Security admin rights on the SQL server – Waqas Sarwar MVP May 18 '16 at 20:20
  • Hi thanks, again is application pool account for web application needed db_owner database permissions in content database? – adilahmed May 22 '16 at 11:00
  • I know we have set app pool account as dbo on content db. I am not sure what is default value as no VM ready for me :). – Waqas Sarwar MVP May 22 '16 at 17:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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