Connexion problems when SQL cluster moves

Tools and several solutions to manage Control-M products
Post Reply
User avatar
Diablau
Nouveau
Nouveau
Posts: 44
Joined: 08 Jul 2009 12:00
Location: Québec, Canada

Connexion problems when SQL cluster moves

Post by Diablau » 08 Apr 2010 5:27

Hi everybody!

We have Ctrl-M/EM 32 bits, Ctrl-M/Server 32 bits and SQL Server 2005 64 bits all clustered and all under Windows Server 2003.

When we move Ctrl-M/EM and Ctrl-M/Server clusters everythings doing fine. But, when we do the same with SQL Server we get a communication lost. We lost communication at Ctrl-M/Server and agent level.

To get back the communication up (on 2370 port), we have to restart two services: CTM Server and CTM Configuration Agent.

It's a problem to have to do this every time the SQL Server cluster moves. Do you have any idea about how to resolve this problem?

Thanks a lot!

User avatar
punchy
Nouveau
Nouveau
Posts: 27
Joined: 30 Oct 2008 12:00
Location: Melbourne

Post by punchy » 09 Apr 2010 7:45

Hi Diablau,


Put the restart of Control-M/Server Service and restart of Config Agent in dos script *.bat.

e.g: bounce_ctms.bat

net stop "CONTROL-M/Server"
net stop "CONTROL-M/Server Configuration Agent"

net start "CONTROL-M/Server"
net start "CONTROL-M/Server Configuration Agent"


Then execute this script maybe as a generic resource. make this resource a dependency of the SQL resource.


I haven't done this myself but it's something worth trying. Hope this helps.

Post Reply