I am wondering what are the reasons or maybe technical limitations all of Sitecore 9 databases to be Partially Contained except Xdb.Collection.Shard0, Xdb.Collection.Shard1 and Xdb.Collection.ShardMapManager.


1 Answer 1


xConnect uses a change tracking functionality which requires a SQL User so it can access multiple databases. For this reason, contained database authentication cannot be used on the xDB Collection databases (shards and shard manager).

Source info (from @Rosen Petrov): https://www.timmitchell.net/post/2016/11/18/video-introduction-to-sql-server-change-tracking/


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.