title: SQL Server Auditing and Website
body: <p>Is there any way to use SQL Server Auditing when the primary database interaction is from a website without impersonation?  </p>
  
  <p>All database actions come from a web application whose connection string uses a single logon / password.  In the website, user authentication / creation comes from the membership provider, but is not passed through to the SQL Server.  I would like to audit which website user performed which action on the SQL Server using the built-in audit mechanism.  </p>