Tag Archives: RBS Maintainer

SharePoint and RBS Maintainer – connection string issues

Recently I have seen an issue with RBS Maintainer that was failing during the execution of the RBS garbage collection.

Issue:

Every time when executing the following command it was failing without deleting the orphan BLOBs

C:Program Files\Microsoft SQL Remote Blob Storage 10.50\Maintainer\Microsoft.Data.SqlRemoteBlobs.Maintainer.exe” -ConnectionStringName RBSMaintainerConnection -Operation ConsistencyCheck GarbageCollection Maintenance -ConsistencyCheckForStores ForceFinalize -GarbageCollectionPhases rdo -ConsistencyCheckMode b

Errors in the SharePoint logs: User does not have permission to perform this action. You do not have permission to run the RECONFIGURE statement.

and a lot of Access Denied at the SQL level (even if the account was added with sysadmin rights)

Continue reading