title: Unable to connect to SQL Server database asp.net web application
body: <p>I'm currently doing an asp.net mvc project when I'm on my way to create roles I can't connect to my database from the asp.net web application configuration for security </p>
  
  <p>Here is my config</p>
  
  <pre><code>&lt;configuration&gt;
      &lt;configSections&gt;
          &lt;section name="entityFramework" 
                   type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /&gt;
      &lt;/configSections&gt;
      &lt;connectionStrings&gt;
          &lt;add name="SqlRoleManagerConnection"
               connectionString="Data Source=localhost;Initial Catalog=DonBoscoDb;Integrated Security=SSPI;"&gt;
      &lt;/connectionStrings&gt;
      &lt;appSettings&gt;
          &lt;add key="webpages:Version" value="3.0.0.0" /&gt;
          &lt;add key="webpages:Enabled" value="false" /&gt;
          &lt;add key="ClientValidationEnabled" value="true" /&gt;
          &lt;add key="UnobtrusiveJavaScriptEnabled" value="true" /&gt; 
      &lt;/appSettings&gt;
      &lt;system.web&gt;
          &lt;authentication mode="Forms" /&gt;
          &lt;membership&gt;
              &lt;providers&gt;
                  &lt;clear /&gt;
                  &lt;add name="AspNetSqlMembershipProvider"  
                       type="System.Web.Security.SqlMembershipProvider" 
                       connectionStringName="ApplicationServices" 
                       enablePasswordRetrieval="false" enablePasswordReset="true" 
                       requiresQuestionAndAnswer="false" requiresUniqueEmail="false" 
                       maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" 
                       minRequiredNonalphanumericCharacters="0" 
                       passwordAttemptWindow="10" applicationName="SmartTimers" /&gt;
              &lt;/providers&gt;
          &lt;/membership&gt;
          &lt;profile&gt;
              &lt;providers&gt;
                  &lt;clear /&gt;
                  &lt;add name="AspNetSqlProfileProvider" 
                       type="System.Web.Profile.SqlProfileProvider"  
                       connectionStringName="ApplicationServices" 
                       applicationName="SmartTimers" /&gt;
              &lt;/providers&gt;
          &lt;/profile&gt;
          &lt;roleManager enabled="true" defaultProvider="SqlRoleManager" &gt;
              &lt;providers&gt;
                  &lt;clear/&gt;
                  &lt;add name="SqlRoleManager"
                       type="System.Web.Security.SqlRoleProvider"
                       connectionStringName="SqlRoleManagerConnection"
                       applicationName="DonBoscoProjectSite" /&gt;
              &lt;/providers&gt;
          &lt;/roleManager&gt;
          &lt;compilation debug="true" targetFramework="4.5.2" /&gt;
          &lt;httpRuntime targetFramework="4.5.2" /&gt;
      &lt;/system.web&gt;
      &lt;system.webServer&gt;
          &lt;modules&gt;
              &lt;remove name="FormsAuthentication" /&gt;
          &lt;/modules&gt;
      &lt;/system.webServer&gt;
      &lt;runtime&gt;
          &lt;assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="Microsoft.Owin.Security" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-3.0.1.0" newVersion="3.0.1.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="Microsoft.Owin.Security.OAuth" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-3.0.1.0" newVersion="3.0.1.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="Microsoft.Owin.Security.Cookies" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-3.0.1.0" newVersion="3.0.1.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="Microsoft.Owin" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-3.0.1.0" newVersion="3.0.1.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="Newtonsoft.Json" culture="neutral" publicKeyToken="30ad4fe6b2a6aeed" /&gt;
              &lt;bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="System.Web.Optimization" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="1.1.0.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-1.5.2.14234" newVersion="1.5.2.14234" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="System.Web.Helpers" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-5.2.3.0" newVersion="5.2.3.0" /&gt;
          &lt;/dependentAssembly&gt;
          &lt;dependentAssembly&gt;
              &lt;assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35" /&gt;
              &lt;bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" /&gt;
          &lt;/dependentAssembly&gt;
        &lt;/assemblyBinding&gt;
      &lt;/runtime&gt;
      &lt;entityFramework&gt;
          &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework"&gt;
              &lt;parameters&gt;
                  &lt;parameter value="mssqllocaldb" /&gt;
              &lt;/parameters&gt;
          &lt;/defaultConnectionFactory&gt;
          &lt;providers&gt;
              &lt;provider invariantName="System.Data.SqlClient" 
                        type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /&gt;
          &lt;/providers&gt;
      &lt;/entityFramework&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;/configuration&gt;
  </code></pre>
  
  <p>I also ran the <code>aspnet_regsql</code> but still the error persists.</p>
  
  <p>I am using VS 2015 and SQL Server 2014</p>