I can't log in to StoreManager. And I can't create user or role. I have SQL connection error. Also on Security tab I see 2 users and 0 roles. I checked in tables - there's 1 role and 2 users.
I have VS 2010 SP1 and SQL 2008 installed on the named instance SQL2008DEV - I've attached ASPNETDB.MDF from completed solution to SQL (with the name "aspnetdb")
so my connection strings are
<add name="MusicStoreEntities" connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf" providerName="System.Data.SqlServerCe.4.0"/>
<add name="MembershipSQLProvider" connectionString="Data Source=.\SQL2008DEV;Initial Catalog=aspnetdb;Persist Security Info=True;User ID=asp;Pwd=111" providerName="System.Data.SqlClient"
Connection string are OK - I can open in server explorer and browse without problems. Without membership Store Manager works OK.
I put a breakpoint in ActionController : authentification went OK ( Membership.ValidateUser(model.UserName, model.Password) == true ) but after Redirect(returnUrl) I'm getting an error :
SQLExpress database file auto-creation error: The connection string specifies a local Sql Server Express instance using a database location within the application's App_Data directory
I searched my solution (I followed all steps of the tutorial) - there's no connection string with SQLExpress or App_Data anywhere.
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="MembershipSQLProvider"
enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6"
minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" />