I was cleaning up some old MySQL settings in my machine.config file and may have deleted a SQL/DNN related line without realizing it...

While other sites on my IIS are starting fine, I have a DNN host site that is not. It is stating Default Role Provider could not be found.

In the DNN site's web.config, it has









In my connectionStrings section of web.config, I have




Ideally, I don't think anything should have been in machine.config that was related to DNN or SQL, but that's the only obvious change I made, recklessly, I know..... Where do I look in machine.config to fix this OR how do I fix the DNN site's web.config file so that all of it's settings are self contained?

I think you're reply is because my original post blanked out my two sections of my web.config file?  Here they are again, hopefully I do it right this time.  (and for the record, sql server is running and can connect/read/write with user credentials specified)..

Connection Strings

 <connectionStrings>

       <remove name="LocalSqlServer" />  

    <!-- Connection String for SQL Server 2008/2012 Express -->

    <add name="SiteSqlServer" connectionString="Data Source=IIS\SQLExpress;Initial Catalog=DNN74;User ID=***;Password=***" providerName="System.Data.SqlClient" />

        <add connectionString="Server=IIS\SQLExpress;Database=DNN74;User ID=***;Password=***" name="LocalSqlServer" providerName="System.Data.SqlClient" />

   

    <!-- Connection String for SQL Server 2008/2012

    <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" /> 

    -->

  </connectionStrings>

 

and the Providers

 <authentication defaultProvider="ADSIAuthenticationProvider">

      <providers>

        <clear />

        <add name="ADSIAuthenticationProvider" type="DotNetNuke.Authentication.ActiveDirectory.ADSI.ADSIProvider, DotNetNuke.Authentication.ActiveDirectory" providerPath="~\Providers\AuthenticationProviders\ADSIProvider\" />

      </providers>

    </authentication>

    <members defaultProvider="AspNetMembershipProvider">

      <providers>

        <clear />

        <add name="AspNetMembershipProvider" type="DotNetNuke.Security.Membership.AspNetMembershipProvider, DotNetNuke" providerPath="~\Providers\MembershipProviders\AspNetMembershipProvider\" />

      </providers>

    </members>

    <roles defaultProvider="DNNRoleProvider"> 

      <providers>

        <clear />

        <add name="DNNRoleProvider" type="DotNetNuke.Security.Roles.DNNRoleProvider, DotNetNuke" providerPath="~\Providers\MembershipProviders\DNNMembershipProvider\" />

      </providers>

    </roles> 

    <profiles defaultProvider="DNNProfileProvider">

      <providers>

        <clear />

        <add name="DNNProfileProvider" type="DotNetNuke.Security.Profile.DNNProfileProvider, DotNetNuke" providerPath="~\Providers\MembershipProviders\DNNProfileProvider\" />

      </providers>

    </profiles>

    <permissions defaultProvider="CorePermissionProvider">

      <providers>

        <clear />

        <add name="CorePermissionProvider" type="DotNetNuke.Security.Permissions.CorePermissionProvider, DotNetNuke" providerPath="~\Providers\PermissionProviders\CorePermissionProvider\" />

      </providers>

    </permissions>