title: Certificate-Based Authentication in SQL Server
body: <p>currently i'm struggling with my current project. I was tasked to replace the use of <strong>Username/Password based Authentication/Connection</strong> to SQL Server (2014) and replace it with a <em>Certificate based Authentication/Connection</em> one. So probably my questions are:</p>
  
  <ol>
  <li><p>Is this possible with SQL Server ?</p>
  
  <ul>
  <li>The idea is to no longer include the username/password combination to connect to the Database Instance from the Server. This then would be replaced by a certificate where, ideally would hold all the login credentials (encrypted). So in simpler terms, every pc that will use the system will need to be issued a certificate to connect to the database.</li>
  </ul></li>
  <li><p>If possible, is this a Single Certificate for All or One Computer - One Certificate ?</p></li>
  </ol>
  
  <p>hoping to get some good/bad opinions here. thank you</p>