3

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?

Improve this question

2 Answers 2

Reset to default
1

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

For more details, see this article.

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

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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