locked
The EXECUTE permission was denied on the object 'rbs_fn_get_blob_reference' RRS feed

  • Question

  • Hello,

    I just set up RBS on SharePoint 2013 following this guide which seems that went wrong. Now, all my attachments on the farm are broken after running $rbs.Migrate() from this guide.

    This is what I see in the logs. I'm hoping that this is some sort of permission issue.

    	40458	04/06/2013 00:02:29.61   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Logging Correlation Data        xmnv  Medium    Name=Request (GET:https://portal.domain.local:443/sites/Business/Improve.aspx)  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40459	04/06/2013 00:02:29.61   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Authentication Authorization    agb9s  Medium    Non-OAuth request. IsAuthenticated=True, UserIdentityName=0#.w|domain\levente.rog, ClaimsCount=43  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40460	04/06/2013 00:02:29.79   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        ahjqp  High      [Forced due to logging gap, cached @ 04/06/2013 00:02:29.61, Original Level: Verbose] SQL connection time: 0.0611  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40461	04/06/2013 00:02:29.79   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        d0d6  High      System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'rbs_fn_get_blob_reference', database 'PortalContent', 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.TryReadIn...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40462	04/06/2013 00:02:29.79*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        d0d6  High      ...ternal(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:3f833647-0079-4b11-91a0-98439eb68f21  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40463	04/06/2013 00:02:29.79   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        ad194  High      ExecuteQuery failed with original error 0x80131904  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40464	04/06/2013 00:02:29.79   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        ajoin  High      SQL error code from last error 229 - The EXECUTE permission was denied on the object 'rbs_fn_get_blob_reference', database 'PortalContent', schema 'mssqlrbs'.  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40465	04/06/2013 00:02:29.79   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Files                           ajoim  Medium    Translated SQL error 229 to 0x80004005.  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40466	04/06/2013 00:02:29.79   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Files                           aise3  Medium    Failure when fetching document. 0x80004005  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40467	04/06/2013 00:02:29.79   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         8kh7  High      Cannot complete this action.  Please try again.  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40468	04/06/2013 00:02:29.81   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         aix9j  High      SPRequest.GetFileAndMetaInfo: UserPrincipalName=i:0).w|s-1-5-21-168301055-853898059-1568306086-6097, AppPrincipalName= ,bstrUrl=https://portal.domain.local:443/sites/Business/Improve.aspx ,bPageView=1 ,bPageMode=0 ,bGetBuildDependencySet=1 ,bstrCurrentFolderUrl= ,iRequestVersion=0 ,bMainFileRequest=1  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40469	04/06/2013 00:02:29.81   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ai1wu  Medium    System.Runtime.InteropServices.COMException: Cannot complete this action.  Please try again., StackTrace:    at Microsoft.SharePoint.SPWeb.GetWebPartPageContent(Uri pageUrl, Int32 pageVersion, PageView requestedView, HttpContext context, Boolean forRender, Boolean includeHidden, Boolean mainFileRequest, Boolean fetchDependencyInformation, Boolean& ghostedPage, String& siteRoot, Guid& siteId, Int64& bytes, Guid& docId, UInt32& docVersion, String& timeLastModified, Byte& level, Object& buildDependencySetData, UInt32& dependencyCount, Object& buildDependencies, SPWebPartCollectionInitialState& initialState, Object& oMultipleMeetingDoclibRootFolders, String& redirectUrl, Boolean& ObjectIsList, Guid& listId)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData.FetchWebPartPageInfo...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40470	04/06/2013 00:02:29.81*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ai1wu  Medium    ...rmationForInit(HttpContext context, SPWeb spweb, Boolean mainFileRequest, String path, Boolean impersonate, Boolean& isAppWeb, Boolean& fGhostedPage, Guid& docId, UInt32& docVersion, String& timeLastModified, SPFileLevel& spLevel, String& masterPageUrl, String& customMasterPageUrl, String& webUrl, String& siteUrl, Guid& siteId, Object& buildDependencySetData, SPWebPartCollectionInitialState& initialState, String& siteRoot, String& redirectUrl, Object& oMultipleMeetingDoclibRootFolders, Boolean& objectIsList, Guid& listId, Int64& bytes)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData.GetFileForRequest(HttpContext context, SPWeb web, Boolean exclusion, String virtualPath)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.InitContextWeb(HttpContext context, SPW...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40471	04/06/2013 00:02:29.81*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ai1wu  Medium    ...eb web)     at Microsoft.SharePoint.WebControls.SPControl.SPWebEnsureSPControl(HttpContext context)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.GetContextWeb(HttpContext context)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.PostResolveRequestCacheHandler(Object oSender, EventArgs ea)     at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)     at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)     at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)     at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40472	04/06/2013 00:02:29.81*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ai1wu  Medium    ... wr, HttpContext context)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)     at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)     at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)     at System.Web.Hosting.P...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40473	04/06/2013 00:02:29.81*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ai1wu  Medium    ...ipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)    ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40474	04/06/2013 00:02:29.81   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Monitoring                      b4ly  High      Leaving Monitored Scope (GetFileAndMetaInfo). Execution Time=203.9447  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40475	04/06/2013 00:02:29.81   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Monitoring                      b4ly  High      Leaving Monitored Scope (PostResolveRequestCacheHandler). Execution Time=206.8747  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40476	04/06/2013 00:02:29.83   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         8nca  Medium    Application error when access /sites/Business/Company/SiteAssets/Improve.aspx, Error=Cannot complete this action.  Please try again.   at Microsoft.SharePoint.Library.SPRequestInternalClass.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, G...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40477	04/06/2013 00:02:29.83*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         8nca  Medium    ...uid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)     at Microsoft.SharePoint.Library.SPRequest.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& ...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40478	04/06/2013 00:02:29.83*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         8nca  Medium    ...pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40479	04/06/2013 00:02:29.84   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Runtime                         tkau  Unexpected  System.Runtime.InteropServices.COMException: Cannot complete this action.  Please try again.    at Microsoft.SharePoint.Library.SPRequestInternalClass.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40480	04/06/2013 00:02:29.84*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Runtime                         tkau  Unexpected  ...& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)     at Microsoft.SharePoint.Library.SPRequest.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Obj...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40481	04/06/2013 00:02:29.84*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Runtime                         tkau  Unexpected  ...ect& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40482	04/06/2013 00:02:29.86   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ajlz0  High      Getting Error Message for Exception Microsoft.SharePoint.SPException: Cannot complete this action.  Please try again. ---> System.Runtime.InteropServices.COMException: Cannot complete this action.  Please try again.     at Microsoft.SharePoint.Library.SPRequestInternalClass.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarM...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40483	04/06/2013 00:02:29.86*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ajlz0  High      ...ultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)     at Microsoft.SharePoint.Library.SPRequest.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependencySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstr...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40484	04/06/2013 00:02:29.86*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ajlz0  High      ...SiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, Guid& pgDocScopeId)     --- End of inner exception stack trace ---     at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx)     at Microsoft.SharePoint.Library.SPRequest.GetFileAndMetaInfo(String bstrUrl, Byte bPageView, Byte bPageMode, Byte bGetBuildDependenc...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40485	04/06/2013 00:02:29.86*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ajlz0  High      ...ySet, String bstrCurrentFolderUrl, Int32 iRequestVersion, Byte bMainFileRequest, Boolean& pbCanCustomizePages, Boolean& pbCanPersonalizeWebParts, Boolean& pbCanAddDeleteWebParts, Boolean& pbGhostedDocument, Boolean& pbDefaultToPersonal, Boolean& pbIsWebWelcomePage, String& pbstrSiteRoot, Guid& pgSiteId, UInt32& pdwVersion, String& pbstrTimeLastModified, String& pbstrContent, UInt32& pdwPartCount, Object& pvarMetaData, Object& pvarMultipleMeetingDoclibRootFolders, String& pbstrRedirectUrl, Boolean& pbObjectIsList, Guid& pgListId, UInt32& pdwItemId, Int64& pllListFlags, Boolean& pbAccessDenied, Guid& pgDocid, Byte& piLevel, UInt64& ppermMask, Object& pvarBuildDependencySet, UInt32& pdwNumBuildDependencies, Object& pvarBuildDependencies, String& pbstrFolderUrl, String& pbstrContentTypeOrder, ...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40486	04/06/2013 00:02:29.86*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ajlz0  High      ...Guid& pgDocScopeId)     at Microsoft.SharePoint.SPWeb.GetWebPartPageContent(Uri pageUrl, Int32 pageVersion, PageView requestedView, HttpContext context, Boolean forRender, Boolean includeHidden, Boolean mainFileRequest, Boolean fetchDependencyInformation, Boolean& ghostedPage, String& siteRoot, Guid& siteId, Int64& bytes, Guid& docId, UInt32& docVersion, String& timeLastModified, Byte& level, Object& buildDependencySetData, UInt32& dependencyCount, Object& buildDependencies, SPWebPartCollectionInitialState& initialState, Object& oMultipleMeetingDoclibRootFolders, String& redirectUrl, Boolean& ObjectIsList, Guid& listId)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData.FetchWebPartPageInformationForInit(HttpContext context, SPWeb spweb, Boolean mainFileRequest, String path...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40487	04/06/2013 00:02:29.86*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ajlz0  High      ..., Boolean impersonate, Boolean& isAppWeb, Boolean& fGhostedPage, Guid& docId, UInt32& docVersion, String& timeLastModified, SPFileLevel& spLevel, String& masterPageUrl, String& customMasterPageUrl, String& webUrl, String& siteUrl, Guid& siteId, Object& buildDependencySetData, SPWebPartCollectionInitialState& initialState, String& siteRoot, String& redirectUrl, Object& oMultipleMeetingDoclibRootFolders, Boolean& objectIsList, Guid& listId, Int64& bytes)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModuleData.GetFileForRequest(HttpContext context, SPWeb web, Boolean exclusion, String virtualPath)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.InitContextWeb(HttpContext context, SPWeb web)     at Microsoft.SharePoint.WebControls.SPControl.SPWebEnsureSPControl(HttpCo...  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40488	04/06/2013 00:02:29.86*  w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         ajlz0  High      ...ntext context)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.GetContextWeb(HttpContext context)     at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.PostResolveRequestCacheHandler(Object oSender, EventArgs ea)     at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40489	04/06/2013 00:02:29.98   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        ahjqp  High      [Forced due to logging gap, cached @ 04/06/2013 00:02:29.86, Original Level: Verbose] SQL connection time: 0.0731  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40490	04/06/2013 00:02:29.98   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        8acb  High      [Forced due to logging gap, Original Level: VerboseEx] Reverting to process identity  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40491	04/06/2013 00:02:30.14   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Database                        ahjqp  High      [Forced due to logging gap, cached @ 04/06/2013 00:02:29.98, Original Level: Verbose] SQL connection time: 0.0655  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40492	04/06/2013 00:02:30.14   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Upgrade                         aiaih  High      [Forced due to logging gap, Original Level: Verbose] desiredVersion: {0}  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40493	04/06/2013 00:02:30.19   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           General                         aat87  Monitorable     ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40494	04/06/2013 00:02:30.25   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Upgrade                         aiaih  High      [Forced due to logging gap, cached @ 04/06/2013 00:02:30.20, Original Level: Verbose] desiredVersion: {0}  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40495	04/06/2013 00:02:30.25   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Asp Runtime                     aj1kp  High      [Forced due to logging gap, Original Level: Verbose] SPRequestModule.PreSendRequestHeaders  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d
    	40496	04/06/2013 00:02:30.25   w3wp.exe (0x1534)                         0x16F8  SharePoint Foundation           Monitoring                      b4ly  Medium    Leaving Monitored Scope (Request (GET:https://portal.domain.local:443/sites/Business/Improve.aspx)). Execution Time=650.3091  ede20e9c-cd0e-80a3-b6fd-cdc12970fc6d


    Friday, April 5, 2013 9:12 PM

Answers

  • OK, to resolve this I gave dbo and db_rbs* roles for the application pool account on the content db. Phew!

    Friday, April 5, 2013 9:18 PM

All replies

  • OK, to resolve this I gave dbo and db_rbs* roles for the application pool account on the content db. Phew!

    Friday, April 5, 2013 9:18 PM
  • I have been receiving the same error and this is the only info on the issue so here is my 2 cents.  I hope this helps someone else if you get this issue.

    Problem: Enabling and disabling RBS gave me this issue on the server running the SSRS SSA in the ULS:

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

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   

    Disabling the RBS on the Content database allows me to add new Rdl files.

    More Info:

    http://blog.sharepointsite.co.uk/2014/01/sp-2013-ssrs-failing-after-rbs-enabled.html


    • Edited by paulb32 Friday, January 17, 2014 12:42 PM Spelling
    Thursday, January 9, 2014 1:16 PM
  • Give db_rbs_admin the role on the content database(s) to the account used to call the function, in my case this was the SharEPoint SSRS SSA app pool account and not the app pool account running the web application.
    Friday, January 17, 2014 1:43 PM
  • Here are the steps for granting the permissions:

    1. In SQL Server Management Studio, connect to the SQL Server instance with the content database.
    2. Expand Databases, expand the content database, expand Security, expand Users
    3. Select the user account for the web application pool account. Right click, Properties.
    4. Select the Membership page
    5. Select db_rbs_admin and db_owner roles. Click OK
    6. Under the database, expand Security, Schemas, and double click mssqlrbs
    7. Select the Permissions page. Search for the application pool account and grant the Execute permission. Click OK
    8. Refresh the SharePoint page in your browser


    • Edited by Jason Warren Friday, July 22, 2016 11:08 PM added mssqlrbs schema permissions
    Friday, July 22, 2016 10:08 PM
  • Jason, is there an actual technet document describing the necessary permissions or are those two roles db_rbs_admin and db_owner just made it work? I curious since I thought the SPDataAccess role superceeds db_owner in 2013.
    Wednesday, March 8, 2017 4:20 PM
  • I took a look at the roles in a 2013 Farm.

    db_rbs_admin has View permission to the mssqlrbs schema. SPDataAccess does not.

    I'm not sure about db_owner though. It's likely overkill for this purpose. My suggestion would be to grant the db_rbs_admin role and see if that works. To be honest when I wrote my comment it was only to expand on the steps for setting these permissions as it wasn't clear from the accepted answer.

    Wednesday, March 8, 2017 5:09 PM
  • this worked for me.  problem was exclusive to accessing sql reports (via SSRS integration).
    Thursday, August 1, 2019 3:31 PM