I'm in the middle of an upgrade from 2010 to 2013, and I'm running into an issue when attempting to upgrade one of my content databases using PowerShell. The content databases attached to my other web applications have mounted fine, but this particular one is presenting issues.

The error I'm receiving is as follows:

Mount-SPContentDatabase : The DELETE permission was denied on the object 'TVF_Features_PK', database 'MyContentDB', schema 'dbo'.

I've given the account that I'm using to execute to PS command db_owner permissions on the database, but that doesn't seem to be helping. Any thoughts?


Ensure that the account in question also has Securityadmin (& Dbcreator) fixed server roles on the SQL Server instance.

For more details, see this article.

  • Thanks for the suggestion. However those permissions were already applied. – Evan M. Mar 2 '14 at 16:36
  • Glad you figured it out, @EvanM. – Phil Greer Mar 2 '14 at 17:08

Managed to get this to go through by giving the account I was using to mount the database full sysadmin permissions on the database server.

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.