Hello Everyone,
My current issue: DotNetNuke Upgrade Error
The Assembly Version ( [ASSEMBLYVERSION] ) does not match the Database Version ( [DATABASEVERSION] )
ERROR: Could not connect to database. The stored procedure 'dbo.dnn_GetPortalAliasByPortalID' doesn't exist.
I read in other posts that this is due to a faulty connection string, but I believe mine are right.
My Specs: WindowsXP Pro SP2, VS 2005, SQL Server 2005 Express
- At this point I have:
- Unzipped the 4.0.2 Source zip to C:\dotnetnuke
- Added C:\dotnetnuke as a virt dir in IIS
- Set ASPNET to have full control on the C:\dotnetnuke
- Copied SitesUrl.config from the Website\Config folder to Website\
- Opened VS 2005 and created a DB called DotNetNuke through the server explorer
- Downloaded DotNetNuke_template.mdf from http://www.johnczimmerman.com (this file is missing from the 4.0.2 source zip) and put it in the Website\Providers\DataProviders\SqlDataProvider dir
- Changed customErrors mode to "off"
- Opened //localhost/dotnetnuke
- Recieved the above error
My connection strings:
<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=DotNetNuke;uid=;pwd=;"
providerName="System.Data.SqlClient" />
-->
</connectionStrings>
and in the app settings section:
<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;"/>
I've been trying to get DNN installed for 2 days now. Any help is greatly appriciated.
Cheers,
Christopher