How to rename SQL server after renaming the server it is installed on

book

Article ID: 180029

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question

How do I rename the SQL server's name after changing the computer name?

 

Answer

If you are changing SQL servers or just renaming it and the name is different and you want to still use the same Symantec_CMDB database, please consider the following:

  1. Make the change (either move to a new SQL server or change the existing SQL Server name) and make sure the name can be resolvable by your SMP (Symantec Management Platform) server.
  2. Open SIM (Symantec Installation Manager) and go to "Configure settings".
  3. Click on "Configure Database Settings"
  4. Under "SQL Server name:" make the proper name change.
  5. Make sure you select under "Database selection>Use existing" points to the desired database.
  6. Click "Next" and follow the next prompting. It will reconfigure your database to point to the new SQL Server name and update the necessary references.

Attachments