Installing RBS.msi

Aug 7, 2008 at 9:09 PM
I am installing the RBS, and I got the following message when I press "Test connection" button:

---------------------------
Connection successful
---------------------------
Remote Blob Storage requires a master key to exist in this database.
---------------------------
OK  
---------------------------

Any idea why? Should I create it or not?
Aug 7, 2008 at 9:12 PM
nvm, later it became pretty clear :)

"Please create master key and retry the install"
Jul 7, 2009 at 1:00 PM

for example - try something like

First create a new database on sql server called RemoteBlobStorage

then run a TSQL script

USE RemoteBlobStorage
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'JollyGoodMasterKeyPassword';
GO
then in the installation for RBS , in the installation screen called database connection
set server name = your machine name
set database name = RemoteDatabaseBlobStorage
Nov 3, 2010 at 6:46 PM
Edited Nov 3, 2010 at 6:47 PM

Hi,

I am trying to Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2010)

When I install and Configure for 1st Content Database, things are really fine. Whereas for 2nd time, It is failing; Failing in the sense, nothing happens when I execute below code, EXCEPT for GETTING ONE MSIEXEC WINDOW!!

Here is the 2nd Time one;

=================

 msiexec /qn /i RBS_X64.msi

REMOTEBLOBENABLE=1

FILESTREAMPROVIDERENABLE=1

DBNAME=”Content_Database_2”

DBINSTANCE=”LOCALHOST”

ADDLOCAL=EnableRBS,FilestreamRunScript

FILESTREAMSTORENAME=FilestreamProvider_2

 

Installing & Configuring for 1st Content Database

Installing & Configuring for 2nd Content Database

use [Content_Database_1]

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'

 

use[Content_Database_2]

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'

 

 

use[Content_Database_1]

if not exists (select groupname from sysfilegroups

where groupname=N'RBSFilestreamProvider1')

alter database [Content_Database_1]

add filegroup RBSFilestreamProvider1 contains filestream

use[Content_Database_2]

if not exists (select groupname from sysfilegroups

where groupname=N'RBSFilestreamProvider2')

alter database [Content_Database_2]

add filegroup RBSFilestreamProvider2 contains filestream

 

 

use [Content_Database_1]

alter database [Content_Database_1]

add file (name = RBSFilestreamFile1,

filename = 'C:\Content_Database_1_BLOB_Storage')

to filegroup RBSFilestreamProvider1

use [Content_Database_2]

alter database [Content_Database_2]

add file (name = RBSFilestreamFile2,

filename = 'C:\Content_Database_2_BLOB_Storage')

to filegroup RBSFilestreamProvider2

 

 

msiexec /qn /lvx*

rbs_install_log.txt /i   RBS_X64.msi

TRUSTSERVERCERTIFICATE=true

FILEGROUP=PRIMARY

DBNAME="Content_Database_1"

DBINSTANCE="LOCALHOST"

FILESTREAMFILEGROUP=RBSFilestreamProvider

FILESTREAMSTORENAME=FilestreamProvider_1

msiexec /qn

/i RBS_X64.msi

REMOTEBLOBENABLE=1

FILESTREAMPROVIDERENABLE=1

DBNAME=”Content_Database_2”

DBINSTANCE=”LOCALHOST”

ADDLOCAL=EnableRBS,FilestreamRunScript

FILESTREAMSTORENAME=FilestreamProvider_2

 

Thanks in Advance,

Regards,

Venkat.KL

Nov 3, 2010 at 10:42 PM
Edited Nov 3, 2010 at 10:42 PM

Hi Venkat,

I believe you are using the wrong command to enable RBS in the second content database.  It appears you are using a command that is designed to install the FILESTREAM provider on a second SharePoing WFE server.

I was able to successfully enable RBS using the FILESTREAM provider on a second content database by following this procedure:

1. I created a new content database (and site collection).  The new content database is named WSS_RBSDemo2_Content.

2. I executed this script in the context of the new database in SQL Management Studio (Note that I added a "2" to some of the values):

use WSS_RBSDemo2_Content
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'

if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider2')alter database WSS_RBSDemo2_Content
 add filegroup RBSFilestreamProvider2 contains filestream
 
alter database WSS_RBSDemo2_Content add file (name = RBSFilestreamFile2, filename = 'c:\Blobstore2') to filegroup RBSFilestreamProvider2

3. I executed this command in a command prompt with "Run as Administrator":

C:\Users\spadmin>msiexec /qn /lvx* c:\software\rbs_install_log2.txt /i c:\software\rbs_x64.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_RBSDemo2_Content" DBINSTANCE="SPX" FILESTREAMFILEGROUP=RBSFilestreamProvider2 FILESTREAMSTORENAME=FilestreamProvider_2

NOTE: In the command above my c:\software folder probably won't apply to your environment.  SPX is the name of my SQL Server and is used for DBINSTANCE.  Notice that the value of FILESTREAMFILEGROUP matches the name of the FILESTREAM type filegroup created in step 2 above.  The FILESTREAMSTORENAME is FilestreamProvider_2 and not FilestreamProvider_1 to differentiate it from the first FILESTREAMSTORENAME that I created in the first site collection.

I was able to upload a file to the new site collection.  The file was successfully streamed to the new BLOB store folder location (c:\Blobstore2).

Best Regards,

Russ