How can I have multiple MDB databases on the same SQL Server?

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

I need to install "Client Automation" where the SQL Server already has a database called MDB from another Broadcom solution and we do not want both application sharing the same MDB database. 

Environment

Client Automation

Resolution

There are two possible solutions and your DBA will advise on the best one for your SQL Server environment.

The first option is to use separate SQL Server Instances. Each application would then have its own SQL Server instance for housing the MDB database.

The second option is to enter a different database name while installing "Client Automation" as shown in the example below: