i'm in the process of putting my first .net app on a remote server, and i'm
having no end of trouble getting the aspnetdb database (sitememberships on my
host) to work correctly.
after a lot of research, i'm able to connect to it 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" />
however, i'm still unable to use any credentials that were in the database
before, even though i used the new database publishing wizard from ms to
create a .sql file and had my host restore the database from that. if i
create a new user, i can use those credentials...until i add another user.
at that point, i can no longer use any other credentials in the database but
the ones just created.
can anyone point me to a step-by-step tutorial for how to put this database
on a remote server or tell me what i'm doing wrong? i found a guide on
creating the .sql file on scottgu's blog, but his connection strings didn't
work for me. i found the working connection string on google groups. if i
even knew what steps had to be performed: are there more things that need
changing in the web.config? another file? code changes?
any light shed on this is greatly appreciated.
-josh
