Monday, September 22, 2014

SQL remote blob storage must be installed on each web front end server and on the content database before it may be used

 SQL remote blob storage must be installed on each web front end server and on the content database before it may be used.

Issue: unable to create content database to use RBS with FILE STREAM in SharePoint 2013


Solution: While enabling Remote Blob Storage on SharePoint servers, we need to run these Power Shell commands to enable RBS.

$cdb = Get-SPContentDatabase WSS_Content_2500  #Set you database name
$rbss = $cdb.RemoteBlobStorageSettings
$rbss.Installed()
$rbss.Enable()
$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])


When you run this line $rbss.Enable(), sometimes we get error and it says, “SQL remote blob storage must be installed on each web front end server and on the content database before it may be used.

To resolve this problem, we need to restart all servers in the Farm. After restarting, it will work like a charm.



I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

ShareThis

X