I have an application that is being developed for our Intranet.
Which will require authentication of users that are members in an Active Directory group; TIRES Users, TIRES Super, TIRES Admin.
Additionally, I created three SQL Application Roles, TIREAdminCRUD, TIRESuperRU, TIRESUser, with three distinct passwords.
Each group was given execute right to various stored procedures with the schema as 'dbo'.
My web.config is:
<roleManager enabled="true" defaultProvider="AspNetWindowsTokenRoleProvider"/>
<allow users ="TIRES Users, TIRES Super, TIRES Admin"/>
<add name="TIREConnectionString" connectionString="Data Source=DOMAIN\INSTANCE;Initial Catalog=Tires;Integrated Security=True";providerName="System.Data.SqlClient "/>
The goal of my application is to authenticate each user which I do using the following code:
In my asp.net (VB
) Page Load I have the following which is working.
Dim strAdmin As String
strAdmin = " TIRES Admin"
If (Roles.IsUserInRole(strAdmin)) Then
But I am running into a problem when they try to connect to the SQL server; the following error message appears:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
How do I now authorize each user based on their assigned AD group to allow the execution of the stored procedures?