Content Store - Not upgrading

[shri]

hi gurus,

I am implementing Cognos 8.3 in different Machine. We have Cognos 8.2 up and running already. I have copied the cotent store database of existing environment in the new machine. When i try to start the New cognos 8.3 service it doesnt' upgrade the content store, instead it creates whole set of new tables in content store....is there anything  i am doing wroong.....? Thanks heaps in advance

[ducthcogtechie]

When restoring a database the tables include a table owner.
If you fire up the content store connection with a different username (regardless of DB_Owner rights) you will end up with a new set of tables as if you start it for the first time.
What are you using; sql, oracle, DB2 or the one from Cognos? (apache derby)

[shri]

hi, I am using MSSQL 2005 for Latest Cognos 8.3 and previous one is in MSSQL 2000, when i restored the content store database in MSSQL 2005, it didnt' restore the user name so i have to create the same user name, but even then it is not working...

[ducthcogtechie]

1. Restore the database.
2. Recreate the old username as a new sql user on the new server (don't try to set user mappings yet)
3. Run the following script against your restored database:
    EXECUTE sp_change_users_login 'Update_One', 'username', 'username'

("username" is the newly created sql username)
Once run, check the user mappings. The sql user should now have DB_Owner rights to your database.
Now point Cognos Configuration Content Store against this database.

[shri]

thanks ducthcogtechie, it worked and also i found a script from Microsoft website to transfer the logins from MSSQL 2000 to MSSQL 2005.