Is SQL Server 2012 Contained Databases feature supported for SOI 4.0 and 4.2
SQL Server 2012 Contained Databases feature is not yet certied with SOI 4.0 and 4.2
The workaround to install SOI 4.0 and 4.2 for SQL Server 2012 Contained Database is to
add the SAMStore database user as a SQL User at the top-level security in the
SQL Server for the installation of SOI.
Once the SOI installation has finished, the SAMStore database user
can be added as a contained user for the SAMStore database.
This needs to be considered for patches that contain database updates as well.
One of the key features of a CDB is the ability to remove the reliance upon logins so that the database will become more portable. As a result the concept of Contained Users is introduced in SQL Server 2012.
A contained user is a user without a login in the master database which resides in a Contained Database and can connect to this database specifying its credentials in the connection string. For SQL Server Authentication Users, this implies that the password will have to be provided when such users are created; Windows Authentication Users can be created the same way they are traditionally created.