title: DNN 7 installation - SQL Server Express invalid database account
body: <p>I was trying to install DNN 7 via web platform installer (5.0) but an error came up on install - the specified password for the user account <code>sa</code> is not valid, or failed to connect to the database server.</p>
  
  <p>I have SQL Server 2014 but not Express. I don't have a database set up called <code>sa</code> or a database server called <code>.\SQLExpress</code>.</p>
  
  <p>what would I need to do to satisfy DNN's request for password for <code>sa</code> account ?</p>
  
  <p>edit..webconfig</p>
  
  <pre><code>&lt;configuration&gt;
    &lt;!-- register local configuration handlers --&gt;
    &lt;configSections&gt;
      &lt;sectionGroup name="dotnetnuke"&gt;
        &lt;!-- the requirePermission attribute will cause a syntax warning - please ignore - it is required for Medium Trust support--&gt;
        &lt;section name="data" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="logging" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="scheduling" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="htmlEditor" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="navigationControl" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="searchIndex" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="searchDataStore" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="friendlyUrl" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="caching" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="authentication" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="members" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="roles" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="profiles" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="permissions" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/&gt;
        &lt;section name="moduleCaching" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" /&gt;
        &lt;section name="outputCaching" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" /&gt;
        &lt;section name="folder" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" /&gt;
        &lt;section name="clientcapability" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" /&gt;
        &lt;section name="sitemap" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" /&gt;
      &lt;/sectionGroup&gt;
      &lt;sectionGroup name="system.web.webPages.razor" type="System.Web.WebPages.Razor.Configuration.RazorWebSectionGroup, System.Web.WebPages.Razor"&gt;
        &lt;section name="pages" type="System.Web.WebPages.Razor.Configuration.RazorPagesSection, System.Web.WebPages.Razor" requirePermission="false" /&gt;
      &lt;/sectionGroup&gt;
    &lt;/configSections&gt;
  
    &lt;connectionStrings&gt;
      &lt;!-- Connection String for SQL Server 2008/2012 Express --&gt;
      &lt;add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" providerName="System.Data.SqlClient"/&gt;
      &lt;!-- Connection String for SQL Server 2008/2012
      &lt;add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" /&gt; 
      --&gt;
    &lt;/connectionStrings&gt;
  
    &lt;appSettings&gt;
      &lt;!-- Connection String for SQL Server 2008/2012 Express - kept for backwards compatability - legacy modules   --&gt;
      &lt;add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/&gt;
      &lt;!-- Connection String for SQL Server 2008/2012 - kept for backwards compatability - legacy modules
      &lt;add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/&gt;
      --&gt;
      &lt;add key="InstallTemplate" value="DotNetNuke.install.config"/&gt;
      &lt;add key="AutoUpgrade" value="true"/&gt;
      &lt;add key="UseInstallWizard" value="true"/&gt;
      &lt;add key="InstallMemberRole" value="true"/&gt;
      &lt;add key="ShowMissingKeys" value="false"/&gt;
      &lt;add key="EnableCachePersistence" value="false"/&gt;
      &lt;add key="HostHeader" value=""/&gt;
      &lt;!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" --&gt;
      &lt;add key="RemoveAngleBrackets" value="false"/&gt;
      &lt;!--optionally strip angle brackets on public login and registration screens--&gt;
      &lt;add key="PersistentCookieTimeout" value="0"/&gt;
      &lt;!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure--&gt;
      &lt;!-- set UsePortNumber to true to preserve the port number if you're using a port number other than 80 (the standard)
          &lt;add key="UsePortNumber" value="true" /&gt; --&gt;
      &lt;!-- Services Framework Tracing is primarily useful for developing and debugging --&gt;
      &lt;add key="EnableServicesFrameworkTracing" value="false" /&gt;
        &lt;add key="UpdateServiceUrl" value="http://update.dotnetnuke.com" /&gt;
      &lt;add key="Telerik.Web.UI.ScriptFolders" value="~/Portals;" /&gt;
      &lt;add key="Telerik.Web.SkinsAssembly" value="Telerik.Web.UI.Skins, Version=2013.2.717.40, Culture=neutral, PublicKeyToken=121fae78165ba3d4" /&gt;
      &lt;add key="PreserveLoginUrl" value="true" /&gt;
      &lt;add key="loginUrl" value="~/Login.aspx" /&gt;
    &lt;/appSettings&gt;
  
    &lt;system.web.webPages.razor&gt;
      &lt;pages pageBaseType="DotNetNuke.Web.Razor.DotNetNukeWebPage"&gt;
        &lt;namespaces&gt;
          &lt;add namespace="WebMatrix.Data" /&gt;
          &lt;add namespace="Microsoft.Web.Helpers" /&gt;
        &lt;/namespaces&gt;
      &lt;/pages&gt;
    &lt;/system.web.webPages.razor&gt;
  
    &lt;!-- The system.webServer section is required for IIS7 compatability It is ignored by IIS6--&gt;
    &lt;system.webServer&gt;
      &lt;staticContent&gt;
        &lt;clientCache cacheControlCustom="public" cacheControlMode="UseMaxAge" cacheControlMaxAge="365.00:00:00" /&gt;
      &lt;/staticContent&gt;
      &lt;modules&gt;
        &lt;add name="RequestFilter" type="DotNetNuke.HttpModules.RequestFilter.RequestFilterModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="UrlRewrite" type="DotNetNuke.HttpModules.UrlRewriteModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="MobileRedirect" type="DotNetNuke.HttpModules.MobileRedirectModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="Exception" type="DotNetNuke.HttpModules.Exceptions.ExceptionModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="UsersOnline" type="DotNetNuke.HttpModules.UsersOnline.UsersOnlineModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="DNNMembership" type="DotNetNuke.HttpModules.Membership.MembershipModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="Personalization" type="DotNetNuke.HttpModules.Personalization.PersonalizationModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="Analytics" type="DotNetNuke.HttpModules.Analytics.AnalyticsModule, DotNetNuke.HttpModules" preCondition="managedHandler"/&gt;
        &lt;add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule, Telerik.Web.UI" preCondition="managedHandler"/&gt;
        &lt;add name="Services" type="DotNetNuke.HttpModules.Services.ServicesModule, DotNetNuke.HttpModules" /&gt;
        &lt;remove name="UrlRoutingModule-4.0" /&gt;
        &lt;add name="UrlRoutingModule-4.0" type="System.Web.Routing.UrlRoutingModule" preCondition="" /&gt;
      &lt;/modules&gt;
      &lt;handlers&gt;
        &lt;remove name="WebServiceHandlerFactory-Integrated"/&gt;
        &lt;add name="LogoffHandler*" path="Logoff.aspx" verb="*" type="DotNetNuke.Services.Authentication.LogOffHandler, DotNetNuke" preCondition="integratedMode"/&gt;
        &lt;add name="RSSHandler" path="RSS.aspx" verb="*" type="DotNetNuke.Services.Syndication.RssHandler, DotNetNuke" preCondition="integratedMode"/&gt;
        &lt;add name="LinkClickHandler" path="LinkClick.aspx" verb="*" type="DotNetNuke.Services.FileSystem.FileServerHandler, DotNetNuke" preCondition="integratedMode"/&gt;
        &lt;add name="CaptchaHandler" path="*.captcha.aspx" verb="*" type="DotNetNuke.UI.WebControls.CaptchaHandler, DotNetNuke" preCondition="integratedMode"/&gt;
        &lt;add name="Telerik.Web.UI.WebResource" verb="*" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource, Telerik.Web.UI" preCondition="integratedMode" /&gt;
        &lt;add name="Telerik.Web.UI.ChartHttpHandler" path="ChartImage.axd" verb="*" type="Telerik.Web.UI.ChartHttpHandler, Telerik.Web.UI, Culture=neutral, PublicKeyToken=121fae78165ba3d4" preCondition="integratedMode" /&gt;
        &lt;add name="UserProfilePageHandler" path="User.aspx" verb="*" type="DotNetNuke.Services.UserProfile.UserProfilePageHandler, DotNetNuke" preCondition="integratedMode"/&gt;
        &lt;add name="RadProgressHandler" verb="*" path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI" preCondition="integratedMode"/&gt;
        &lt;add name="UserProfilePicHandler" path="ProfilePic.ashx" verb="*" type="DotNetNuke.Services.UserProfile.UserProfilePicHandler, DotNetNuke" preCondition="integratedMode" /&gt;
        &lt;remove name="ExtensionlessUrl-Integrated-4.0" /&gt;
        &lt;add name="ExtensionlessUrl-Integrated-4.0" path="*." verb="GET,HEAD,POST,DEBUG,PUT,DELETE" type="System.Web.Handlers.TransferRequestHandler" preCondition="integratedMode,runtimeVersionv4.0" /&gt;
        &lt;add name="SitemapHandler" path="Sitemap.aspx" verb="*" type="DotNetNuke.Services.Sitemap.SitemapHandler, DotNetNuke" preCondition="integratedMode" /&gt;
      &lt;/handlers&gt;
      &lt;validation validateIntegratedModeConfiguration="false"/&gt;
      &lt;httpProtocol&gt;
        &lt;customHeaders&gt;
          &lt;remove name="X-Powered-By" /&gt;
        &lt;/customHeaders&gt;
      &lt;/httpProtocol&gt;
    &lt;/system.webServer&gt;
  
    &lt;system.web&gt;
      &lt;machineKey validationKey="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902" decryptionKey="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC" decryption="3DES" validation="SHA1"/&gt;
      &lt;!-- set code access security trust level - this is generally set in the machine.config --&gt;
      &lt;trust level="Full" originUrl=".*" /&gt;
      &lt;!-- set debugmode to false for running application --&gt;
      &lt;compilation debug="true" strict="false" targetFramework="4.0"&gt;
        &lt;buildProviders&gt;
          &lt;remove extension=".resx" /&gt;
          &lt;remove extension=".resources" /&gt;
        &lt;/buildProviders&gt;
        &lt;assemblies&gt;
          &lt;add assembly="Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /&gt;
          &lt;add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/&gt;
        &lt;/assemblies&gt;
        &lt;expressionBuilders &gt;
          &lt;add expressionPrefix="dnnLoc" type="DotNetNuke.Services.Localization.LocalizationExpressionBuilder, DotNetNuke"/&gt;
        &lt;/expressionBuilders&gt;
      &lt;/compilation&gt;
      &lt;!-- permits errors to be displayed for remote clients --&gt;
      &lt;customErrors mode="RemoteOnly" /&gt;
      &lt;!-- Forms or Windows authentication --&gt;
      &lt;authentication mode="Forms"&gt;
        &lt;forms name=".DOTNETNUKE" protection="All" timeout="60" cookieless="UseCookies"/&gt;
      &lt;/authentication&gt;
      &lt;!--
      &lt;identity impersonate="true"/&gt;
      &lt;authentication mode="Windows"&gt;
      &lt;/authentication&gt;
      --&gt;
      &lt;!-- allow large file uploads --&gt;
      &lt;httpRuntime shutdownTimeout="120" executionTimeout="1200" useFullyQualifiedRedirectUrl="true" maxRequestLength="29296" requestLengthDiskThreshold="81920" requestPathInvalidCharacters="&amp;lt;,&amp;gt;,*,%,:,\,?" enableVersionHeader="false"   requestValidationMode="2.0"/&gt;
      &lt;httpCookies httpOnlyCookies="true" requireSSL="false" domain=""/&gt;
      &lt;!--  GLOBALIZATION
      This section sets the globalization settings of the application. 
      Utf-8 is not supported on Netscape 4.x 
      If you need netscape compatiblity leave iso-8859-1.
      UTF-8 is recommended for complex languages
      --&gt;
      &lt;globalization culture="en-US" uiCulture="en" requestEncoding="UTF-8" responseEncoding="UTF-8" fileEncoding="UTF-8"/&gt;
      &lt;!--&lt;globalization culture="en-US" uiCulture="en"  fileEncoding="iso-8859-1" requestEncoding="iso-8859-1" responseEncoding="iso-8859-1"/&gt;--&gt;
      &lt;!-- page level options --&gt;
      &lt;pages validateRequest="false" enableViewStateMac="true" enableEventValidation="true" viewStateEncryptionMode="Always"&gt;
        &lt;namespaces&gt;
          &lt;add namespace="System.ComponentModel"/&gt;
          &lt;add namespace="System.Data"/&gt;
          &lt;add namespace="System.Data.SqlClient"/&gt;
          &lt;add namespace="System.Drawing"/&gt;
          &lt;add namespace="Microsoft.VisualBasic"/&gt;
          &lt;add namespace="System.Globalization"/&gt;
          &lt;add namespace="DotNetNuke.Services.Localization"/&gt;
          &lt;add namespace="DotNetNuke.Entities.Users"/&gt;
          &lt;add namespace="DotNetNuke"/&gt;
          &lt;add namespace="DotNetNuke.Common"/&gt;
          &lt;add namespace="DotNetNuke.Data"/&gt;
          &lt;add namespace="DotNetNuke.Framework"/&gt;
          &lt;add namespace="DotNetNuke.Modules"/&gt;
          &lt;add namespace="DotNetNuke.Security"/&gt;
          &lt;add namespace="DotNetNuke.Services"/&gt;
          &lt;add namespace="DotNetNuke.UI"/&gt;
          &lt;add namespace="DotNetNuke.Entities.Portals"/&gt;
          &lt;add namespace="DotNetNuke.Common.Utilities"/&gt;
          &lt;add namespace="DotNetNuke.Services.Exceptions"/&gt;
          &lt;add namespace="DotNetNuke.Entities.Tabs"/&gt;
        &lt;/namespaces&gt;
        &lt;controls&gt;
        &lt;/controls&gt;
      &lt;/pages&gt;
      &lt;!-- ASP.NET 2 Membership/Profile/Role and AnonymousAuthentication Providers --&gt;
      &lt;!-- anonymousIdentification configuration:
            enabled="[true|false]"                              Feature is enabled?
            cookieName=".ASPXANONYMOUS"                         Cookie Name
            cookieTimeout="100000"                              Cookie Timeout in minutes
            cookiePath="/"                                      Cookie Path
            cookieRequireSSL="[true|false]"                     Set Secure bit in Cookie
            cookieSlidingExpiration="[true|false]"              Reissue expiring cookies?
            cookieProtection="[None|Validation|Encryption|All]" How to protect cookies from being read/tampered
            domain="[domain]"                                   Enables output of the "domain" cookie attribute set to the specified value
          --&gt;
      &lt;anonymousIdentification enabled="true" cookieName=".ASPXANONYMOUS" cookieTimeout="100000" cookiePath="/" cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="None" domain=""/&gt;
      &lt;membership defaultProvider="AspNetSqlMembershipProvider" userIsOnlineTimeWindow="15"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;!-- Configuration for AspNetSqlMembershipProvider:
                  connectionStringName="string"               Name corresponding to the entry in &lt;connectionStrings&gt; section where the connection string for the provider is specified
                  maxInvalidPasswordAttempts="int"            The number of failed password attempts, or failed password answer attempts that are allowed before locking out a user?s account
                  passwordAttemptWindow="int"                 The time window, in minutes, during which failed password attempts and failed password answer attempts are tracked
                  enablePasswordRetrieval="[true|false]"      Should the provider support password retrievals
                  enablePasswordReset="[true|false]"          Should the provider support password resets
                  requiresQuestionAndAnswer="[true|false]"    Should the provider require Q &amp; A
                  minRequiredPasswordLength="int"             The minimum password length
                  minRequiredNonalphanumericCharacters="int"  The minimum number of non-alphanumeric characters
                  applicationName="string"                    Optional string to identity the application: defaults to Application Metabase path
                  requiresUniqueEmail="[true|false]"          Should the provider require a unique email to be specified
                  passwordFormat="[Clear|Hashed|Encrypted]"   Storage format for the password: Hashed (SHA1), Clear or Encrypted (Triple-DES)
                  description="string"                        Description of what the provider does
                  --&gt;
          &lt;add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="SiteSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" requiresUniqueEmail="false" passwordFormat="Hashed" applicationName="DotNetNuke" description="Stores and retrieves membership data from the local Microsoft SQL Server database"/&gt;
        &lt;/providers&gt;
      &lt;/membership&gt;
    &lt;/system.web&gt;
  
    &lt;runtime&gt;
      &lt;assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"&gt;
        &lt;probing privatePath="bin;bin\HttpModules;bin\Providers;bin\Modules;bin\Support;"/&gt;
        &lt;dependentAssembly&gt;
          &lt;assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/&gt;
          &lt;bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="4.0.0.0"/&gt;
        &lt;/dependentAssembly&gt;
        &lt;dependentAssembly&gt;
          &lt;assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/&gt;
          &lt;bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="4.0.0.0"/&gt;
        &lt;/dependentAssembly&gt;
        &lt;dependentAssembly&gt;
          &lt;assemblyIdentity name="Telerik.Web.UI" publicKeyToken="121fae78165ba3d4" /&gt;
          &lt;bindingRedirect oldVersion="2008.0.0.0-2020.0.0.0" newVersion="2013.2.717.40" /&gt;
        &lt;/dependentAssembly&gt;
        &lt;dependentAssembly&gt;
          &lt;assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35" /&gt;
          &lt;bindingRedirect oldVersion="1.0.0.0-2.0.0.0" newVersion="2.0.0.0" /&gt;
        &lt;/dependentAssembly&gt;
      &lt;/assemblyBinding&gt;
    &lt;/runtime&gt;
  
    &lt;dotnetnuke&gt;
      &lt;htmlEditor defaultProvider="DotNetNuke.RadEditorProvider"&gt;
          &lt;providers&gt;
              &lt;clear/&gt;
              &lt;add name="DotNetNuke.RadEditorProvider" type="DotNetNuke.Providers.RadEditorProvider.EditorProvider, DotNetNuke.RadEditorProvider" providerPath="~/DesktopModules/Admin/RadEditorProvider" /&gt;
          &lt;/providers&gt;
      &lt;/htmlEditor&gt;
      &lt;navigationControl defaultProvider="DNNMenuNavigationProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="DNNDropDownNavigationProvider" type="DotNetNuke.NavigationControl.DNNDropDownNavigationProvider, DotNetNuke.DNNDropDownNavigationProvider" providerPath="~\Providers\NavigationProviders\DNNDropDownNavigationProvider\"/&gt;
          &lt;add name="ASP2MenuNavigationProvider" type="DotNetNuke.NavigationControl.ASP2MenuNavigationProvider, DotNetNuke.ASP2MenuNavigationProvider" providerPath="~\Providers\NavigationProviders\ASP2MenuNavigationProvider\"/&gt;
          &lt;add name="DNNMenuNavigationProvider" type="DotNetNuke.NavigationControl.DNNMenuNavigationProvider, DotNetNuke.DNNMenuNavigationProvider" providerPath="~\Providers\NavigationProviders\DNNMenuNavigationProvider\"/&gt;
          &lt;add name="DNNTreeNavigationProvider" type="DotNetNuke.NavigationControl.DNNTreeNavigationProvider, DotNetNuke.DNNTreeNavigationProvider" providerPath="~\Providers\NavigationProviders\DNNTreeNavigationProvider\"/&gt;
          &lt;add name="SolpartMenuNavigationProvider" type="DotNetNuke.NavigationControl.SolpartMenuNavigationProvider, DotNetNuke.SolpartMenuNavigationProvider" providerPath="~\Providers\NavigationProviders\SolpartMenuNavigationProvider\"/&gt;
        &lt;/providers&gt;
      &lt;/navigationControl&gt;
      &lt;searchIndex defaultProvider="ModuleIndexProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="ModuleIndexProvider" type="DotNetNuke.Services.Search.ModuleIndexer, DotNetNuke" providerPath="~\Providers\SearchProviders\ModuleIndexer\"/&gt;
        &lt;/providers&gt;
      &lt;/searchIndex&gt;
      &lt;searchDataStore defaultProvider="SearchDataStoreProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="SearchDataStoreProvider" type="DotNetNuke.Services.Search.SearchDataStore, DotNetNuke" providerPath="~\Providers\SearchProviders\SearchDataStore\"/&gt;
        &lt;/providers&gt;
      &lt;/searchDataStore&gt;
      &lt;data defaultProvider="SqlDataProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="dnn_" databaseOwner="dbo"/&gt;
        &lt;/providers&gt;
      &lt;/data&gt;
      &lt;logging defaultProvider="DBLoggingProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="DBLoggingProvider" type="DotNetNuke.Services.Log.EventLog.DBLoggingProvider, DotNetNuke" providerPath="~\Providers\LoggingProviders\DBLoggingProvider\"/&gt;
        &lt;/providers&gt;
      &lt;/logging&gt;
      &lt;scheduling defaultProvider="DNNScheduler"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="DNNScheduler" type="DotNetNuke.Services.Scheduling.DNNScheduler, DotNetNuke" providerPath="~\Providers\SchedulingProviders\DNNScheduler\" debug="false" maxThreads="1" /&gt;
        &lt;/providers&gt;
      &lt;/scheduling&gt;
      &lt;friendlyUrl defaultProvider="DNNFriendlyUrl"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="DNNFriendlyUrl" type="DotNetNuke.Services.Url.FriendlyUrl.DNNFriendlyUrlProvider, DotNetNuke.HttpModules" includePageName="true" regexMatch="[^a-zA-Z0-9 _-]" urlFormat="advanced"/&gt;
        &lt;/providers&gt;
      &lt;/friendlyUrl&gt;
      &lt;caching defaultProvider="FileBasedCachingProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="FileBasedCachingProvider" type="DotNetNuke.Services.Cache.FBCachingProvider, DotNetNuke" providerPath="~\Providers\CachingProviders\FileBasedCachingProvider\"/&gt;
        &lt;/providers&gt;
      &lt;/caching&gt;
      &lt;authentication defaultProvider="ADSIAuthenticationProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="ADSIAuthenticationProvider" type="DotNetNuke.Authentication.ActiveDirectory.ADSI.ADSIProvider, DotNetNuke.Authentication.ActiveDirectory" providerPath="~\Providers\AuthenticationProviders\ADSIProvider\"/&gt;
        &lt;/providers&gt;
      &lt;/authentication&gt;
      &lt;members defaultProvider="AspNetMembershipProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="AspNetMembershipProvider" type="DotNetNuke.Security.Membership.AspNetMembershipProvider, DotNetNuke" providerPath="~\Providers\MembershipProviders\AspNetMembershipProvider\"/&gt;
        &lt;/providers&gt;
      &lt;/members&gt;
      &lt;roles defaultProvider="DNNRoleProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="DNNRoleProvider" type="DotNetNuke.Security.Roles.DNNRoleProvider, DotNetNuke" providerPath="~\Providers\MembershipProviders\DNNMembershipProvider\"/&gt;
        &lt;/providers&gt;
      &lt;/roles&gt;
      &lt;profiles defaultProvider="DNNProfileProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="DNNProfileProvider" type="DotNetNuke.Security.Profile.DNNProfileProvider, DotNetNuke" providerPath="~\Providers\MembershipProviders\DNNProfileProvider\"/&gt;
        &lt;/providers&gt;
      &lt;/profiles&gt;
      &lt;permissions defaultProvider="CorePermissionProvider"&gt;
        &lt;providers&gt;
          &lt;clear/&gt;
          &lt;add name="CorePermissionProvider" type="DotNetNuke.Security.Permissions.CorePermissionProvider, DotNetNuke" providerPath="~\Providers\PermissionProviders\CorePermissionProvider\" /&gt;
        &lt;/providers&gt;
      &lt;/permissions&gt;
      &lt;moduleCaching defaultProvider="FileModuleCachingProvider"&gt;
        &lt;providers&gt;
          &lt;clear /&gt;
          &lt;add name="FileModuleCachingProvider" type="DotNetNuke.Services.ModuleCache.FileProvider, DotNetNuke" providerPath="~\Providers\ModuleCachingProviders\FileModuleCachingProvider\" /&gt;
          &lt;add name="MemoryModuleCachingProvider" type="DotNetNuke.Services.ModuleCache.MemoryProvider, DotNetNuke" providerPath="~\Providers\ModuleCachingProviders\MemoryModuleCachingProvider\" /&gt;
        &lt;/providers&gt;
      &lt;/moduleCaching&gt;
      &lt;outputCaching defaultProvider="FileOutputCachingProvider"&gt;
        &lt;providers&gt;
          &lt;clear /&gt;
        &lt;/providers&gt;
      &lt;/outputCaching&gt;
      &lt;folder defaultProvider="StandardFolderProvider"&gt;
        &lt;providers&gt;
          &lt;clear /&gt;
          &lt;add name="StandardFolderProvider" type="DotNetNuke.Services.FileSystem.StandardFolderProvider, DotNetNuke" /&gt;
          &lt;add name="SecureFolderProvider" type="DotNetNuke.Services.FileSystem.SecureFolderProvider, DotNetNuke" /&gt;
          &lt;add name="DatabaseFolderProvider" type="DotNetNuke.Services.FileSystem.DatabaseFolderProvider, DotNetNuke" /&gt;
        &lt;/providers&gt;
      &lt;/folder&gt;
      &lt;clientcapability defaultProvider="FiftyOneClientCapabilityProvider"&gt;
        &lt;providers&gt;
          &lt;clear /&gt;
          &lt;add name="FiftyOneClientCapabilityProvider" type="DotNetNuke.Providers.FiftyOneClientCapabilityProvider.FiftyOneClientCapabilityProvider, DotNetNuke.Providers.FiftyOneClientCapabilityProvider" providerPath="~\Providers\ClientCapabilityProviders\FiftyOneClientCapabilityProvider\" /&gt;
        &lt;/providers&gt;
      &lt;/clientcapability&gt;
      &lt;sitemap defaultProvider="coreSitemapProvider"&gt;
        &lt;providers&gt;
          &lt;clear /&gt;
          &lt;add name="coreSitemapProvider" type="DotNetNuke.Services.Sitemap.CoreSitemapProvider, DotNetNuke" providerPath="~\Providers\MembershipProviders\Sitemap\CoreSitemapProvider\" /&gt;
        &lt;/providers&gt;
      &lt;/sitemap&gt;
    &lt;/dotnetnuke&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>**edit - code added to web.config on DNN but still asking me for SQL Express - sa account and .SQL\Express account.  </p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="SiteSqlServer" 
           connectionString="Data Source=ANDREWSSD\MSSQLSERVER_EXPR;Initial Catalog=DotNetNuke;User ID=aindriu;Password=;"       providerName="System.Data.SqlClient" /&gt;
  &lt;/connectionStrings&gt;
  
    &lt;appSettings&gt;
  
  
  
      &lt;add key="SiteSqlServer" value="Data Source=ANDREWSSD\MSSQLSERVER_EXPR;Initial Catalog=DotNetNuke;User ID=aindriu;Password=;" /&gt;
  </code></pre>