Run the SQL Server Change Computer Name application to rename an SQL Server

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

Perform the steps in this procedure only if you are changing the name of a computer running SQL Server. (This is the server whose name you just changed in Change the Windows computer name/domain/workgroup membership on the server.)

If the computer whose name is being changed is not running SQL Server, skip this procedure and continue to the next procedure, Ensure that SSRS can access the Reporting Services database.

Note that this procedure is also relevant for remote computers running SQL server, where the SQL Server is not installed on the same server as the database server platform Predefined logical group of server roles installed together on a physical server. but on a separate server that hosts only the SQL Server.

In this procedure, you run the SQL Server Change Computer Name application to execute an internal name change required by the SQL server.

The SQL Server Change Computer Name application resides on every server on which a database server platform is installed (for example, the Database platform or 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). platform). You can use the SQL Server Change Computer Name application to create a remote connection to the computer running SQL Server and execute the name change on the computer running SQL Server. The SQL Server Change Computer Name application does not have to run on the same computer as the computer running SQL Server.

Procedure 

  1. Open the following directory on any computer on which a database server platform is installed:

    <install_directory>\Software\CommonDB\Utils\Change Computer Name

    On the 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. server, the SQL Server Change Computer Name application is in the following location:

    <install_directory>\Software\CFtomcat64\Utils

  2. Do the following:

    1. Press SHIFT+Right-click on the SQL Server Change Computer Name application and select Run as different user.

    2. Enter the name and password of the Windows account that has SysAdmin administrative privileges on the computer running SQL Server.

      The account used in step 2 b. above is at the discretion of the customer.

      If you have configured a Database Management Account (DMSA) in your enterprise, you can provide DMSA with SysAdmin privileges and run the SQL Server Change Computer Name application under the DMSA account.

  3. In the SQL Server Change Computer Name dialog, do the following:

    1. Under SQL Server Connection Properties, in the SQL Server: field, enter the new name of the computer on which the SQL Server resides. (The application will connect to this server to make the internal name change.)

    2. In the Port: field, enter the port on which the computer running SQL Server listens for connections (default 1433).

    3. Click Connect.

      The previous name of the computer running SQL Server and the current (new) name of the computer running SQL Server display under the Computer Name Details section on the right-side of the dialog.

    4. Verify that the Previous Name: field and the Current Name: fields display the correct previous and current names of the computer running SQL Server, respectively.

    5. Click Change SQL Name and respond to the prompts.

    6. When prompted to restart the SQL Server Service, restart the Windows service named SQL Server on the server whose name you have changed.(For example, from Windows select Start > Administrative Tools > Services and restart the service.)

If you provided the DMSA account with SysAdmin privileges to complete step 2 b., remember to revoke those privileges from the account.

What to do next 

Ensure that SSRS can access the Reporting Services database.