ITSM Applications on Clustered SQL

Document ID : KB000012336
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Is it possible to install CA Service Management and CA Process Automation with a clustered SQL server setup?

Environment:
CA Service Desk Manager version 12.9 or above (any configuration) OR CA Service Management 14.1 or aboveCA Process Automation 4.2 or 4.3Microsoft SQL Server setup as a cluster (the MSSQL version must be listed as compatible with each application connecting to the instance)
Answer:

CA Service Management is cluster tolerant, but not cluster aware.  That means that the applications will work with a SQL cluster as long as the cluster behaves in the same way that a single server would.  To accomplish this, you should use the virtual host name of the cluster, the proper port to connect to that virtual host name, the proper instance name, etc.

Additional Information: