Change the SQL server name on server role Settings screens

Procedure 14 of 23 associated with Step 2 - Change the Computer Name, Domain, or Workgroup of an Individual Managed server.

In this procedure, you must change the SQL Server Host Address field for every server role Entity that contains a logical, predefined set of components (system software or certified third-party software) deployed in the Data Center and Site Zones that provide specific functionality for the system. that accesses the computer running SQL Server whose name has changed.

All of the following server roles contain the SQL Server Host Address field and access a computer running SQL Server.

• Archive Database

• Biometrics Database

• Contact Database Server role in the Data Center that includes long-term interactions. The Contact Database is optimized for searching operations, and interactions are inserted and updated in bulk operations.

• Contact OTLP Database

• DPA Database Server role in the Data Center that stores data for the Desktop and Process Analytics (DPA) product.

• Framework Reports

• Framework Data Warehouse Server role in the Data Center used to store Scorecard metrics and processed data for reporting purposes.

• Framework Database Server role in the Data Center (also known as BPMain) that stores user, organization and group data, including user preferences and security data (roles, permissions, and license information).

• Interaction Data Warehouse Server role in the Data Center that is used to store recording, Quality Monitoring (QM), and Speech Analytics data for reporting purposes.

• Interaction Reports

• QM Database Server role in the Data Center used to store Quality Monitoring application data.

• Speech Analytics Database Database in the Data Center used in the Speech Analytics 2.0 solution that stores the ontology output from the Ontology Training process.

• Speech Products Database Database in the Data Center that stores transcribed interactions.

• Customer Feedback Survey Server role in the Site zone that allows creating and managing short, context-sensitive surveys to capture data immediately after the customer’s interaction with agents.

You must locate and examine the settings of the active server roles in your enterprise that are of the types listed above. For each server role that accesses computer running SQL Server whose name you have changed, you must change the SQL Server Host Address field. In that field, you must replace the old name of the computer running SQL Server with the new computer name.

Use the following procedure to change the SQL Server Host Address field for the server roles:

1. Click System Management Module that allows performing suite-wide system management activities from a single, Web-based application, the Enterprise Manager. > Enterprise Management > Settings.

2. Locate the server roles in your enterprise that are of the types listed above.

   For example, in the Installations tree (left pane), expand each Server node to view the server roles that are active on the each of the servers. Identify each server role that is of a type listed above.

3. In the left-hand pane, select one of the active server roles listed above to display the server role’s settings.

4. In the right-hand pane, in the SQL Server Host Address field, replace the old name of the computer running SQL Server with the new name of that computer.

5. Click Save.

6. Repeat these steps for every active server role listed above that exists in the enterprise and that specifies the old server name of the SQL server in the SQL Server Host Address field. All of these active server roles must specify the new computer name of the computer running SQL Server in the SQL Server Host Address field to connect to that SQL Server.

What to do next 

Update DPA with new Recorder server name