I'm having a hard time finding a solution to this problem. I have an application that is hosted in a DMZ and uses a linked server to access data in an internal database (behind a firewall). Currently, I have just the tables and procs needed to authenticate the user in the DMZ. The rest of the database and data exist on the internal server.
I was forced to do this because it seems the Membership controls/system need direct access to the database. I haven't found an example of an authentication solution that passes requests through a linked server. Preferably, I'd like to do this programatically and not via the web.config file. Can this be done?
Thanks, Greg
...
Go to the complete details ...