COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: jayanthhyd on 19 Jan 2011 01:08:30 AM

Title: some one please help me getting problem with sql server(content manager)
Post by: jayanthhyd on 19 Jan 2011 01:08:30 AM
i changed my content manager database to sql 2005 i tested it run successdfully with out errors but while running services i am getting this error at end it not getting started and the error is :

"CFG-ERR-0103 Unable to start IBM Cognos 8 service. Execution of the external process returns an error code value of '-1'."

please help me its urgent...
Title: Re: some one please help me getting problem with sql server(content manager)
Post by: MFGF on 19 Jan 2011 07:11:40 AM
Did you create a new, empty content store database, or did you restore the original content store into the new one?  I'd suggest you try with a new, empty database, and use the Cognos 8 deployment method to restore it once it's up and running.

MF.
Title: Re: some one please help me getting problem with sql server(content manager)
Post by: jayanthhyd on 20 Jan 2011 05:08:34 AM
In cognos configuration previously content manager database was oracle now content manager database changed to sql server 2005 when i tested it was successful with out any errors and once saved and started at the end service is not started.. i got the above error.. some one please help me.....
Title: Re: some one please help me getting problem with sql server(content manager)
Post by: RobsWalker68 on 20 Jan 2011 05:30:15 AM
Hi,

Has Cognos created its relevant tables in the SQL Server database?  If it hasn't then you may want to check that the account accessing the database has the required permissions such as ddladmin etc 

Also is there any additional error information held in the cogserver.log file.  This may give a more detailed description of the issue.

Kind Regards

Rob
Title: Re: some one please help me getting problem with sql server(content manager)
Post by: jayanthhyd on 30 Jul 2011 07:28:04 AM
Thank you..