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

book

Article ID: 52739

calendar_today

Updated On:

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: