Hi all!
It seems I did the most stupid thing: I was copying the mssql-database to a new server to test on the new server, but I got it wrong and started to delete the tables on the new server. At some point I have also started to delete the tables one my existing db - I deleted the three top most on the list dbo.Affiliates, dbo.Announcements and dbo.AnonymousUsers. I tried to restore these from the backup, but now I cannot log on as host or admin (normal users log on fine). When I try to logon as Host or Admin I get the message: Critical Error Object reference not set to an instance of an object displayed just on top of the first html-text module on the page, and the rest of the page shown as it appears when not logged on. Thus I can not logon and also not see the admin control panel. Normal users are able to logon, even register new accounts, and use the wite just fine (I have a "normal user test user" ID). It's just the admin and host accounts that do not work (tried both types of userIDs - both host and local admin)
Does anybody have a clue what I might have screwed up when deleting and then trying to restore the top three tables on the db? What is it with any of these tables that should cause this problem?
Is there an easy way to force a "re-install" the current dnn-version over the corrupted existing one, but still keeping the content in the databases in place? Or is the hard way (new install) the only option - start from zero?
Anyone have a tip on the best and most reliable mssql database backup tool for backing up and restoring mssql-db on a shared hosting environment. I use the DataAdmin3, but it seems to confuse more than it helps as to how to do things. I normally use MS SQL Server Management Studio Express, but this does not allow for local backup's to my PC or restore from such, nor for server side backup and restore controlled by me.
Any help would be appreciated. Thanks!