ASP.Net Membership not accessing my Sql Server Database

Question

I ran aspnet_regsql on my database where i want to store the membership tables in. It's the same database i store all the tables for my workload.

However when i register a user on my site, it creates the user in a table ASPNETDB rather than the one i created in Sql server.

<?xml version="1.0"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <connectionStrings>
    <add name="HotelProjectConnectionString" connectionString="Data Source=KHAN-PC;Initial Catalog=HotelProject;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

  <system.web>
    <roleManager enabled="true" />
    <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
        <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
        <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
      </assemblies>
    </compilation>
  </system.web>
</configuration>

I had a similar issue. stackoverflow.com/questions/12203495/… — Josh Claxton
– Josh Claxton, Commented Sep 9, 2012 at 7:47

Agent007 · Accepted Answer · 2012-09-08 12:05:14Z

3

You must specify Membership provider in you web.config under system.web tag. Check

this link fro reference.

answered Sep 8, 2012 at 12:05

Agent007

2,7503 gold badges23 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1638362 Over a year ago

Got it thnx, i saw this before aswell!

Collectives™ on Stack Overflow

ASP.Net Membership not accessing my Sql Server Database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related