I have been trying with zero success to install DotNetNuke on a test Windows XP system running ASP.NET 2.0.50727 and SQL Server 2005. I have been trying to follow the several other threads in this forum but fail to get anywhere.
I just created a new test application for it following the steps in the installation guide and get the following when opening http://localhost/test2 in the browser:
DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
Login failed for user 'test2'.
I have followed the instructions as exactly as my simple mind can. The only step I cannot do is to apply the directory security for the ASPNET account as the Windows XP system is not part of a domain so the security tab is not really there. Since the system is just a test sandbox system I just added ASPNET to the local Administrators group to be sure the account has total system access.
There is nothing in the event logs and no log in \Portals\_default\Logs.
The database is called test2 and the test2 and ASPNET both have complete access to the database interactively. The ‘interesting’ part of web.config is below:
<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" /> -->
<!-- Connection String for SQL Server 2000/2005 -->
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=test2;uid=test2;pwd=test2;"
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;"/> -->
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Server=(local);Database=test2;uid=test2;pwd=test2;"/>
I would really appreciate pointers about what I may have done to annoy DNN such that it refuses to install.
Thanks!