title: SQL Server & IIS Trusted Connection Conflict with AD Groups and Logins
body: <p>I have a weird situation.  I want to connect to SQL Server through a website using IiS7.  I also want a bunch of users to be able to connect to the database server through IIS via AD Group.</p>
  
  <p>The issue is, I have to set Trusted_Connection=true in the web.config in order for SQLServer to know to use that users credentials as a windows account and not a sqlserver account.  If this is not set to true, all users in that AD group will try authenticating via sql accounts.</p>
  
  <p>However when I do this, IIS uses the APPPool as the user to connect to the DB and then it doesn't matter the credentials the user use to log in.</p>
  
  <p>I dont want to create an account per user.  That would defeat the purpose.</p>
  
  <p>Please help, is there a workaround for this?</p>
  
  <p>Thanks!</p>