IBM Support

How to check the Cognos Command Center repository connection details

Troubleshooting


Problem

After CCC client has been installed, it is not possible to check or change the connection details. How can this be checked?

 

 

Symptom

In the CCC log the following may be seen, so one has to check the connection details:

Service cannot be started. System.Exception: Failed to start. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.)
at SccServerService.SASServer.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

Resolving The Problem

Launch Regedit and find this key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\IBM\Cognos Command Center\Install]

Look for these 2 entries:

"DbSqlServer"="<SQL_Host_Name>"
"DbSqlName"="<Database_Name>"

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"Cognos Command Center CCC","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"Cognos Command Center CCC","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 September 2021

UID

ibm10737739

Page Feedback