cancel
Showing results for 
Search instead for 
Did you mean: 

Move SQL Server Reporting Services to a new server

Tonaco_pt
Moderator
Moderator
Partner    VIP    Accredited

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%>'
1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

View solution in original post

2 REPLIES 2

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Tonaco_pt
Moderator
Moderator
Partner    VIP    Accredited

Hy Tony,

Thank you, just needed to confirm.

I'll re-run the Configuration Utility.

 

Antonío