I am experimenting with DotNetNuke (DNN) to see if it is a viable solution for some upcoming projects. While installing the "Source" version of the application I received the following error message:
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database.
The stored procedure 'dbo.GetPortalAliasByPortalID' doesn't exist.
The above error occurred while the install scripts were attempting to create the database objects on my local installation of Microsoft SQL Server 2000. I had already created an empty database on SQL Server. The default web.config file uses SQL Server 2005 Express. I changed the connection string to:
<add name="SiteSqlServer" connectionString="server=(local);uid=sa;pwd=mypass;database=DNN441_Dev" providerName="System.Data.SqlClient" />
Solution
I did a quick search on Google and found this related DotNetNuke forum thread. It is 5 pages long, and pointed me to the eventual solution. I have had a similar problem in the past (though, I can't remember with what). I changed the server name in my connection string from "(local)" to my machine's name the database installation completed without further incident. My new connection string looked like this:
<add name="SiteSqlServer"
connectionString="server=MyMachineName;uid=sa;pwd=mypass;database=DNN441_Dev"
providerName="System.Data.SqlClient" />