Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssrs]

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.

244 questions
2
votes
4 answers

Is it possible to mirror the SQL Reporting Services databases?

Is it possible to mirror the SQL Server (2005 or 2008) Reporting Services databases (ReportServer, ReportServerTemp)? I have a web site that uses a database that is already mirrored, and it also makes use of the Reporting Services. I want to be…
Anthony K
  • 374
  • 1
  • 6
  • 12
1
vote
2 answers

SSRS shows blank page for 1 user

We have a ssrs portal for our clients. they use sonicwall to gain access to our network. I have one external client/user that can access the vpn, but when he tries to hit the server he gets the spinning circle. He notes the tab title is…
greg
  • 113
  • 4
1
vote
2 answers

SSRS Prompting for credentials when using FQDN

I came across this issue because I'm writing a web application which uses SSRS reports and, after configuring our production SSRS server to use HTTPS we found that reports won't run (we get error 401: Forbidden). I've since found that if I try to…
Philip Stratford
  • 113
  • 1
  • 5
1
vote
1 answer

SQL Reporting Services with SSL exclusively

I know how to add an SSL cert to SSRS 2008. Is there a way to force SSRS to use SSL (port 443) exclusively? Right now it will respond to both encrypted and unencrypted requests. IIS has the Require Secure Channel option. Does SSRS have the same?
Ryan Michela
  • 1,147
  • 4
  • 16
  • 23
1
vote
1 answer

Windows 2012 Server inaccessible (using rdp) but SQL Server databases are accessible (ssms)

We have a Windows Server 2012 Standard, which runs SQL Server 2012 Enterprise edition. This morning we found the reporting services was inaccessible. We attempted to use Remote Desktop to connect to the machine, but could not get in. All databases…
kevcri
  • 11
  • 1
1
vote
2 answers

SQL 2008 Reporting Services Report Manager blank on Win 7

I have installed SQL Server 2008 Reporting Services on my development laptop running windows 7. When I browse to the report manager, only the header is shown. The content pane is blank, and there is no 'Site Settings' option, New Folder options,…
Daniel
  • 141
  • 1
  • 7
1
vote
2 answers

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

After applying hotfix KB3194725 to our SQL server, the SSRS server throws the following exception when trying to generate a report: Exception type: InvalidReportServerDatabaseException Exception message: The version of the report server…
Henrik H
  • 111
  • 1
  • 4
1
vote
1 answer

cannot do any operation on the ssrs manager

I have installed a named instance of sql server with reporting services (2016) on my local machine. But in the reporting service manager (the web portal) I cannot perform any operation*. My guess is that there is a problem in connection between…
Mohsen Kamrani
  • 121
  • 7
1
vote
1 answer

IIS slow in loading Report Viewer

We are running IIS & SSRS on the same production server and have two types of reports - one running through Report Viewer, connecting to SSRS (remote mode) and the other calling the SSRS web service to generate PDFs. For both of the report types, it…
apache1123
  • 11
  • 2
1
vote
2 answers

SSRS - Rename Database

Is there anyway to rename a SSRS database? I am moving from SSRS 2005 to 2008 but want to fully test before I cut over to the new server. The plan was to create a copy of the SSRS database and point the 2008 instance at the new DB. That appears to…
TonyB
  • 383
  • 2
  • 6
1
vote
1 answer

Install "Microsoft Report Viewer" on Windows Server 2012 R2

I am attempting to install Microsoft Report Viewer (2015) on a web server. The web server is a Windows Server 2012 R2 (x64) instance. The web server will be running a .NET application that uses the Report Viewer in an ".aspx" page. The web server…
Bruno L.
  • 121
  • 1
  • 7
1
vote
1 answer

How do I stop SSRS from sending any missed reports when starting the service?

We fired up a test SSRS service that hasn't run for a couple of months. It appears that it has decided to send all reports where it has missed the schedule (so any report that didn't send since it was turned on). We obviously don't want this. What…
Lock
  • 1,637
  • 7
  • 26
  • 33
1
vote
1 answer

Managing Reporting Services

We're expanding our reporting services usage and are trying to set up some guidelines for developers and admins on managing and developing for the system. Do you have any advice on keeping a reporting server running well and organized? Is there…
Sam
  • 2,020
  • 1
  • 16
  • 22
1
vote
2 answers

rsAccessDenied - SQL server 2008 reporting services

I am running SQL server 2008 developer edition on windows vista home premium. I created a reporting services project that was built successfully in BIDS. When I try to deploy it it gives the following error: Error rsAccessDenied : The permissions…
rboorgapally
  • 233
  • 2
  • 5
  • 18
1
vote
2 answers

Get login prompt for SQL reporting services deployment

Get login prompt for SQL reporting services deployment. I really just want to deploy a report. I have -set my Web Service URL to be "ReportServer" -I have tried several different service accounts. -tried many different passwords for this dialog…
Maestro1024
  • 271
  • 1
  • 3
  • 9
1 2 3
…
16 17