I'm hoping someone out there can help me out... I want to deploy my local DNN installation to my hosting provider, and no matter what I try, I am constatly getting the following error:

DotNetNuke Upgrade Error

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

ERROR: Could not connect to database.

Invalid object name 'dbo.PortalAlias'.

I've been searching the forums and google for 2 days now and needless to say its getting a bit frustrating... I was able to setup a new install on the host with no problem, it works fine.Only when I restore the DB to the host sql server and copy my development DNN folder up do I get this error. Is there any reason why it is trying to upgrade, and why the assembly versions don't match??

Any help at all would be greatly appreciated!

Thanks.

Paul

Hi Erik, thanks for the reply!

I can't begin to tell you how many times I've checked over the sql connection string in the web config... And I was sure to add the new portal alias in the site settings page before I backed up the database in my local test environment. It's strange because I was able to setup a clean, new install without any problems at all, which leads me to believe that there is no problem with the hosting company. This error only occurs when I restore the database from my local backup. 

I really hope I don't have to recreate all the work I've done on my development box, I spent countless hours setting everything up the way I wanted it. Again, thanks for the reply, if you can think of any other reason why this error may occur I'd be very grateful!

Thanks!

Paul 

Ah... thats where your mistake is. DBO does not necessarily mean that your username is DBO, it just means that the user that u use to connect to your db has DBO rights in the db. So if your user indeed has dbo rights, then just leave the DBO in web.config, don't change it with your real username.

cheers,

Erik

DNN Blog | Twitter: @erikvb | LinkedIn: