"Sorry, something went wrong" error after enabling RBS (Remote Blob Storage)

May 3, 2014 · by dave.webb · in SharePoint 2013

I have just configured and enabled RBS for my SharePoint 2013 environment and now when I try to access the site I get the following error message:

Sorry, something went wrong

Cannot complete this action.
Please try again.

Yet another fine example of unhelpful error messages from Microsoft! Well, a quick check of the Event Log revealed nothing so I moved on to the ULS log. Just before the error was generated the following lines were recorded in the log:

System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘rbs_fn_get_blob_reference’, database ‘WEBBWORLD_Content_Portal’, schema ‘mssqlrbs’.

and

SQL error code from last error 229 – The EXECUTE permission was denied on the object ‘rbs_fn_get_blob_reference’, database ‘WEBBWORLD_Content_Portal’, schema ‘mssqlrbs’.

Clearly the problem was down to permissions. After a bit of trial and error I discovered that the fix was to grant the following permissions to the Application Pool account on the content database: