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 ...