Excel Web Access Web Parts & Remote Blob Storage – "We don't know what happened, but something went wrong."

We have seen several cases where customers can view an Excel Workbook in the browser, but not in the Excel Web Access Web Part.  They are seeing the below error in the Excel Web Access Web Part:

“Excel Services


We don’t know what happened, but

something went wrong. 


Could you please try that again?”


When reviewing the ULS logs, we are seeing:

11/24/2014 11:37:37.26 w3wp.exe (0x2864) 0x0BBC SharePoint Foundation Database d0d6 High System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'rbs_fn_get_blob_reference', database 'SharePoint_Content_80', schema 'mssqlrbs'.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)     at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)     at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)     at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)     at System.Data.SqlClient.SqlDataReader.Read()     at Microsoft.SharePoint.SPSqlClient.ExecuteQueryInternal(Boolean retryfordeadlock)     at Microsoft.SharePoint.SPSqlClient.ExecuteQuery(Boolean retryfordeadlock)  ClientConnectionId:932b5260-fed3-44df-9e6a-72292182dfd9 c057cf9c-9345-605f-7c08-0f50fcd1dfd4


This has to do with permissions and to resolve this, grant the following permissions to the Application Pool account on the content database:












Comments (0)

Skip to main content