5.8

Integrated Security=SSPI;Data Source=SERVERNAME;Initial
Catalog=VCM;LANGUAGE=us_english;
17. Click Test Connection to verify that the connection is created successfully, and click Apply.
18. Click Home to return to the SSRS home page.
19. Click Folder Settings to remove any extra accounts in SSRS.
If any users other than the BUILTIN\Administrators and ECMSRSUser exist, click the check box next
to each user account and click Delete.
Restore the VCM Databases
As part of the recovery process, restore the VCM databases to restore your collected data and
customizations.
Prerequisites
Verify that you have an account with SQLAdministrative privileges.
Procedure
1. Launch SQL Server Management Studio.
2. Connect to the VCM database server using an account with SQL Administrative privileges.
3. In the query window, type the following commands to restore the VCM database and click Execute:
RESTORE DATABASE [VCM]
FROM DISK = N'E:\Backup\VCM\VCM_backup_201003021337.bak
WITH FILE=1, NOUNLOAD, REPLACE, STATS = 10
GO
4. Type the following commands to restore the VCM_UNIX database and click Execute:
RESTORE DATABASE [VCM_UNIX]
FROM DISK = N'E:\Backup\VCM_UNIX\VCM_UNIX_backup_201003021337.bak
WITH FILE=1, NOUNLOAD, REPLACE, STATS = 10
VCM Backup and Disaster Recovery Guide
38
VMware, Inc.