You can restore an MSSQL database from a backup with no additional steps required. If the hostname of the MSSQL database machine changes, you must revise configuration information for the MSSQL database.

Procedure

  1. Update the database entries.
    1. Open SQL Server Management Studio and locate the DynamicOps.RepositoryModel.Models table.
    2. Locate the string Data Source in the table and change the original SQL Server host name to the new host name for each instance of the connection string.

      For example:

      Data Source=MACHINE-NAME.domain.name;...
  2. For each machine not being reinstalled that contains a Web site component, update the host name in the configuration file.
    1. Open the C:\Program Files (x86)\VMware\vCAC\Server\Model Manager Web\Web.config file in an editor.
    2. Locate the repository element and make the following changes:
      • Modify the value of the server attribute for the database hostname. For example:

        server=DB-repository-hostname.domain.name
        				  
      • If you changed the database name, modify the value of the database attribute to use the new name.

    3. Save and close the Web.config file.
  3. Run the iisreset command from an account with administrator privileges.
  4. For each machine not being reinstalled that contains a Manager Service component, update the host name in the configuration file.
    1. Open the C:\Program Files (x86)\VMware\vCAC\Server\ManagerService.exe.config file in an editor.
    2. Locate the string Data Source and change the original SQL Server host name to the new host name for each instance of the connection string. For example:
      server=DB-hostname.domain.name
      				  
    3. If you changed the database name, modify the value of the Initial Catalog attribute to use the new name. For example:
       Initial Catalog=DBName;
      				
    4. Save and close the ManagerService.exe.config file.
  5. Restart the Manager Service.

What to do next

Restore the Identity Appliance. See Restoring the Identity Appliance.