resetting my database to remove membership/roles

Discussion in 'Databases' started by jekain314, Jan 30, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am resetting my website to remove membership/roles because this didnt seem to work on my first attempt. I have a trivial test website with a single page (default.aspx), and single database (database.mdf) with a single table. My website page simply displays a gridviewof the contents ofmy single table. Previously, I had set up my operational database but when i added membership/roles things never worked. I placed my trivial website in a folder /test/ below the DASP root.

    With this trivial website,what I am seeing is that the DASP website still has remnants of the original site with membership/roles in place. I have used aspnet_regsql, pointing at the DASP website, and removed the membership/roles functionality. This seemed to have worked based the response from aspnet_regsql. However, I get thefollowing Server Error with www.gvops.com/test/default.aspx

    I dont have any of the rolemamanger tags in my web.config so i assume they are residual from my original websetup.

    --jek


    Server Error in '/test' Application.


    Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.

    Source Error:





    Code:
    Line 147:    <roleManager>
    Line 148:      <providers>
    Line 149:        <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
    Line 150:        <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
    Line 151:      </providers>
    Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config Line: 149



    Version Information:Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 <!--
    [ConfigurationErrorsException]: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 149)
    at System.Web.Security.Roles.Initialize()
    at System.Web.Security.RoleManagerModule.OnLeave(Object source, EventArgs eventArgs)
    at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    --><!--
    This error page might contain sensitive information because ASP.NET is configured to show verbose error messages using <customErrors mode="Off"/>. Consider using <customErrors mode="On"/> or <customErrors mode="RemoteOnly"/> in production environments.-->
     
  2. The connection to a root with nothing to return is obvious but...
    If you're resetting everything I'd suggest starting with a fresh web.config too.

    Are you using one of the VS 2008 products?
     
  3. yep -- i started anew with New WebProject in Visual Studio 2008 that regenerated a new web.config.


    The web.config that I see locally, for this trivial website,has norolemanager as suggested in the error message from DASP.
    using the free download VS2008 product ---
    ---Jim
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page