Forum Discussion

Tonaco_pt's avatar
Tonaco_pt
Moderator
4 years ago

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%>'