I am pretty new working with MSSQL and have 2012 version at the moment. What I'm trying to do is create a user for a contained database, and give that user access only to that database.
I will invoke this SQL from JAVA using a prepared statement.
To create a contained user in SQL Server 2012 that authenticates at the database, you can do the following:
You will have to ensure that
Once those above commands are executed you should be able to create your contained user with the
EDIT: Great comment and points by @AaronBertrand: