0

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
5
  • 1
    ,c-sharpcorner.com/UploadFile/dhananjaycoder/…
    – Md Haidar Ali Khan
    Commented Nov 17, 2016 at 7:22
  • Just curious, why do you want to use SQL Server authentication?
    – Antoine Hernandez
    Commented Nov 17, 2016 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
    Commented Nov 17, 2016 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
    Commented Nov 17, 2016 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
    Commented Nov 17, 2016 at 8:47

1 Answer 1

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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