title: Web admin tool provider managment
body: <p>I have a problem with the access rules in the web admin tool </p>
  
  <p>I set the rules for some pages to be accessed by the admin and deny access for the other users , but it deny access for all users including the admin ! </p>
  
  <p>Then , I check the provider in the web admin tool and I get this problem </p>
  
  <blockquote>
    <p>Could not establish a connection to the database. If you have not yet
    created the SQL Server database, exit the Web Site Administration
    tool, use the aspnet_regsql command-line utility to create and
    configure the database, and then return to this tool to set the
    provider.</p>
  </blockquote>
  
  <p>Here is the code for web.config file </p>
  
  <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt;
  &lt;!--
    For more information on how to configure your ASP.NET application, please visit
    http://go.microsoft.com/fwlink/?LinkId=169433
    --&gt;
  &lt;configuration&gt;
  
    &lt;connectionStrings&gt;
  
      &lt;add name="Golden_RoseConnectionString3" connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\user\Desktop\database\Golden_Rose.mdf;Integrated Security=True;Connect Timeout=30"
        providerName="System.Data.SqlClient" /&gt;
  
  
  
    &lt;/connectionStrings&gt;
  
    &lt;system.web&gt;
  
  
  
      &lt;roleManager enabled="true" /&gt;
      &lt;authentication mode="Forms"&gt;
        &lt;forms name=".ASPXFORMSAUTH" loginUrl="~/Guest/login.aspx" /&gt;
      &lt;/authentication&gt;
  
  
  
      &lt;siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true"&gt;
        &lt;providers&gt;
          &lt;add siteMapFile="~/Web.sitemap"  name="CustomerSiteMapProvider" type="System.Web.XmlSiteMapProvider" securityTrimmingEnabled="true"/&gt;
  
          &lt;add siteMapFile="~/Web1.sitemap"  name="AdminXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider" securityTrimmingEnabled="true" /&gt;
  
        &lt;/providers&gt;
      &lt;/siteMap&gt;
  
      &lt;compilation debug="true" targetFramework="4.5.2"/&gt;
      &lt;httpRuntime targetFramework="4.5.2"/&gt;
    &lt;/system.web&gt;
  
      &lt;system.codedom&gt;
      &lt;compilers&gt;
        &lt;compiler language="c#;cs;csharp" extension=".cs"
          type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
          warningLevel="4" compilerOptions="/langversion:6 /nowarn:1659;1699;1701"/&gt;
        &lt;compiler language="vb;vbs;visualbasic;vbscript" extension=".vb"
          type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
          warningLevel="4" compilerOptions="/langversion:14 /nowarn:41008 /define:_MYTYPE=\&amp;quot;Web\&amp;quot; /optionInfer+"/&gt;
      &lt;/compilers&gt;
  
    &lt;/system.codedom&gt;
    &lt;appSettings&gt;
      &lt;add key="ValidationSettings:UnobtrusiveValidationMode" value="None"/&gt;
    &lt;/appSettings&gt;
  
  &lt;/configuration&gt;
  </code></pre>
  
  <p>How can I fix this ?!!</p>