Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  IIS 7 and SQL server 2008

Author  Topic  coolone Starting Member 3 Posts Posted - 2012-08-23 : 10:21:10 I am very much new to SQL Server and IIS. We have a website asp.net that uses Sql server to access the data. only the active directory users can access the website. so i created a new login for the active directory users(group) gave few permissions to the group db_reader, db_writer.. some configuration has been done in the iis ( im not sure what has done) If i give sysadmin permission the AD group ,website is working fine.. if I dont then it gives Login failed for user #: reason: token -based server access validation failed with an infrastructure error. error: 18456,severity:14,state:11 can some one please guide me through some steps on how to configure IIS 7 and SQL server login THanks