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.
-
1Thank you Rosen for sharing this link about Contained Databases sqlshack.com/sql-server-2014-contained-databases.– Michael WestCommented Aug 3, 2018 at 13:55
Add a comment
|
1 Answer
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/
answered Aug 3, 2018 at 13:49
-
Some source of info for those who are not familiar: timmitchell.net/post/2016/11/18/… Commented Aug 3, 2018 at 14:24
-
Thank you Rosen, I added that into the answer for any who need it! Commented Sep 10, 2018 at 12:50