Skip to main content

Questions tagged [ssrs-2019]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
24 views

SSRS scale-out deployment, adding third AG replica

We have two SQL Server 2019 Enterprise instances each running on Windows Server 2022 Standard (let’s call them DB01 and DB02). We have two SSRS servers (RS01 and RS02) each running SSRS 2019. They’re ...
S M's user avatar
  • 196
0 votes
0 answers
66 views

Using results from query as stored procedure parameters and combining results

I have a standard select query which returns a set of results :- SELECT c.CASEID, c.Event, c.ACTION, c.CYCLE, c.PROPERTYTYPE, c.COUNTRYCODE, c.STATUSCODE, c.CRITERIA, ...
UK1539's user avatar
  • 25
1 vote
0 answers
54 views

Automatically reconfigure SQL Server Reporting Services to connect to primary Availability Group node after failover

I have a SQL Server Availability Group for HA and a Distributed Availability Group for DR. I also have SQL Server Reporting Services running on all Availability Group nodes. For various historical ...
Hannah Vernon's user avatar
  • 70.1k
0 votes
1 answer
85 views

SSRS report filepath parameters

I'm trying to migrate reports over to a new SSRS 2019 server and one particular report gets called from an excel macro where it reads in the contents of a file located at a given filepath. I've tried ...
Robert Weatherman's user avatar
0 votes
0 answers
395 views

SSRS Home Page Not Loading

Having issue with the SSRS Web Portal URL not loading. The Web Service URL loads (eventually) but not the Web Portal. I am upgrading from SSRS 2012 to 2019 and followed the steps found here. As a ...
TomM_BroadV's user avatar
1 vote
1 answer
743 views

Can you merge multiple SSRS instance databases to a new instance on 2019

I have a customer consolidating and upgrading two different SQL instances into a new 2019 cluster. Both of those older instances have an SSRS deployment on them. 2019 doesn't allow multiple SSRS ...
Gavin Harris's user avatar
0 votes
0 answers
29 views

2016 - 2019 - Wrong SSRS Instance Processing Report Render Request

I have inherited a very weird anomaly in SSRS. A new SSRS instance was created using 2019 and it appears it is using the same ReportServer DB as previous 2016 instance. This may have been done to ...
Ross Bush's user avatar
  • 505
0 votes
1 answer
402 views

SSRS2019 in IE11, icons are displayed as alphabets in Reportviewer

On Windows Server 2019,installed SSRS 2019 and configured in report server. when I previewing the reports, all icons will be rendered in capital letters .In server side, any settings need to changed ...
DRST's user avatar
  • 19
0 votes
1 answer
334 views

SSRS migration with Same Name and Moving of Reporting Files

This is will be my first SSRS migration and please bear with me if some points don’t make any sense. I need to migrate the Reporting server but need to keep the same name so that the reporting URL don’...
SQL_NoExpert's user avatar
  • 1,059
1 vote
0 answers
3k views

SSRS 2019 with an oracle data source

I am working on migrating a number of reports from an SSRS 2012 install to a SSRS 2019 install. These are all pretty simple and straight forward reports, built in microsoft report builder. A number ...
Patrick's user avatar
  • 678
4 votes
2 answers
5k views

SQL Server Reporting Services 2017: Multiple Instances

SQL Server Reporting Services are no longer part of the installation media since SQL Server 2017. They are delivered as a separate Installer. The new Installation Wizard gives no option to install ...
MHeld's user avatar
  • 402