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??

| improve this question | | | | |
  • 1
  • Just curious, why do you want to use SQL Server authentication? – Antoine Hernandez Nov 17 '16 at 7:38
  • i was learning how to use it with entity framework in asp .net since the projects that i have worked so far all use it – DAre G Nov 17 '16 at 8:21
  • Ahh ok. I was going to recommend not using SQL Server authentication since you have to place the username and password in the web.config where as using Windows Authentication you wouldn't have to do that but since just learning, perhaps it doesn't matter. – Antoine Hernandez Nov 17 '16 at 8:32
  • But we have used sql server authentication for all the projects that i have worked.does windows authentication work if everyone is accessing data in a server. – DAre G Nov 17 '16 at 8:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.