Is it possible to use same SQL Server database with named instances for a DSM Domain manager and Enterprise Server?

Article Id: 52739

Status: Published

Updated On: 14-02-2018 06:43

Legacy Id: TEC496346

Products:

CA Automation Suite for Data Centers - Configuration Automation , CA Client Automation - Asset Management , CA Client Automation - IT Client Manager , CA Client Automation , CA Client Automation - Remote Control , CA Client Automation - Asset Intelligence , CA Client Automation - Desktop Migration Manager , CA Client Automation - Patch Manager , CA IT Asset Manager , CA Software Asset Manager (CA SAM) , ASSET PORTFOLIO MGMT- SERVER , CA Server Automation , CA Service Management - Asset Portfolio Management , CA Service Management - Service Desk Manager

Issue/Introduction:

No, it is not possible to use same SQL Server with named instances for Domain and Enterprise Manager.

When you are using remote SQL Server MDBs, please note that the name of the server hosting the domain MDB is used as the name of the domain manager.
Therefore, if the Enterprise Server and the Domain Manager use the same database, both the domain manager and enterprise will have the same name.

In addition, CCS can run against one instance of a Database. So, if you have the Domain Manager and the Enterprise Server pointing to the same Database server, only one of them can use CCS.

Therefore, CA strongly recommends using separate MDBs for Enterprise Server and Domain Manager.

Environment:

Release: UASIT.99000-11.2-Asset Intelligence
Component: