I encountered the same problem: I installed XI 3.0 using mySQL for the security database. Everything worked fine until suddenly, after a couple of days I got the same problem as you.
The installation was done, using all default values, so the port for CMS = 6400.
Proceed as follows:
Start Central Configuration Manager (CCM)
Select Server Intelligence Agent (SIA)
Select Properties
Select the ‘Configuration’ tab. It mentions ‘CMS belongs to cluster name servername:6400’ (so this is OK)
Select the ‘Startup’ tab. Strange enough here I found not port = 6400, but port=6410. This caused the problem.
Notice that you can not change this if the SIA is running. To solve it:
Stop the SIA
Select the SIA again, select the Properties and select the ‘Startup’ tab. Now you can change the value into port = 6400.
Start the SIA again
Everything worked again. So I have a solution, but I don’t know the reason why the port changed.
Henri Theuwissen, thank you for posting the solution! I actually followed your instructions and and received a different error.So I went back in and put the port back to 1610.Restarted the SIA and it all magically worked again. Now I am back on track! Thanks
Some times we way to solve it might be as simple as double checking concerned servers are enabled, up & running in the CCM. Go to the Manage Servers in the CCM and after the authentication process check the server status state.
I’ve found that this occurs when there is a problem with the CMS connecting to the CMS database.
For me, I had removed the default database for the user that was the owner of the CMS database. Attempting to log into SQL Server Management Studio with that user gave me a useful error, so I could fix up the user account. Everything then worked again.
I encountered this problem after downloading the trial version of Crystal Server 2011. The challenge I am having is that nowhere in Central Config Manager do I have an entry called SIA.
This helped me diagnose my issue. In the spirit of sharing and contributing backl I thought I should say what brought me here.
My Server Intelligence Agent was shown as running in the Central Configuration Manager so I assumed it had started successfully but when I checked under the Configuration tab it popped up a error message stating that it couldnt find the CMS database.
When I checked SQL Server I found that for some reason the CMS database couldnt be accessed (Ive no idea why it choose to die while my staging area and other databases are fine) so I restored by CMS database from a backup and restarted the Server Intelligence Agent.
I have the same issues here. Our version is XI 4.0 SP5 and we are running it over a DB2 database.
Just like my friend FreeZey, that topic help me in find a less generic error.
Under the configuration tab, the message was something like: “DB2 running whith HADR enabled. That makes necessary that the column CMS-INFOOBJECTS7 from table PROPERTIES is defined like LOGGED. It can´t happens because the actual DB2 version does not support big blob columns. CMS will not be inicialized in this condition because a fail in this database could break the repository. We have two options: first, upgrade DB2 server to v9.5 fixpak 5 or later, 9.7 fixpack 1 or later, or, v10 or later. The second is deactivate HADR. (FWB00088)”
I´m in contact with our DB2 DBA and sooner i will post our solution here.