Summary of setup:
The application pool need to authenticate and run as the user that has access to the database. This setting is available in the Advanced Settings of the Application pool in IIS.
The SmartcryptDB.exe utility needs to be executed by the account that has access to the database server. The SmartcryptDB.exe utility can be “Run As” any user by holding <Shift> and Right Clicking in Windows Explorer.
Then logging in as the actual Windows account defined in SQL Server to have access
<connectionStrings> <add name="SmartcryptEntities" providerName="System.Data.SqlClient" connectionString="Data source= DBSERVER;initial catalog= DBNAME;Integrated Security=true;multipleactiveresultsets=True;App=EntityFramework" /> </connectionStrings>
DBSERVER = Name of the database server – example: qadbserv.domain.com
DBNAME = Name of the Database created in the server - example: smartcrypt