Install the Domain Orchestrator › Prerequisites to Installing the Domain Orchestrator › Database Prerequisites › Prepare a Microsoft SQL Server Database for CA Process Automation › Guidelines for Specifying the Database Server Name for a SQL Server Database

Guidelines for Specifying the Database Server Name for a SQL Server Database

When you install the Domain Orchestrator or any nonclustered Orchestrator, you specify details for three CA Process Automation data stores: Library, Runtime, and Reporting. If you define the Type of Database as MS SQL, use the following guidelines to specify the Database Server:

• If you have only one SQL Server instance on the host server, specify the host name of the server. (This name is the default instance.)
• If you have multiple SQL Server instances on the host server, specify the SQL Server named instance in the format host_name\named_instance.

  A SQL Server named instance is another copy of SQL Server running on the same host. Each copy runs independently; each copy is distinguished by its instance name. A database server can have many named instances but only one default (unnamed) instance.