Move asp.net profile/membership tables to sql server

Discussion in 'ASP .Net' started by Brandon Holliday, May 18, 2007.

  1. Hello,

    I have a problem that I need some help on.

    I am creating a website that utilizes the builtin membership functionality
    in Asp.net 2.0. By default, the "AspNetSqlProvider" is used and the
    membership data is stored in "AspNetDB.mdf". However, instead of using this
    mdf file, I would like to store the membership data in Sql Server, using the
    "SqlMembershipProvider". I have already run the "regsql.exe" file, but I'm
    not sure of what I need to do next. Do I delete the AspNetDB.mdf data file
    that is in my web project? Do I need to manually specify the membership
    provider in the web.config file? Any suggestions would certainly be
    appreciated.

    Thanks.
    Brandon Holliday, May 18, 2007
    #1
    1. Advertising

  2. Brandon Holliday

    sloan Guest

    Check here:

    http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

    and

    http://www.aspcode.net/articles/l_e...rship-provider-with-SQL-2000_article_279.aspx


    You'll find most of your answers there.

    My last name is Holliday too.

    That's crazy!


    http://sholliday.spaces.live.com/blog/



    "Brandon Holliday" <> wrote in message
    news:D...
    > Hello,
    >
    > I have a problem that I need some help on.
    >
    > I am creating a website that utilizes the builtin membership functionality
    > in Asp.net 2.0. By default, the "AspNetSqlProvider" is used and the
    > membership data is stored in "AspNetDB.mdf". However, instead of using

    this
    > mdf file, I would like to store the membership data in Sql Server, using

    the
    > "SqlMembershipProvider". I have already run the "regsql.exe" file, but

    I'm
    > not sure of what I need to do next. Do I delete the AspNetDB.mdf data

    file
    > that is in my web project? Do I need to manually specify the membership
    > provider in the web.config file? Any suggestions would certainly be
    > appreciated.
    >
    > Thanks.
    >
    sloan, May 18, 2007
    #2
    1. Advertising

  3. Hey Sloan,

    Thanks for the quick reply. I took a look at Scott Gu's blog, and it helped
    me.

    And it's not everyday you find a Holliday. That's crazy!

    Thanks again.
    "sloan" <> wrote in message
    news:...
    >
    > Check here:
    >
    > http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx
    >
    > and
    >
    > http://www.aspcode.net/articles/l_e...rship-provider-with-SQL-2000_article_279.aspx
    >
    >
    > You'll find most of your answers there.
    >
    > My last name is Holliday too.
    >
    > That's crazy!
    >
    >
    > http://sholliday.spaces.live.com/blog/
    >
    >
    >
    > "Brandon Holliday" <> wrote in message
    > news:D...
    >> Hello,
    >>
    >> I have a problem that I need some help on.
    >>
    >> I am creating a website that utilizes the builtin membership
    >> functionality
    >> in Asp.net 2.0. By default, the "AspNetSqlProvider" is used and the
    >> membership data is stored in "AspNetDB.mdf". However, instead of using

    > this
    >> mdf file, I would like to store the membership data in Sql Server, using

    > the
    >> "SqlMembershipProvider". I have already run the "regsql.exe" file, but

    > I'm
    >> not sure of what I need to do next. Do I delete the AspNetDB.mdf data

    > file
    >> that is in my web project? Do I need to manually specify the membership
    >> provider in the web.config file? Any suggestions would certainly be
    >> appreciated.
    >>
    >> Thanks.
    >>

    >
    >
    Brandon Holliday, May 18, 2007
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?V29sZmVpdHo=?=

    asp.net 2.0 membership/profile question

    =?Utf-8?B?V29sZmVpdHo=?=, Dec 14, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    427
    =?Utf-8?B?V29sZmVpdHo=?=
    Dec 14, 2005
  2. Jeff Jarrell
    Replies:
    3
    Views:
    440
    Jeff Jarrell
    May 25, 2006
  3. shapper
    Replies:
    1
    Views:
    356
    =?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=
    Feb 23, 2007
  4. keith
    Replies:
    2
    Views:
    490
    keith
    Feb 26, 2007
  5. Andy B
    Replies:
    0
    Views:
    519
    Andy B
    May 3, 2008
Loading...

Share This Page