I "unextended" and reextended the web application and set everything
up for the Extranet zone, including all the changes to the web.config
files.
In Central Admin, I'm able to add the ASP.NET SQL DB roles. I'm also
able to log in as any ASP.NET SQL DB user that belongs to one of those
roles - problem solved!
Now, here's my next challenge. I need to be able to target content to
the roles from the ASP.NET SQL DB. In order to do that, the users need
profiles. They don't have profiles because they aren't in Active
Directory or LDAP. I can't manually add a profile, because the system
things the Account Name is invalid (which is true, the account name
doesn't exist in AD or LDAP). From my research, I can only add/import
profiles from an AD or LDAP source. I can use BDC to add property
values to existing profiles, but not to import in.
So, the new question is: How can I target content to users/roles in
the Extranet zone? I really don't want these users in the Active
Directory.
Thanks in advance for all of those who helped with this.