some one please help me getting problem with sql server(content manager)

[jayanthhyd]

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...

[MFGF]

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.

[jayanthhyd]

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.....

[RobsWalker68]

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

[jayanthhyd]

Thank you..