title: Unable to connect to SQL Server database in asp.net Web Site Administration Tool
body: <p>When I get on the Security tab on the Web Site Administration Tool, I get this Error:</p>
  
  <p><strong><em>There is a problem with your selected data store. This can be caused by an invalid server name   or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.</em></strong></p>
  
  <p><strong><em>The following message may help in diagnosing the problem: Unable to connect to SQL Server database.</em></strong></p>
  
  <p>Here is the connectionStrings part in web.config file:</p>
  
  <pre><code>&lt;connectionStrings&gt;
    &lt;add name="DefaultConnection" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Verkoop.mdf;Integrated Security=True" providerName="System.Data.SqlClient" /&gt;
    &lt;add name="BestellingDBContext" providerName="System.Data.SqlClient" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\Verkoop.mdf;Integrated Security=True" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>And here is the membership part:</p>
  
  <pre><code>&lt;membership&gt;
    &lt;providers&gt;
      &lt;add connectionStringName="DefaultConnection" enablePasswordRetrieval="false"
        enablePasswordReset="true" requiresQuestionAndAnswer="false"
        requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6"
        minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"
        applicationName="/" name="DefaultMembershipProvider" type="System.Web.Providers.DefaultMembershipProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /&gt;
    &lt;/providers&gt;
  &lt;/membership&gt;
  </code></pre>
  
  <p>I've been searching the internet for solution for hours now, but can't find anything.
  Can somebody please help?
  Thanks!</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>roleManager tag:</p>
  
  <pre><code>&lt;roleManager&gt;
    &lt;providers&gt;
      &lt;add connectionStringName="DefaultConnection" applicationName="/"
        name="DefaultRoleProvider" type="System.Web.Providers.DefaultRoleProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /&gt;
    &lt;/providers&gt;
  &lt;/roleManager&gt;
  </code></pre>