SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SQL Server 2014 Download and Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




download SQL Server 2017
download SQL Server 2016
download SQL Server 2014



Enable SQL Server Contained Database Authentication

To create a contained database on SQL Server, using sp_configure 'contained database authentication' configuration must be set to 1. Otherwise, SQL Server administrator or database developers will face the following error message:

The sp_configure value 'contained database authentication' must be set to 1 in order to create a contained database. You may need to use RECONFIGURE to set the value_in_use. (Microsoft SQL Server, Error: 12824)

In this SQL Server tutorial, I tried to share SQL sp_configure script to enable 'contained database authentication' which will enable database professionals to create contained database on SQL Server.

While using SQL Server Management Studio to create new database on my SQL Server 2014 instance, I set the Containment type property of the new database to Partial. My aim to change the containment type is to change the database properties like Default Fulltext Language LCID and Default Language.

Unfortunately SQL Server database engine displayed the following error message, when I pressed OK button to create new database on SQL Server instance.

sp_configure value 'contained database authentication' must be set to 1 in order to create a contained database

The sp_configure value 'contained database authentication' must be set to 1 in order to create a contained database. You may need to use RECONFIGURE to set the value_in_use. (Microsoft SQL Server, Error: 12824)

sp_configure 'contained database authentication'

SQL Server sp_configure contained database authentication

As you see the run_value of the SQL Server configuration parameter contained database authentication is 0.
SQL Server database administrators or developers who have the required permission can execute following sp_configure command to set contained database authentication to "1".

sp_configure 'contained database authentication', 1
reconfigure

That is all! Right after altering the SQL Server configuration option from 0 to 1, I could successfully create a contained database on SQL Server 2014 instance.






SQL Server Resources

SQL Server Articles

SQL Server 2012

SQL Server Tools

SQL Blog

SQL Server 2008 Blog

Certification Exams Blog

Reporting Services Blog

Analysis Services Blog

MS SQL Server Forums



Free Exam Vouchers










Copyright © 2004 - 2018 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems