Questions tagged [ssrs-2014]

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

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
22 views

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, ...
2
votes
0answers
119 views

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 ...
2
votes
0answers
493 views

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 ...
2
votes
0answers
192 views

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 ...
2
votes
1answer
623 views

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 ...
2
votes
1answer
2k views

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 ...
2
votes
1answer
1k views

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 ...
1
vote
0answers
24 views

SSRS: Oracle Data Sources Breaking After Server Updates\Restart

Our SSRS instance has several Shared Data Sources that hit Oracle databases. Whenever we do patching or the server restarts, these Data Sources seem to break. Any reports hitting them come up with the ...
1
vote
1answer
193 views

SSRS Reports Blank on Zebra Printer

I need assistance getting labels to print from SSRS 2014 to a Zebra GK420D direct thermal label printer. The labels show up when running the report but when I print them to the label printer, all that ...
1
vote
0answers
423 views

Collation Conflict when patching SSRS

We recently upgraded our test database servers from SQL 2014 SP2 CU3 to 2014 SP2 CU10. Most of the servers are fine, but on 2 of them we are getting the following error when connecting to the ...
1
vote
0answers
2k views

SS Reporting Services Issue

I am getting below issues while accessing SSRS. Can anyone let me know if you have faced this issue before. The RSReportServer.config file has been modified. Report ServerWindows Service (...
1
vote
0answers
1k views

Changing row colour based on a group toggle - SSRS 2014

One of the tables in my report looks somewhat like: Row Colour Total grey +Category white +Category white +Category white +Category white It's expandable to Row Colour Total ...
0
votes
0answers
18 views

Does SSRS report user needs database level permission?

I have a separate reporting server and a separate database server. Now on the Reporting server site settings I could see there are some roles and users. Suppose a User BOB has ‘POWER USER’ role ...
0
votes
1answer
30 views

SSRS 2014 Exec Log gives the Service Account as UserName instead of Actual User name

I am using the below query for accessing the Users who are using the Application Reports. SSRS 2014 gives the Service Account(IIS Account used for Application) as User Name instead of Actual User ...
0
votes
0answers
49 views

Identify ssis packages that call ssrs reports

We are migrating our SSRS reports server database from SQL SERVER 2008 R2 to SQL SERVER 2014 and as I understand it this means all SSRS reports will receive a new id. Hence any SSIS packages that ...
0
votes
1answer
300 views

SSRS 2008 to 2014 Migration Excel Export error

We are working on migrating our SSRS from SQL Server 2008 to SQL Server 2014. After brining the reports over I have a set of reports that will execute just fine but when I try to perform a standard ...