title: How to migrate a Visual Studio 2012 ASP.Net MVC 4 project to use an SQL Server instance instead of a data file?
body: <p>When I create a new ASP.Net MVC 4 project with Visual Studio 2012 it puts the data in an mdf file in the project directory.</p>
  
  <p>What I would like to do at this point is to migrate the database to an SQL Server instance gently, keeping all the scaffold stuff provided by the ASP.Net MVC 4 project template (I mean user accounts management etc.)</p>
  
  <p>What would be the right step-by-step way to do this?</p>
  
  <p>How exactly should I change the connection string?</p>
  
  <p>How should I authentify my application in SQL Server in production?</p>
  
  <p>Sorry for a dumb question but I haven't dealt with ASP.Net applications before, in my previous experience (which was with WinForms) all the actual users had a separate SQL Server account and it was pretty straightforward.</p>