1

Closed

"SQL Remote Blob Store Sample Code" instructions and scripts have problems

description

First the Instructions say to:
" 1. At a command prompt, use the change directory (CD) command to change the current folder of the command prompt window to the RBS sample directory. At the command prompt, run the following command:
  notepad Binaries\InstallProvider.cmd
  1. You can then edit the parameters in the command script for your setup. Each parameter should be documented in the command script. Once your custom configuration is complete, at the command prompt run the following command:
    Binaries\InstallProvider.cmd
    "
    You cannot run the InstallProvider.cmd file from the RBS directory as the InstallProvider.exe expects the contents of the Binaries directory to be in the current directory (for the -configurationfile and -registrationfile parameters)
     
    Second, the InstallProvider.cmd will not complete when using all the default settings, and fails with the error:
    "-------------------------------------
    Registering File Store Provider
    SQL Server Instance: (local)
    Database: RemoteBlobStorage
    File Store Library Binary Location: C:\Program Files\Microsoft SQL Server\100\Samples\Engine\RBS\Binaries\
    ProviderName: FileStoreProvider_1
    Data Location: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\RBSFileStoreData\
     
    SQL Remote Blob Storage Provider Installation Utility
     
    Blob store and/or provider library installation failed. See the documentation for further support.
    Parsing Error:
     
    Too many arguments specified for the switch <SUBSTITUTION>."
     
    To fix this I put quotes around %FileStoreProviderLocation% on the InstallProvider.exe line of the InstallProvider.cmd script and moved that substitution to the end of the command line.
     
    After I made these changes and ran the InstallProvider.cmd script from the Binaries directory, I was able to install the FileStoreProvider:

C:\Program Files\Microsoft SQL Server\100\Samples\Engine\RBS>Binaries\InstallProvider.cmd

Registering File Store Provider
SQL Server Instance: (local)
Database: RemoteBlobStorage
File Store Library Binary Location: C:\Program Files\Microsoft SQL Server\100\Samples\Engine\RBS\Binaries\
ProviderName: FileStoreProvider_1
Data Location: C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\RBSFileStoreData\
 
SQL Remote Blob Storage Provider Installation Utility
 
Checking connection to database and installation state of RBS.
Current RBS State: 2
Checks to see if the blob store name <FileStoreProvider_1> is currently installed.
Registering the provider configuration into the .NET machine.config file.
Add blob store with information:
RegistrationFile RegisterFileBlobStore.sql, BlobStoreName FileStoreProvider_1, Location c:\rbs_test_data.
Setting the default blob store to <FileStoreProvider_1>.

comments

mikew wrote Jul 24, 2008 at 11:58 PM

Thanks for reporting this John. These issues should be fixed with the latest release of the InstallProvider.cmd script.

wrote Jul 24, 2008 at 11:59 PM

wrote Jul 25, 2008 at 12:00 AM

wrote Feb 14, 2013 at 6:49 PM

wrote May 16, 2013 at 8:44 AM