Right now I have an IIS 7.5 server running a basic Windows Domain Aspx forms website. Right now I use the Web.config file to control access using a Domain Group. (Example 1) I want to change that over a MS SQL database. Why…? Since getting users added to the Active Directory Domain group takes why too long in our environment. (bla, bla, paperwork)
What I have right now:
1) I have is a SQL database table that has everyone’s “sAMAccountName” on the domain in it. (I have a VBS script that update it every night with user attributes)
2) I have another Sql table what have will be used for access the Team portal. This table will hold the names of the employees on the domain that can access this site. I’ll update this table from an Admin ASPX page.
3) I don’t want that users to have to enter any user name of password to log into the site. I want it to be automatic like it is now the the go to the link.
I don’t know if this makes any sense, but I’m not sure where to start or how to start googling for this.
<allow roles="DOMAIN\DomainSecurityGroup" />
<deny users="*" />