COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: Gollapudi on 09 Apr 2009 07:27:33 AM

Title: Problem with Sun One Directory Server
Post by: Gollapudi on 09 Apr 2009 07:27:33 AM
Hi,

We are actually using Sun One Directory server for the authentication, now that server is not responding and we dont have any backup .LAE file for that, and when i tried to login with a anonymous I dont have permision to see Report Studio and Admin Tools like Directory, Content Administration, is there any other solution to take the back up of existing Packages and reports...?

Thanks in Advance,
Gollapudi.
Title: Re: Problem with Sun One Directory Server
Post by: ducthcogtechie on 09 Apr 2009 08:10:19 AM
You can restore the everyone group back into the sysadmin group via script:
C:\Program Files\Cognos\c8\configuration\schemas\content\sqlserver\AddSysAdminMember.sql

(use oracle or db2 script equivalent, depending on where your content store resides)

Keep in mind that the sun ONE security link is destroyed, and needs to be rebuilt from scratch.


Maybe in your sun directory, the db2ldif and ldif2db can get you back in action. Contact Cognos support to help you out where needed.
Title: Re: Problem with Sun One Directory Server
Post by: Gollapudi on 09 Apr 2009 08:16:34 AM
Hi,

My ContentStore is MS SQL Server 2000, and can you please tell me where do i need to run this script.
Title: Re: Problem with Sun One Directory Server
Post by: ducthcogtechie on 09 Apr 2009 08:24:29 AM
Query analyser.
Title: Re: Problem with Sun One Directory Server
Post by: Gollapudi on 09 Apr 2009 08:33:42 AM
Wow your a Super Star Man... Thank you so much... You have saved my One year work today..

Once again THank you so much.

Thanks,
Gollapudi.