SQL Server Reporting Services Data Analysis Reports

[Tonaco_pt]

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)

[TonySterling · Accepted solution]

Do you do File System Archiving?

Those reports are for FSA and require reporting to be enabled on the File Server targets

[TonySterling]

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.

[Tonaco_pt]

Thanks, Tony, I don´t have FSA.

[Tonaco_pt]

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

[TonySterling · Accepted solution]

You could just remove it from SQL.

You could run this:

DELETE FROM ReportServerURLSettings

WHERE ReportServerURLIdentity = 1

[Tonaco_pt]

Thanks for the Help Tony.

[Tonaco_pt]

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.