Hi All,
I'm attempting to deploy a DNN 3.2 based site from my local development box to my hosting company, and I'm running into an issue with the the owner of the database objects. My local installation was setup with the DatabaseOwner set to 'dbo'. My databases are setup at my hosting company with another database user, and after I uploaded my database and files, and modified the web.config to reflect the new database user/owner, and ensured the portal aliases were correct, I thought the site would run without an issue. Unfortunately I keep 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 was able to replicate this issue on my development box as well, so I know its not an issue with the hosting company. In fact, I tried a clean install on the host and it worked perfectly.
My question is why is the application still looking for 'dbo.PortalAlias'? After the change of the DatabaseOwner in the web.config file, shouldn't all calls to the database reflect the new setting?
Hopefully somebody out there can help me out, I've spent quite a bit of time developing the site, I would hate to have to do it all over again... any help at all would be greatly appreciated!
Thanks in advance,
Paul