odd aspnetdb database behavior

[Josh Nikle]

i'm in the process of putting my first .net app on my host's server,
and i'm
having no end of trouble getting the aspnetdb database
(sitememberships on my
host) to work correctly. as i read, apparently not uncommon. my
particular
issue seems to be though?

after a lot of research, i'm able to connect to this database with
this connection
string in my web.config file:
<remove name="LocalSqlServer"></remove>
<add name="LocalSqlServer" connectionString="Data Source=[host
server]; User
ID=[username]; Password=[password]; Initial Catalog=sitememberships"
providerName="System.Data.SqlClient" />
thanks to this newsgroup for that.

my problem is that as soon as i create a new user via my site, i can
no longer
log in as any previously entered users. i'm using the
CreateUserWizard control bundled
in asp.net to create the new accounts in the database. for example,
if i create a user
JOSH, i can log in and navigate without issue. as soon as i create
JOSHAGAIN
however, i get a validation error if i try to log in as JOSH. i also
get a "page
cannot be found" error when i click on the "log out" link in my
LoginView control, but i
don't know that it's related.

has anyone ever seen this behavior before? any light shed on this
would be greatly
appreciated.

-josh