Create a User and Password for ADO.net and SQL SERVER Authentication 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??
Please go through below links :

https://stackoverflow.com/questions/16386610/how-do-i-create-a-new-user-in-sql-server-2012-that-i-can-use-in-a-connection-str

https://msdn.microsoft.com/en-in/library/aa337562.aspx

https://stackoverflow.com/questions/1601186/sql-server-script-to-create-a-new-user