• Article

How To: Install (Remote BLOB Store)

This topic describes how to install the remote BLOB store feature pack on an instance of SQL Server.

To Install the remote BLOB store feature pack

  1. Run the RBS.msi installation wizard and follow the prompts. This wizard will install the SDK components and create a remote BLOB store database on the instance of SQL Server.

  2. In SQL Server Management Studio, connect to the instance of SQL Server that contains the remote BLOB store database.

  3. Open a Query Editor window and enter the following: EXEC mssqlrbs.rbs_sp_enable_rbs;

  4. Press F5 to run the stored procedure and enable remote BLOB store.

  5. You must also create a table for store of BLOB IDs. In the Query Editor window replace the stored procedure line with the following code:

    USE RemoteBlobStore
GO
CREATE TABLE BlobUserTable
(
    id uniqueidentifier default newid(),
    FileName varchar(max),
    BlobId varbinary(64)
)
GO

  6. Press F5 to create the table.

  7. Replace the script in the query editor window with the following:EXEC mssqlrbs.rbs_sp_register_column dbo, RBS_BLOB_STORE, BlobId

  8. Press F5 to run the procedure and register the column.