Questions tagged [ssrs-2014]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
21 views

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 ...
1
vote
0answers
20 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 ...
2
votes
0answers
30 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 ...
1
vote
1answer
125 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 ...
0
votes
1answer
44 views

SSRS Label Orientation

I'm trying to print labels on a Zebra printer in SSRS 2014 and the orientation is coming out wrong. In report builder, I set the page size to 4.15 x 1.15 with correct margins. Also, in report builder, ...
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 ...
1
vote
0answers
320 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
1answer
312 views

SSRS bulk permission update 2008R2 to 2014

I'm moving SSRS reports from a 2008R2 server to a 2014 server. I've moved all the RDLs with a 3rd party tool only to find none of the permissions exist on the target. I'm attempting to copy the ...
2
votes
0answers
440 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 ...
0
votes
1answer
65 views

How to implement Sql Server 2016 mobile publisher on existing Report Server

Currently working on sql server 2014 (SSRS 2014) on window server 2012 R2. Requirement is to publish Sql Server mobile publisher report on report manager on SSRS 2014. I installed Sql Server 2016 ...
0
votes
1answer
549 views

SSRS Data Source enabled/disabled

This is completely lame that I cannot find it, so I have to ask. I know in the reportsmanager site where to enable and disable data sources. But where in the tables of the reporting database is this ...
0
votes
1answer
230 views

sp_whoisactive in SSRS

I have setup sp_whoisactive as a report in SS Reporting Services so people less familiar with SSMS can run it and see what is happening when needed. I have it working good and BUT I can't seem to ...
2
votes
0answers
167 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
2k views

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 ...
1
vote
0answers
1k 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
47 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
283 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 ...
2
votes
2answers
152 views

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

how to add a data source to SSRS - reporting services 2014?

For infomation as Create, Modify, and Delete Shared Data Sources (SSRS) but I want to get this done quickly, so when I have been requested to add a new data source to our reporting services: This is ...
2
votes
2answers
2k views

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

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

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....
2
votes
1answer
494 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 ...
1
vote
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 ...
2
votes
1answer
975 views

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?