06-07-2013 08:51 AM
Hello,
I'm trying to run a "SQL Server Reporting Services Data Analysis Reports", let say "Storage Summary" for example, it ask me to state the "Site Name", but the dropbox as no value and I can't write any, in the other hand in the "SQL Server Reporting Services Operation Reports" all the report I run as have the "Site Name" correctly filled. What I need to do to fix the problem?
If I use the administration Console's to access the Enterprise Vault Reporting's reports, I'm forwarded to an old server, where can I correct this?
Best regards
António Mourão
Enterprise Vault 9.0.3 | Sql 2008 r2 | Windows 2008 r2 (Clustered)
Solved! Go to Solution.
06-07-2013 09:05 AM
Do you do File System Archiving?
Those reports are for FSA and require reporting to be enabled on the File Server targets
06-07-2013 09:33 AM
You could just remove it from SQL.
You could run this:
DELETE FROM ReportServerURLSettings
WHERE ReportServerURLIdentity = 1
06-07-2013 09:05 AM
Do you do File System Archiving?
Those reports are for FSA and require reporting to be enabled on the File Server targets
06-07-2013 09:09 AM
As for the console pointing to the wrong server. Can you run this query against the EnterpriseVaultDirectory database?
select * from
ReportServerURLSettings
What do you get back? You might need to update the servername.
06-07-2013 09:21 AM
Thanks, Tony, I don´t have FSA.
06-07-2013 09:27 AM
the query return 2 server How can I remove the old server?
ReportServerURLIdentity | ReportSettingIdentity | ReportServerUrl |
---|---|---|
1 | 1 | http://oldserver01:80/ReportServer |
2 | 1 | http://newserver1:80/ReportServer |
06-07-2013 09:33 AM
You could just remove it from SQL.
You could run this:
DELETE FROM ReportServerURLSettings
WHERE ReportServerURLIdentity = 1
06-11-2013 12:30 AM
Thanks for the Help Tony.
06-11-2013 12:43 AM
I´m trying to find a report that indicate the state of enterprise vault specially storage usage or free space to give to the management, I monitor with some powershell script.