title: How to access SQLite DB from IIS hosted WCF Service?
body: <p>I am trying to deploy a WCF service that uses a SQLite DB to read some data as well as connecting to another Database (MS SQL). The service itself is consumed by a ASP Web site running on the same server.</p>
  
  <p>The problem is that only my user is able to fully use the website and service. Every other user can't seem to open the sqlite database file.</p>
  
  <p>What kind of permissions or special access do you need to access a sqlite database from IIS?</p>
  
  <p>The Application pool is setup with a domain account so that access to the MS SQL Database can be granted (Integrated Security).</p>
  
  <p>The folder where the database is stored is accessible by the account. And I've even tried to make it accessible by Everyone and all users with no luck.</p>
  
  <p>I feel I'm missing something obvious but I can't figure out what...</p>
  
  <p><strong>Update:</strong> The error is as follows:</p>
  
  <p>System.Data.Entity.Core.EntityException</p>
  
  <p>An exception of type 'System.Data.Entity.Core.EntityException' occurred in EntityFramework.dll but was not handled in user code</p>
  
  <p>Additional information: The underlying provider failed on Open.</p>
  
  <p><em>Inner Exception:</em></p>
  
  <p>System.Data.SQLite.SQLiteException</p>
  
  <p>Unable to open database file.</p>