Website Administration Tool - cannot set a new provider

Last post 05-13-2008 1:36 AM by Thomas Sun – MSFT. 3 replies.

Sort Posts:

  • Website Administration Tool - cannot set a new provider

    05-09-2008, 4:02 PM
    • Loading...
    • MrGear
    • Joined on 05-09-2008, 7:49 PM
    • Posts 2

    Hi there,

    I am a bit frustrated, because its not possible to set a new database provider in the Website Administration Tool.

    Wheter I create a new Website or a  Webproject with Visual Studio 2005, in my

    ASP.NET Configuration it is not possible to configure a provider, because

    I only have one "AspNetSqlProvider" Provider selection in the Provider Tab.

    I cannot choose another one and it is also not possible to create a new one.

    There is no other selection possibility and also not assistent

    which offers me to create a new provider or the right connection.

     

    What's wrong? In a lot of other postings or documentations I see that there must be

    the possibility to redirect to the right database connection!

     

    Please help! Thx Mr_Gear

     

  • Re: Website Administration Tool - cannot set a new provider

    05-09-2008, 4:13 PM

    I hadn't really thought about there not being other options but I've always setup my own configuration in web.config for the provider I wanted to use and then went to the configuration tool to setup users, roles and permissions. 

  • Re: Website Administration Tool - cannot set a new provider

    05-10-2008, 2:09 AM
    • Loading...
    • MrGear
    • Joined on 05-09-2008, 7:49 PM
    • Posts 2

     

    Hi Rob,

    thx for answering. Have a look at http://msdn.microsoft.com/de-de/library/ms345152(en-us).aspx

    figure 3. Thats what Iam missing.....

     

     

     

  • Re: Website Administration Tool - cannot set a new provider

    05-13-2008, 1:36 AM
    Answer

    Hi,

    This article is based on the May 2004 Alpha release of Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition Technical Preview. All information contained herein is subject to change.

    I guess this article is not updated. By default, the Web Site Administration Tool uses the AspNetSqlProvider provider for all application features now.

    You can add another provider to save the data. To do this, you need to configure the database using aspnet_regsql.exe, and then add the <membership> and <roleManager> sections to your web.config file to instead default provider. For more information about Web Site Administration Tool Provider Tab, see http://msdn.microsoft.com/en-us/library/83y98ckk(VS.80).aspx

    For more information about creating new database for default ASPNETDB.mdf, see http://blog.krisvandermast.com/CreateMembershipTablesInAnotherDatabaseThanTheStandardAspnetdbmdf.aspx
     

    I hope this helps.

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Page 1 of 1 (4 items)