Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssrs-2014]

SQL Server Reporting Services 2014, a web based reporting tool produced by Microsoft and bundled with SQL Server 2014.

31 questions
4
votes
4 answers

Copy SSRS reports to another server

I am new to SSRS and I have been tasked to copy the SSRS reports(from PROD) to another Server(QA). I found many documentations that show how to migrate the reports by Restoring ReportServer, ReportServerTempDB and encryption key. I just want to…
user206573
  • 41
  • 1
  • 2
3
votes
1 answer

SQL Server 2014 Reporting Services issues

I have set up SSRS on MS SQL 2014 Dev Edition using the ReportServer built in account as the Service Account. My machine name is: POUYASAGER My local login is pyous I have given the ReportServer account full permissions to: C:\Program…
Pouya Barrach-Yousefi
  • 131
  • 4
3
votes
1 answer

What does SSRS technically do when it expires the cache?

Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a schedule - a schedule that is triggered at the…
JHFB
  • 2,874
  • 6
  • 39
  • 64
2
votes
1 answer

Are there limits to SSRS 2014 RDL files going over to SSRS 2008 (or 2012)?

Is there any incompatibility with reports developed in SQL Server SSRS 2014, and then exported to .RDL files that will be imported into SQL Server 2008?
Chris Adragna
  • 351
  • 4
  • 14
2
votes
0 answers

How to Configure SSRS Web Service Port via Command Line

It is straightforward to change the TCP port of SSRS using the GUI (Reporting Services Configuration Manager) but I am trying to fully script the installation and config of our SSRS servers. Is it possible to change the TCP port of the SSRS web…
Shoeless
  • 407
  • 1
  • 4
  • 14
2
votes
0 answers

In-Place SSRS 2014 to 2016 Upgrade Failed. Cannot start new SSRS 2016 instance

We have a SQL server 2014 and SSRS 2014 instance set up on two different 2012 R2 servers. This has been our setup for years, and everything has worked fine. We did an in place upgrade of the SQL server from 2014 to 2016 with no issues, but when I…
KayZak
  • 21
  • 1
2
votes
0 answers

Reporting Services Printing Issue

Whenever we apply a patch (recently with CU5), end users need are prompted for administrator credentials to print. In googling, I see many different suggestions, but nothing seems to work. I have tried adding the SSRS server to the trusted sites…
Wes
  • 1,126
  • 1
  • 10
  • 31
2
votes
1 answer

SSRS : Bug using SSL (https://)

We have an SSRS 2014 already in production and we want now use a secure site by linking it to a certificate (URL like "https://..."). So now the URL is fully qualified domain name(FQDN). We can access correctly to the report manager with this https…
Yaroslav
  • 2,837
  • 4
  • 29
  • 41
2
votes
2 answers

Configuring SSIS,SSRS, and SQL Server - three server model

I have a requirement for a third party vendor application which requires SSIS and SSRS. The vendor had suggested this 3 server model, and my management is going ahead with the same. Three VMs are being provisioned, one each for SQL Server, SSIS, and…
buddinggeek
  • 623
  • 4
  • 24
2
votes
2 answers

SSRS 2014 - query running fine on management studio - report timing out - how to troubleshoot?

I had a problem in reporting services 2014 - all the queries in a report were running fine from management studio but timing out when running the report. here is the message from the user: what to do to troubleshoot a SSRS 2014 report that gets…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
2
votes
1 answer

Can mirroring be used to upgrade SSRS?

Can you use mirroring to upgrade SSRS? For instance, I've upgraded from SQL 2005 to SQL 2014 with mirroring. SSRS is running on the same box as my database server. I'm going from SQL 2012 (11.0.5343) to 2014 SP1. I was hoping to get info from the…
AKDiscer
  • 1,395
  • 6
  • 28
  • 40
2
votes
1 answer

Use Group Managed Service Account for SSRS

We have a production environment running SQL Reporting Services 2014. The service is running as a group managed service account domain\SSRSProdSvc$ We are now trying to change our test environment to use managed service accounts for SSRS, however I…
Greg
  • 3,292
  • 5
  • 33
  • 57
2
votes
1 answer

Loading subscription slow in SSRS

I have a SQL Server 2014 test box with SSRS installed. The site loads ok and reports are quick. When I try to go to Subscribe the page takes over a minute to load. From there if I pick a schedule it also takes minutes to load. This is a fresh box…
SQLChao
  • 403
  • 4
  • 13
1
vote
0 answers

SSRS 2014 Report parts and Subreports redirects to http: instead of https:

I am looking to find a solution for the SSRS 2014 server redirects to http url instead of https for all the subreports and other report parts like subscription , security , datasources etc .  What I have done so far On the rsreportserver config…
divyasridhar
  • 11
  • 1
1
vote
2 answers

Reporting Services Database on different version

Just wondering if anyone has come across this scenario and can provide some advice. We have a vendor application that only runs on SQL Server Reporting Services 2014. However, all of our other applications support SQL Server 2017. Can I setup SSRS…
philcart
  • 51
  • 5
1
2 3