When attaching content database to SharePoint 2007 SP2 farm, or upgrading an SP1 database to SP2 you get error: "Cannot find the object "DatabaseInformation" because it does not exist or you do not have permissions."

In my current quest to upgrade our MOSS farm to SP2, I have stumbled across some fairly nasty problems, first having to create a new configuration database, and now the content databases themselves won't re-attach.

If you experience the following message when running stsadm -o addcontentdb on a SP2 farm to attach an older content database and thus upgrade it, you will need to speak to Microsoft for a resolution.

"Cannot find the object "DatabaseInformation" because it does not exist or you do not have permissions."


If you wish to take a risk and fix the problem yourself, here is an unsupported resolution.


The problem you are having can be confirmed by expanding the tables of your content db and looking for the dbo.DatabaseInformation table. If this table is missing, that is why you can't upgrade your database.


This table contains a couple of columns (Name, Value), you need to re-create this table with exactly the same columns as in a working content database, and then generate a GUID with GUID Gen or similar. In the 'Name' column, type 'Id', in the 'Value' column enter a GUID string you have generated with GUID gen (or if you google guidgen there are online tools for this).


Now re-run the addcontentdb command and your database upgrade should complete.


Please remember this is unsupported.