title: SQL - Server always encrypted not workings with applicationpoolidentity
body: <p>I have a web application that read and write from/to database and I use with always encrypted.</p>
  
  <p>When I tried my web application in my local device(where I developed the site) it's work perfect but when I created web site in the server it's can't read from the database because my application doesn't found the CEK(the public key cert).</p>
  
  <p>In the server I created a new database and do the always encrypted, and add the applicationpoolidentity to my database with the following steps:</p>
  
  <ul>
  <li>Add login account IIS APPPOOL\name applicationpoolidentity.</li>
  <li>Add the login as user in the relevant database.</li>
  </ul>
  
  <p>I search a lot for solution but nothing work. </p>
  
  <p>For example:</p>
  
  <ul>
  <li>Create new windows user connect to database with SQL Server in
  Single-User Mode : I saw that solution will be problematic.</li>
  <li>Add name application pool identity as login windows auth in the
  SQL-Server but not working. Who can i connect with application pool
  identity as login to SQL-Server?</li>
  </ul>
  
  <p>I gave up, I need help :)</p>