How to reference a membership database that is not in App_Data SQL Server Express database?

Discussion in 'ASP .Net' started by Keith, Jul 2, 2006.

  1. Keith

    Keith Guest

    If I understand correctly, the SQL script called "InstallMembership.sql" can
    be used to create a membership database that exists in the instance of SQL
    Server 2005 used for my main application. Having created such a database,
    how can I get the ASP.NET Web Site Administration Tool to reference that
    database instead of the one that exists in the App_Data folder SQL Server
    Express database? Also, how can I get the membership controls in my
    application to reference the newly created database instead of the one that
    exists in the App_Data folder SQL Server Express database?
    Thanks,

    Keith
    Keith, Jul 2, 2006
    #1
    1. Advertising

  2. Keith

    Keith Guest

    I found the answer to this question in a very good article entitled:
    ASP.NET 2.0 and the Provider Model, without SQL Express
    located at:
    http://weblogs.asp.net/bsimser/archive/2005/11/20/431029.aspx?Pending=true
    I followed the instructions and it worked.

    Thanks,

    Keith

    "Keith" <> wrote in message
    news:...
    > If I understand correctly, the SQL script called "InstallMembership.sql"
    > can be used to create a membership database that exists in the instance of
    > SQL Server 2005 used for my main application. Having created such a
    > database, how can I get the ASP.NET Web Site Administration Tool to
    > reference that database instead of the one that exists in the App_Data
    > folder SQL Server Express database? Also, how can I get the membership
    > controls in my application to reference the newly created database instead
    > of the one that exists in the App_Data folder SQL Server Express database?
    > Thanks,
    >
    > Keith
    >
    >
    Keith, Jul 3, 2006
    #2
    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. Daves
    Replies:
    1
    Views:
    364
  2. Michael
    Replies:
    2
    Views:
    9,032
    magscy
    Jul 19, 2009
  3. =?Utf-8?B?Q2FybCBNLg==?=
    Replies:
    4
    Views:
    2,471
    sivlookingforu
    Aug 7, 2006
  4. farseer

    SQL Server 2005 + SQL Server Express

    farseer, Aug 7, 2006, in forum: ASP .Net
    Replies:
    3
    Views:
    337
    farseer
    Aug 8, 2006
  5. AAaron123
    Replies:
    6
    Views:
    2,485
    AAaron123
    Oct 28, 2008
Loading...

Share This Page