I have a web application that currently uses standard security for all users. We would like to transition the security to "sorta" trusted security. What I mean by sorta is that all I want to have happen is that the user is validated to be in an Active Directory Group. The internal security will be handled by the application using a menu system. I set up a linked server and started running selects using OPENQUERY, but for some reason about every 5 minutes the query stops working with:
Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'ADsDSOObject'.
Then after another 2 or 3 minutes it works again.. no changes. I still haven't even gotten to the validation yet, as this problem needs to be solved before I can rely on it for validation. My question is this: Is there a method in place where IIS can validate the user for access and pass the name off to my application? If there is, then I can remove the linked server and just use the IIS for my security interface. Within IIS I would want username and password to be used, since I cannot turnkey the entire operation at one time.
Thank you!
Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'ADsDSOObject'.
Then after another 2 or 3 minutes it works again.. no changes. I still haven't even gotten to the validation yet, as this problem needs to be solved before I can rely on it for validation. My question is this: Is there a method in place where IIS can validate the user for access and pass the name off to my application? If there is, then I can remove the linked server and just use the IIS for my security interface. Within IIS I would want username and password to be used, since I cannot turnkey the entire operation at one time.
Thank you!
