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.
| Author |
Topic |
|
coolone
Starting Member
3 Posts |
 Posted - 2012-08-23 : 10:18:43
|
| 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:11can some one please guide me through some steps on how to configure IIS 7 and SQL server loginTHanks |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2012-08-24 : 05:48:15
|
| Simply remove Windows account for SQL Server and recreate.--------------------------http://connectsql.blogspot.com/ |
 |
|
|
coolone
Starting Member
3 Posts |
Posted - 2012-08-24 : 11:08:52
|
So, shall i remove the groupo and again create a new login for the active directory group with windows authenticationquote:
Originally posted by lionofdezert
Simply remove Windows account for SQL Server and recreate.--------------------------http://connectsql.blogspot.com/
|
|
|
|
|
|
|
IIS 7 and SQL Server