Previous Topic: Install the DSM Manager: Microsoft SQL Server MDBNext Topic: Preparing to Work with an Oracle MDB


Remote MDB Installation for Microsoft SQL Server

If you plan to run the DSM manager using a remote Microsoft SQL Server MDB, the manager and the remote MDB computer must have a trusted relationship when running in a Windows environment.

During the installation of a domain or enterprise manager, you can install the MDB on the local host or use an existing remote instance of the MDB.

For a remote configuration, install the database on the remote computer by selecting Install MDB (no CCS functionality).

If you need to use CCS with CA ITCM, you need to install CCS on the MDB host computer, whether local or remote. Use the Install CCS option from the top-level CA ITCM installation dialog. Then install the domain or enterprise manager.

If you use a remote Microsoft SQL Server, install the Microsoft SQL Client Management Tools before you install the domain or enterprise manager. Verify that the Microsoft SQL Client Management Tools are not deselected during Microsoft SQL Client installation.
CA ITCM uses the specific user ca_itrm created on the database level to get authenticated for MDB access. You need to specify the same password for the user ca_itrm during "Install MDB" and CA ITCM installation dialogs. The user ca_itrm is created automatically.
When you install multiple domain managers with remote Microsoft SQL Server MDBs, verify that only one MDB exists on each database server instance. This restriction means you must have as many database servers as MDBs.

Note: With a remote Microsoft SQL Server MDB, the name of the server hosting the domain MDB is used as the name of the domain manager. Therefore, the DSM Explorer in the enterprise manager displays the domain manager with the name of its database server.