With this method each CMS or gateway uses a separate instance of SQL Server, all hosted on the same machine. You will need to create each SQL Server instance before you install the intended CMS or gateway (the installation wizard lets you choose which instance to use.
For each SQL Server instance service, you will need to create a login for CA DataMinder to use. Note also that each CMS or gateway must use a separate port number to communicate with its own instance of SQL Server.
Note: This method offers superior security where your database server supports not just CA DataMinder but other applications too. This is because it allows you to separately control access to system tables and management tasks for each instance.
Example: Separate instances of SQL Server for each CMS
The following is an illustration where separate instances of SQL Server instance are used by each CMS or gateway:
1 CMSs or gateways. 2 Server hosting multiple instances of SQL Server. 3 Separate SQL Server instance for each CMS or gateway.
|
Copyright © 2014 CA.
All rights reserved.
|
|