login failed to contained database

• sej2008

  SSCarpal Tunnel

  Points: 4495

  More actions

  August 7, 2014 at 6:59 am

  #294032

  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.