title: Different database for each user
body: <p>We are building a web application using asp.net mvc and sql server 2012. The users of this application are sql developers, each of them have sql server installed in their local machines. </p>
  
  <p>If user A opens the application, the data from User A's local sql server has to be displayed in the application.</p>
  
  <p>If user B opens the application, the data from User B's local sql server has to be displayed in the application.</p>
  
  <p>If a new users joins, the application has to point their database.</p>
  
  <ul>
  <li>Is it possible to create such an web application which dynamically
  points to different databases? </li>
  <li>If yes, what is the best approach for the same?</li>
  <li>If yes, what are the pros and cons of this kind of web app? </li>
  <li>If no, is windows/native application is the alternate approach?</li>
  </ul>