The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
3answers
882 views

Error running Report in SQL Server Reporting Services (SQL Server 2005)

I get an error message " An error has occurred during report processing. Query execution failed for dataset [sprocs name]" when running SSRS report. The stored procedures for this report can be ...
0
votes
1answer
806 views

How do I diagnose my poorly-performing SQL Reporting Services 2005?

I have a Windows Server 2008 R2 server running MS SQL Server 2005 and SSRS. The server has 48 cores and 128GiB of memory. The IIS worker processes and reportingservicesservice.exe never get over ...
0
votes
1answer
301 views

How can I get Visual Studio to deploy to SSRS named with CNAME instead of A record?

We have SSRS (SQL Server Report Service) running on an Amazon EC2 instance. It had been named report.foo.com using an A record. Recently we changed it to a CNAME referencing the EC2 public DNS name. ...
1
vote
2answers
436 views

How do I update the SSRS password configuration using a powershell script

I have about 60-70 machines that may or may not have SSRS. The password just expired for the service accounts that it runs under. Is there a way to script the update password for SSRS?
2
votes
2answers
3k views

SSRS 2008: Unable to restore encrytption key

I have migrated SQL server 2005 database to sql server 2008 using side by side upgrade. I have copied Reportserver and reportservertempdb database across and configured SQl server Reporting services ...
0
votes
1answer
1k views

SSRS Subscription Fails

Our SSRS server is not executing a subscription correctly. (Only subscription we have btw) We created a subscription to export a report as an excel file to the file system. Tried running the job ...