Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs-2008-r2]

13 questions
5
votes
1 answer

SSRS 2008 R2 domain user assigned for role but cannot access

I have SSRS 2008 R2 installed on my server and need to deploy report from Business Intelligence Studio at another computer which is in the same domain and under domain user (non-administrator). First I get the error "Unsufficient permissions". Then…
Aleksey Shubin
  • 191
  • 1
  • 1
  • 3
3
votes
1 answer

Allow anonymous access to SSRS

How could I allow anonymous access to SSRS so that all user can access the reports without asking for a user name and password?
meloi
  • 31
  • 1
  • 1
  • 3
2
votes
2 answers

Can I execute an SSRS report from a windows batch file?

We are using SQLServer 2008R2 and would like to run and SSRS report from a windows batch file. We're loading data warehouse tables using a third party scheduler program and at the end our dataload we want to run a data quality report using SSRS. I…
Christine
  • 21
  • 1
  • 2
1
vote
1 answer

SSRS reports print button missing in IE 8

Seems like this is broken again (SSRS report "unable to load client print control" and SQL 2008 SP2 RsClientPrint ActiveX - "Unable to load client print control"). We updated all of our Windows 7 clients last Friday and it looks like the mighty…
Will Sams
  • 11
  • 2
1
vote
0 answers

Disable Cache in SSRS 2008 R2

This is a problem that occurs for our IE 8 users (does not happen on IE 9). When rendering a reporting services report IE 8 caches the report so if the data is changed and the user re-runs the report stale data is displayed until the user restarts…
Benjamin Bryan
  • 197
  • 1
  • 9
1
vote
0 answers

SSRS2008R2 report times out, but the underlying query executes in the Management Studio

A customer of mine recently moved servers and the new server has SQL2008R2. His old server was SQL2005. The new server has substantially better CPU, RAM, and disk performance than the old, but several reports time out while executing. When I run…
Matthew Belk
  • 111
  • 2
0
votes
1 answer

Cannot login to Reporting Services through SSMS and Reporting Services Configuration manager

I am trying to connect to reporting services through ssms. I am getting a following error: "A connection to the computer cannot be established. Access is denied" I have system administrator/system user privileges in report manager. I am also part of…
mamontyonok
  • 1
  • 1
0
votes
1 answer

Separate Database For SQL Server Reports

I have researched this on here (and other sites) quite a bit. I feel like I am missing something simple. So please direct me to another posting or help answer my question. Basically, we have out grown our current database server. The main issue is…
M1ke901
  • 1
  • 1
0
votes
1 answer

"could not find the database engine startup handle sql 2008 r2" error

I have hit a brick wall here... I am trying to install ssrs in one of my other VM. After installing sql server express and ssms(which installs successfully), I have tried to install ssrs(making another instance "MSSQLSERVER")... I always get this…
EagleFox
  • 127
  • 8
0
votes
1 answer

Database Engine Services Required to install ssrs?

I have already installed sql server 2008 express and ssms on my vm... now I am trying to install ssrs on the same machine and keep getting "database engine error". Should I skip this (click here please) I have tried to uninstall and reinstall…
EagleFox
  • 127
  • 8
0
votes
1 answer

Can't install SSRS 2008 R2 default instance

I have a SQL Server 2008 R2 that had Reporting Services included and uninstalled. Default Instance. I now need to add Reporting Services to the installation and I am getting an "Instance Name in use" when I try to install the default instance. A…
Randy Knight
0
votes
1 answer

SSRS Data Driven Subscription empty destination folder

I have a SSRS Data Driven Subscription, the reports are save to a folder, I use the Overwrite Write Mode, however there are old reports that aren't generated anymore that lingers on the folder, I would like to clear the destination folder before…
Gabriel Guimarães
  • 425
  • 5
  • 18
0
votes
1 answer

Install Reporting Services 2K8R2 on W2K8R2 Cluster Nodes

First I'm aware that Reporting Services is not Cluster aware, But I would like to install it on my each node of my 2 node Cluster on the default instance. I've got the following error installing Rule Check Result Rule "Existing clustered…
Gabriel Guimarães
  • 425
  • 5
  • 18