restore system administrator role in cognos namespace

[hiranb]

Hi,

    I accidently deleted system administrator role in cognos namespace. Can it be restored? If so please provide info on how to restore the system admin role. Thanks for your help.

[MFGF]

Hi,

Hmmm - I didn't think it was possible to physically delete the System Administrator role.  Do you mean you have removed all users and groups from it?  If so, there is a script you can run:

\Program Files\Cognos\c8\configuration\schemas\content\<your content store database type>\AddSysAdminMember.sql
This will add the 'everyone' group back into the System Administrators role.
Next, go into Cognos Configuration set the 'allow anonymous access' setting of the Cognos namespace to 'True' and restart your Cognos 8 service.

Good luck!

MF.

[hiranb]

It worked. Thanks.

[nj]

Applause to this.
MFGF: continue to rule.

[willg]

I can confirm this still works with Cognos 10, just saved me a lot of hassle! (Be sure to stop the service before doing it though otherwise it wont work).

[simi123]

Thanks to MFGF!. :)

I fixed the issue after read your post.