Two key steps are required to create partially contained database in SQL Server 2012. The first step is to enable contained database authentication. Contained database authentication is enabled or disabled for the entire SQL Server instance. This can be done using SSMS or via T-SQL. In SSMS, right-click on the server name in Object Explorer and click Properties. On the Advanced tab, set the Enable Contained Databases option to True, as shown in Figure 19.9.
The following T-SQL statements can also be used to enable contained database authentication: