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, privacy policy and cookie policy

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