Authencation and Authorization Using AD and SQL App Roles

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:
 <system.web>
  <authentication mode="Windows"/>
  <roleManager enabled="true" defaultProvider="AspNetWindowsTokenRoleProvider"/>
  <authorization>
      <allow users ="TIRES Users, TIRES Super, TIRES Admin"/>
<deny users="?"/>

<add name="TIREConnectionString" connectionString="Data Source=DOMAIN\INSTANCE;Initial Catalog ...