SOI installation fails for SQL Server Contained Databases

Document ID : KB000067080
Last Modified Date : 15/08/2018
Show Technical Document Details
Introduction:

 

Question:

 

Is SQL Server 2012 Contained Databases feature supported for SOI 4.0 and 4.2

 

Answer: 

 

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.

 

 

 

Additional Information:

 

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.
 
https://msdn.microsoft.com/en-us/library/ff929071.aspx

 

Instructions:
Please Update This Required Field