Use existing Content Store for new install of 10.2.1?

[Invisi]

I am installing a new Cognos server, 10.2.1 (IBM refuses to download older versions and I only have 32 bit of current version 10.1 here at client...). In my old Cognos 8 days, I was able to tell Cognos the location of an existing Content Store (a copy of course) and during the installation it would recognize this repository and migrate it to the new version. Now when I install, it ignores my existing repository content. What am I doing wrong?

[Invisi]

I found the (first) culprit: the database I copied (SQL Server...) is not on the regular dbo, but on 'Cognos8'... I will see how I can change that.

[smiley]

Either look for a script to change all Cognos8.table to dbo.table ownership, or on your new sql server create user Cognos8
Then run the following stored procedure against your restored database to activate the Cognos8 user.

EXECUTE sp_change_users_login 'Update_One', 'Cognos8', 'Cognos8'

[Invisi]

smiley, thanks for the tip!

I have chosen to go for the formal way, with an export and import...  :o

[smiley]

That´s even better, due to bypassing the "crap out, crap in" that way.