I am attemptign to get DotNetNuke installed and running on my local machine.

Here is what ive got installed and running:

Windows Xp Pro
IE 7
SQLXPRESS 2005 and I use a seperate download of server management studio xpress
.net framework 2.0
IIS

I am attempting to install using this package:
DotNetNuke_4.3.6_Install

I have gone through pages and pages of posts that i searched for to fix this problem. im talking at least 15 different topics. I go in to one and change what they say and then I get a different error. Then I search for that error, go in to that topic change what they say and then I get a new error. etc etc round and round I go.

This is the current error I get:
-----------------------------------
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
--------------------------------

I dont need remote connections as I am running this local so I have surface area config set accordingly. however I HAVE tried allowing all remote connections and still no go. I have also tried setting the data source to local in the conenction strign which is also a no go.

This is my current connection string
<connectionStrings>
    <!-- Connection String for SQL Server 2005 Express -->
    <add
      name="SiteSqlServer"
      connectionString="Data Source=SQLEXPRESS;Initial Catalog=DotNetNuke;Integrated Security=True;"
      providerName="System.Data.SqlClient" />
 
    <!-- Connection String for SQL Server 2000/2005  
    <add
      name="SiteSqlServer"
      connectionString="Server=(local);Database=DotNetNuke;uid=nathaniel;pwd=nathaniel1234;"
      providerName="System.Data.SqlClient" /> -->
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
 
    <add key="SiteSqlServer" value="Data Source=SQLEXPRESS;Initial Catalog=DotNetNuke;Integrated Security=True;"/>
     <!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules        <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=Nathaniel;pwd=nathaniel1234;"/> -->

 The other error I will get if I am not getting the one i described and showed previously is a DNN install error unable to connect to database specified in sqldataprovider string

so here is my sqldataprovider string:
    <data
 defaultProvider="SqlDataProvider">
      <providers>
        <clear/>
        <add
          name="SqlDataProvider"
          type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider"
          connectionStringName="SiteSqlServer"
          upgradeConnectionString=""
          providerPath="~\Providers\DataProviders\SqlDataProvider\"
          objectQualifier=""
          databaseOwner="dbo"/>
      </providers>

I would VERY much appreciate some assistance.