jueves, 19 de abril de 2012
Create User for Contained Database
Following with conained Databases in SQL Server 2012 (Enabling contained databases), we must create a User for login in.
The first step is to create the SQL user User with Password (userName: containedUser)
Make sure to set a membership role, for example db_owner.
Now, try to connect to Contained database, choose SQL Authentication and complete your Login and Password.
The most important!, don't forgett to specify the database Name, in connection properties.
This is the flow that SQL Server use to log in Database.