I am trying to create a sample application in asp .net mvc with sql server authentication.
I want to create a user with password in sql server so that i can provide it in connection string in asp .net mvc web.config.
My question is how to create a user in sql server 2012 and later login using that user and password,and create databases and tables for my entity framework in .net
What are the steps to create a user and password??