Need help in web config file

Question

Hi all, I am facing problem when i am creating new user,using CreateUserWizard control.I have added in connection string :

<connectionStrings>
    <add name="BankingTransaction"
      connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Bank.mdf;integrated security=True;User Instance=True"
      providerName="System.Data.SqlClient"/>
</connectionStrings>

After adding this connection string in web.config file, when i am running the application i am able create the New user Sign up details. But when i am adding the following code in web.config file i am getting error "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'." the code is:

<membership defaultProvider="DefaultMembershipProvider">
  <providers>
    <add connectionStringName="BankingTransaction" 
      enablePasswordRetrieval="true"
      enablePasswordReset="true"
      requiresQuestionAndAnswer="true"
      applicationName="/"
      requiresUniqueEmail="true"
      passwordFormat="Clear"
      minRequiredPasswordLength="3"
      minRequiredNonalphanumericCharacters="1"
      passwordStrengthRegularExpression=""
      name="DefaultMembershipProvider"
      type="System.Web.Security.SqlMembershipProvider"/>
  </providers>
</membership>

Please somebody help me whats wrong with my above red highlighted code.

Thanks, Masum

Answer 1

Please chek this and this and see if it solves your issue. I remeber seeing this question yeterday. Is it a duplicate? :)

Answer 2

I think you should register your new database with ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe) tool.