This is the first post in a series of partially contained databases. In part 1 we will discuss the setup of this feature including the authentication across the instance.
1.A. Enable contained databases using SSMS
- Server properties
- Containment: set Enable Contained Databases to True
1.B. Enable contained databases using T-SQL
EXEC sys.sp_configure N’contained database authentication’, N’1′
RECONFIGURE WITH OVERRIDE
2. Restart the SQL Server instance