CMA 5000 : Change External Database Server IP/hostname

[Anonymous]

Hello All,

Our CMA 5000 Externel Databases have to be migrated to a new server (Windows server 2005 ---> Windows server 2008 R2) by our DBA team. Can you tell me how to change CMA configuration to use this new server ?

Our intention is to go here in CMA : "Admin  >  Server Settings  >  Database" and enter the the new Database server name in "Database Server IP Address or DNS Name" then reboot the CMA 5000 server. Is this procedure correct ?

Thanks for your help.

[simons3]

Hi,

First make sure there are 3 databases:

1) Readimanager

2) XMPP

3) Logger

Then run the following stored procedure located in the Readimanager database: dbo.pr_fixorphanusers.sql. This will make sure the SQL user names have the correct passwords.

Then you would simply configure CMA to point to this new SQL IP address like you mentioned in your post.

S.

[Anonymous]

Thank you very much for your answer; I will be back very soon to let you if it works.

Best regards

[Anonymous · Accepted solution]

Hi all,

As promise in my previous message. After change the CMA database server, all work well except CMA Desktops that are not able to register to the Gatekeeper. Can someone point me to the right direction to fixe this probleme.

NB : The CMA Desktop is autheticate through Active Directory.

Thanks a lot for your answer and for what you have already done to help.

Best Regards.

[Anonymous]

I have one external database server which is used as CMA External database for testing.  due to some reasons we have changed it to other test database (6m back), now  I am willing to connect it to the old Database server.

info : between this duration we have upgraded CMA soft ver.

can I just change in CMA server setting pointing to new Database ?

or I need to follow some other process?

[simons3]

Ngusimel -

Did yo try to reset the SSO Conputer password: go to your DC, start, run, cmd and enter: net user <account>$ <password>

Then update the password in CMA.

S.