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.


1 Answer 1


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, 2015 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, 2015 at 15:26
  • Yes, network service also has dbcreator role.I am performing the restore via central admin.
    – Perplexed
    May 8, 2015 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, 2015 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, 2015 at 15:44

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.