What am I missing here?

Per the DotNetNuke 4.X Installation Guide.pdf (pdf page #’s 33-43)…

• Environment Status:

            MachineName                         = MRCXP

Op Sys                                    = XP SP2

SQL 2005 Express Instance    = MRCXP\SQLEXPRESS

• I unzipped the Source.Zip in c:\inetpub\wwwroot\DotNetNuke_2\...
• Set the proper permissions for the MRCXP\ASPNET account for the DotNetNuke_2 folder…
• Created a Database DotNetNuke/dnnUser/dnnUser1
• I copied release.config to web.config…
• Added the following lines to the web.config as directed…
• Then I hit Ctrl-F5...
• The build appeared successful and I saw the redirect to the Install URL...
• At this point I received either:

          <Error Message A>

            Error Installing DotNetNuke

         ERROR: Could not connect to database specified in connectionString for                    SqlDataProvider

         OR...

         <Error Message B>

      DotNetNuke Upgrade Error

            The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version       

            ( [DATABASEVERSION] ) 

            ERROR: Could not connect to database.
      
            Login failed for user 'MRCXP\ASPNET'.

         </Error Message B>

• I made 3 attempts at this with changes in the web.config as follows below...
• Please review the following and see if you spot what I'm doing incorrectly...
• Thank you for your time, assistance and patience in revieing this...

<1st Run Attempt>

Set the "Server" settings in web.config using default "Server = (local)" settings: 

<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="DotNetNuke"       connectionString="Server=(local);Database=DotNetNuke;uid=dnnUser;pwd=dnnUser1;"

providerName="System.Data.SqlClient" />        

<!-- Connection String for SQL Server 2000/2005

    <add

      name="SiteSqlServer"

      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"

      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;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>

<add key="DotNetNuke" value="Server=(local);Database=DotNetNuke;uid=dnnUser;pwd=dnnUser1;" />

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules

<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>

-->

</appSettings>

******

I see the call to the Install URL and then...

Error Installing DotNetNuke

Current Assembly Version: 04.03.05

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

</1st Run Attempt>

<2nd Run Attempt>

So I reset the "Server" values to Server =  MRCXP in web.config: 

 <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="DotNetNuke" connectionString="Server=MRCXP;Database=DotNetNuke;uid=dnnUser;pwd=dnnUser1;"

providerName="System.Data.SqlClient" />        

<!-- Connection String for SQL Server 2000/2005

    <add

      name="SiteSqlServer"

      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"

      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;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>

<add key="DotNetNuke" value="Server=MRCXP;Database=DotNetNuke;uid=dnnUser;pwd=dnnUser1;" />

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules

    <add key="SiteSqlServer"      

      value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>

-->

</appSettings>

******

I see the call to the Install URL and then...

DotNetNuke Upgrade Error

The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )

ERROR: Could not connect to database.

Login failed for user 'MRCXP\ASPNET'.

</2nd Run Attempt> 

<3rd Run Attempt>

With Server = MRCXP\SQLEXPRESS

 <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="DotNetNuke" connectionString="Server=MRCXP\SQLEXPRESS;Database=DotNetNuke;uid=dnnUser;pwd=dnnUser1;"

providerName="System.Data.SqlClient" />        

<!-- Connection String for SQL Server 2000/2005

    <add

      name="SiteSqlServer"

      connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;"

      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;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>

<add key="DotNetNuke" value="Server=MRCXP\SQLEXPRESS;Database=DotNetNuke;uid=dnnUser;pwd=dnnUser1;" />

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules

<add key="SiteSqlServer"

  value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>

-->

</appSettings>

****** 

Error Installing DotNetNuke

Current Assembly Version: 04.03.05

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

</3rd Run Attempt> 

Hey thank you for your response.  I'm trying to understand this interface and I appreciate your help.

When I refer to "Created a Database DotNetNuke/dnnUser/dnnUser1"

That refers to the database creation tasks descibed in the Installation Guide:

In SQL Server 2005 Express:

* I created a Database: DotNetNuke

* I created a new login: dnnUser p=dnnUser1

* I granted dnnUser the db_owner properties as described.

Thanks again for your response and assistance.

Sincerely

Chilly

Thank you for your time in reviewing this and your assistance.

When I say Created a Database DotNetNuke/dnnUser/dnnUser1. 

That is my shorthand reference to following the Installation Guide regarding the creation of the DotNetNuke Database in SQL Server 2005 Express.

In SQL Server 2005 Express...

* Created database:       DotNetNuke

* Created User:             dnnUser (pwd=dnnUser1)

Thanks again for your response and assistance.

Chilly