Wednesday, August 5, 2015

Contained Database user connectivity


1.Enable contained database feature

USE master
GO
sp_configure 'show   advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'CONTAINED   DATABASE AUTHENTICATION', 1
GO
RECONFIGURE
GO
sp_configure 'show   advanced options', 0
GO
RECONFIGURE
GO

2.Connecting to Contained database after creating the user(sql or windows authentication)
First you will get an error as shown below. You have to give database name in Options tab in SSMS.Then only it will connect.


No comments:

Post a Comment