Tonaco_pt
4 years agoModerator
Move SQL Server Reporting Services to a new server
Hi,
We are moving our Enterprise Vault SQL Server to new hardware, do I need to migrate "SQL Server Reporting Services" or just install a new one?
I think that SQL Server Reporting Services just have the report queries and the data are in the Enterprise Vault Databases.
I need to run this script to clear the old server and run "Enterprise Vault Reports Configuration"
Spoiler
USE EnterpriseVaultDirectory
DELETE FROM ReportServerURLSettings
WHERE ReportServerUrl like '<https://OldSQLServername%>'
DELETE FROM ReportServerURLSettings
WHERE ReportServerUrl like '<https://OldSQLServername%>'
You can just re-run the Configuration Utility, as documented here: https://www.veritas.com/support/en_US/article.100015422
Solution 2 Reporting Configuration Utility has been run without selecting the option Reconfigure data access settings for Reporting