TN Hist256 Renaming computer name is OS User roles in SQL Server after a computer name has been changed

Description

This article from InSource shows how to rename SQL Server OS Role computer names after a computer name has been changed. This may be needed if Wonderware Historian was installed before changing the name of the computer.

• Author: Joseph Hefner
• Published: 06/24/2016
• Applies to: SQL Server 2005 or later

Details

1. Follow Tech Note 1191 to ensure the Historian and SQL Server configuration is correct on the new computer.
   
   https://softwaresupportsp.invensys.com/Pages/OKMArticle.aspx?docId=TN1191&actp=LIST
    
2. Open SQL Server Management studio and locate the roles still associated with the old computer name:
   
3. Right Click on each role and select "Rename":
   
4. Change the computer name in each role to the new computer name:
   
   After completion this should look similar to the screenshot below: