I need some help with the web.config file. I have looked on the forums and saw that with the latest version of DNN that all I need to do is reconfigure the release.config file. I have tried that and I still can not get it to work. Below is the code I have after configuring it to my settings. Could someone take a look and tell me what they see is wrong?

==================================================

<configuration>
  <!-- register local configuration handlers -->
  <configSections>
    <sectionGroup name="dotnetnuke">
      <!-- the requirePermission attribute will cause a syntax warning - please ignore - it is required for Medium Trust support-->
      <section name="data" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="logging" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="scheduling" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="htmlEditor" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="navigationControl" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="searchIndex" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="searchDataStore" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="friendlyUrl" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="caching" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
      <section name="authentication" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke"/>
    </sectionGroup>
  </configSections>
  <connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
    <add
      name="SiteSqlServer"
      connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
      providerName="System.Data.SqlClient" />
  
    <add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=DotNetNukeUser;pwd=*password;"
      providerName="System.Data.SqlClient" />
   -->
  </connectionStrings>
  <appSettings>
   
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=DotNetNukeUser;pwd=*password;"/>
    -->
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <!--  Alternative Install Templates (included in package)
    <add key="InstallTemplate" value="Club.install.config" />
    <add key="InstallTemplate" value="Personal.install.config" />
    <add key="InstallTemplate" value="SmallBusiness.install.config" />
    -->
    <add key="AutoUpgrade" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" value="false" />
    <add key="EnableWebFarmSupport" value="false" />
    <add key="EnableCachePersistence" value="false"/>
  </appSettings>
  <system.codedom>
    <compilers>
      <compiler
        language="vb"
        type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"
        extension=".VB" />
    </compilers>
  </system.codedom>
  <system.web>
    <machineKey
      validationKey="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902"
      decryptionKey="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC"
      decryption="3DES"
      validation="SHA1"/>

It looks like your REM's <-- -->  are possibly in the wrong places, or not there in others.  To determine this, we will need to know the version of SQL Server that you are using.  eg. SQL 2000, SQL 2005, SQL Express 2005?

I think that I see your problem now.  I also use SQL Server 2000 and my config had to be altered some from the original by RIM out the SQL Express stuff and un-REM the SQL2000/2005 part.  Read this instruction guide that I made about a month ago, it is 4 pages long and if you follow it exactly, you should have no problem setting up DNN 4.x.

You can view my instructions by clicking HERE

Notice on the last page, I put an example of the connection string when using SQL Server 2000.

good luck