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:11
can some one please guide me through some steps on how to configure IIS 7 and SQL server login
THanks |
|
|
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 authentication
quote:
Originally posted by lionofdezert
Simply remove Windows account for SQL Server and recreate.
--------------------------
http://connectsql.blogspot.com/
|
|
|
|
|
|
|
IIS 7 and SQL Server