1

I am trying to enable RBS on different content database but first the RBS that I installed was installed by wizards, not using cmd as mentioned in the msdn article about installing and configuring RBS.

When I ran it from the cmd the log file contain error about the master key

raiserror(N'Remote Blob Storage requires a master key to exist in this database. Please create a master key and retry the install.

So I thought it was a permission error for the user who ran the cmd and I added it to the DBOwner but the same problem appear.

The main issue is that I am not able to configure the RBS or enable it in other word for another content database.

2

RBS isn't configured correctly. You need to have master key in your SharePoint Content database. Use the following command to add it:

use [ContentDbName]
if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')
create master key encryption by password = N'Admin Key Password !2#4'

Source

  • thank you Jussi for your reply but i checked my content database for that by querying "select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##'" and there was a result – Kamaro Jan 7 '15 at 9:45
0

As I predict it was a permission issue.
The user who provision the BLOB store was not a member of the db_owner.
Thank you for help guys :)

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.