Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

login failed to contained database Expand / Collapse
Author
Message
Posted Thursday, August 7, 2014 6:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 21, 2014 2:43 AM
Points: 135, Visits: 265
I configured sql server instance to enable contained database .the script is as follows:
SP_CONFIGURE 'SHOW ADVANCED OPTIONS',1
RECONFIGURE
GO
SP_CONFIGURE 'CONTAINED DATABASE AUTHENTICATION',1
RECONFIGURE
GO
SP_CONFIGURE 'SHOW ADVANCED OPTIONS',0
RECONFIGURE
GO

I did enable my user database named DB1 as partial containment.
Later created user as sql user with password option
My sql instance is set on mixed mode.
Although I have done steps as needed I am not been able to log in in contained database.It gives error as follows:

TITLE: Browse Server for Database
------------------------------

Failed to connect to server WIN\SQL2K12. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'containeduser'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476


------------------------------

What is still need to be done .Can anybody help me in this regards.Thanks in advance.
Post #1600602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse