Content Manager connection issue

[steveellis00]

Hi All,

I am having an issue with my Cognos 10.2 installation.............

I am at the stage where I start the service for the first time and I am getting the following error:

11:18:50, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.  CM-SYS-5003 Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful.  Failed Logon:com.jnetdirect.jsql.JSQLException: TCP/IP connection failed to host:<server> com.jnetdirect.jsql.JSQLException: Login failed for user '<user>'. url:jdbc:JSQLConnect://<server.instance>/<dbase>/applicationName=IBM_C10_2_CM Cause: Failed Logon:com.jnetdirect.jsql.JSQLException: TCP/IP connection failed to host:<server> com.jnetdirect.jsql.JSQLException: Login failed for user 'cm102_prod_job'. url:jdbc:JSQLConnect://<server.instance>/<dbase>/applicationName=IBM_C10_2_CM    Stack trace:  com.jnetdirect.jsql.JSQLException: Failed Logon:com.jnetdirect.jsql.JSQLException: TCP/IP connection failed to host:<server> com.jnetdirect.jsql.JSQLException: Login failed for user '<user>'. url:jdbc:JSQLConnect://<server.instance>/<dbase>/applicationName=IBM_C10_2_CM     at com.jnetdirect.jsql.JSQLDriver.connect(JSQLDriver.java:302)     at java.sql.DriverManager.getConnection(DriverManager.java:379)     at java.sql.DriverManager.getConnection(DriverManager.java:415)     at com.cognos.cm.dbstore.CMDbStoreFactory.getJDBCConnection(CMDbStoreFactory.java:1955)     at com.cognos.cm.dbstore.CMDbStoreFactory.getInitialConnection(CMDbStoreFactory.java:1742)     at com.cognos.cm.dbstore.CMDbStoreFactory.initContentIndependentBeforeLock(CMDbStoreFactory.java:1975)     at com.cognos.cm.dbstore.CMDbStore.initializeContentIndependentBeforeLock(CMDbStore.java:3973)     at com.cognos.cm.server.CMServlet.initializeContentStoreContentIndependentBeforeLock(CMServlet.java:2079)     at com.cognos.cm.server.CMServlet.init(CMServlet.java:1847)     at com.cognos.cm.server.ContentManager.start(ContentManager.java:405)     at com.cognos.cm.server.ContentManagerLifecycleHandler.start(ContentManagerLifecycleHandler.java:62)     at com.cognos.pogo.services.DefaultHandlerService.start(DefaultHandlerService.java:94)     at com.cognos.pogo.services.DispatcherServices.startInitialService(DispatcherServices.java:415)     at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:401)     at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:751)     at com.cognos.pogo.util.threads.SafeThread.safeRun(SafeThread.java:70)     at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) 
11:18:51, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
11:18:51, 'com.cognos.pogo.contentmanager.coordinator.ActiveCMControl', 'pogo', 'Failure'.
DPR-DPR-1035 Dispatcher detected an error.

The connection credentials are definately correct as:
1)     I can connect directly via SQL Management Studio using them
2)     Testing 'Content Manager Database Connection' is successful

I did not have these same issues when installing development and test versions  :-[

Any help/ideas gratefully received

Cheers,
Steve