I am attempting to restore a farm backup to a new SharePoint install.

The OSW timer service is running under farm account. farm account has db_accessadmin, db_datawriter and db_securityadmin membership on the 'Master' database, yet I keep getting these errors.

What else am i missing - any help appreciated.



Farm admin account should need these two permission in order to create a database on sql.

  • DB_Creator
  • SecurityAdmin

Also make sure farm admin is part of local admin on the SharePoint server.

  • Yes, at the instance level, farmadmin does have those permissions. – Perplexed May 8 '15 at 15:24
  • how you performing the restore? can you share more details about the error....one more thing to check if NETWORK SERVIE account have dbcreator role on sql. – Waqas Sarwar MVP May 8 '15 at 15:26
  • Yes, network service also has dbcreator role.I am performing the restore via central admin. – Perplexed May 8 '15 at 15:28
  • underwhich account Central admin app pool is running? also give farm admin full control on SQL server, i.e Sysadmin....after that logout from server and relogin thent ry again. – Waqas Sarwar MVP May 8 '15 at 15:35
  • appPool runs under farmadmin account also - not ideal i know but i am trying to best replicate the current production server set up – Perplexed May 8 '15 at 15:44

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.