IBM Cognos TM1 10.2.2
Microsoft Windows 2012 R2 Server
Microsoft Excel 2013
When starting TM1 Perspective and try to connect to a TM1 server with SSO login though CAM (Cognos Access Manager) it is slow and ends up with an error message:
“(N33) Connection Failed”
When you select the TM1 instance, Excel is stuck for a moment, and the dialog will ask for Native user name and password. Then you can suspect that the SSO will not work.
A TM1 instance on same Windows server without SSO works without an issue in TM1 Perspective.
It works to connect to other TM1 instances on the same Windows server, this suggest that the port used is not open in some firewalls or other application use the same port.
On The TM1 instance with SSO, change the port number used for TM1 in the TM1S.CFG file.
Change it from today’s value to a value close to the one used in the TM1 application that works.
Set value in TM1S.CFG to:
PortNumber = 12348
ClientMessagePortNumber = 12349
Save the file.
Restart the TM1 instance service.
Start TM1 Perspective on client laptop and test again.