where are Roles stored?

where are Roles stored?

I just started dabbling in to ASP.NET security. Have a few questions. 1) I
used role management to restrict access to certain page. This was the
section of my web.config
<profile>
<providers>
<clear />
<add name="AspNetSqlProfileProvider"
type="System.Web.Profile.SqlProfileProvider, System.Web,
Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a"
connectionStringName="LocalSqlServer" applicationName="/" />
</providers>
</profile>
<roleManager enabled="true">
<providers>
<clear />
<add connectionStringName="LocalSqlServer" applicationName="/"
name="AspNetSqlRoleProvider"
type="System.Web.Security.SqlRoleProvider, System.Web,
Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />
<add applicationName="/" name="AspNetWindowsTokenRoleProvider"
type="System.Web.Security.WindowsTokenRoleProvider,
System.Web, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
</roleManager>
This works fine. But what happened was the connecitonStringName was set to
"ApplicationServices" before. And it wouldn't work. I then changed it to
"LocalSqlServer". It started working.
So I want to understand, why would that happen? Also, is LocalSqlServer
just another arbitrary name for the connection string value? I checked the
database, the roles aren't stored there. So where are the roles stored
then?
These are newbie questions. I thank your patience in advance