I decided to offer this to help others that might runinto these issues releasing applications into a SQL environment using the Membership DB.
Problem Scope: Ran ASPNET_REGSQL and created database on SQL Server ( Not locally ) . Configured an account with access to the various tables, views, etc.
Relevant Web config portions:
<
add name="ASPNETDB" connectionString="server=sqlserver;database=ASPNETDB;uid=myASPNETDB;pwd=myASPNETDBPW"/><
authentication mode="Forms"></authentication><authorization><deny users=" "/></authorization>
<membership userIsOnlineTimeWindow="20"><providers>
<add connectionStringName="ASPNETDB" applicationName="myApp" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="true" passwordFormat="Hashed" name="SqlProvider" type="System.Web.Security.SqlMembershipProvider" /></providers></membership>
To get this too work I then ran IIS / ASP.NET Configuration:
Initially, I had installed SQLExpress local. In my Connection String Manager I had the following:
LocalSQLServer data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
myASPNETDB
server=sqlserver;database=ASPNETDB;uid=myASPNETDB;pwd=myASPNETDBPW
I just set my LocalSQLServer information to myASPNETDB and I was able to work with the ASP.NET configuration from Visual Studio Express without a problem from my Server and not my local installation of SQLExpress.
I've seen numerous people report problems with this and I thought I would provide what I found out working with the products.
ASPNET_REGSQL - SQL Server Support Visual Web Developer 2005 Express Edition
lmcatl
Hi!
Thanks for posting! I'm a member of the ASP.NET team, and was just popping over here to see what was going on. The best place to ask/post ASP.NET questions/answers is over on the ASP.NET forums at
http://www.asp.net/welcome.aspx tabindex=1&tabid=39HTH,
PEte