My application is composed of users located in three Active Diretory groups, TIRES Users, TIRES Super, TIRES Admin. Using the following code I can determine which of the three groups a user to the application is assigned to.Dim strAdmin As StringstrAdmin = " TIRES Admin"If (Roles.IsUserInRole(strAdmin)) Then'continueElseResponse.Redirect(http://tires/home.asp)End If
*********The next step I undertook was to create three SQL Application Roles, TIREAdminCRUD, TIRESuperRU, TIRESUser.Each group were given execute right to various stored procedures with the schema as 'dbo'.
********* How now do I, in the Page_Load Event, utilizing Roles.IsUserInRole(strAdmin)) , determine which SQL Application Roles the user belongs to in order to have the right user execute or not execute the correct stored procedure?*********My web.config connection string is:<add name="TIREConnectionString" connectionString="Data Source=DOMAIN\INSTANCE;Initial Catalog=Tires;Integrated Security=True"/>*********When I attempt to view the web page on our Intranet I receive the following error message: Login failed for user 'DOMAIN\SERVER_NUMBER$'. *********I have read at least a dozen various web web sites over the past two weeks, at least, and tried many diffect scenaios to no avail!
Specifically, what do I type to get this working and where? Thank you, greatly!!
Ayomide