Author: Ayomide | Posted on: 10/16/2008 6:59:07 AM | Views : 237

Hello,
 I need to Authenticate (Active Directory) and Authorize Users based on Application Roles within SQL 2005.  As I am cutting my teeth on Application Roles, assistance is greatly appreciated in getting my application up and working.  When I run the page I get the following error message: Cannot open database "ADatabase" requested by the login. The login failed.  Login failed for user 'DOMAIN\UserName'. 
This is what I have.

Go to the complete details ...