Skip to main content

Questions tagged [ssrs-2019]

The tag has no usage guidance.

9 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
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
0 votes
0 answers
4 views

SSRS 2012 to SSRS 2019 upgrade with forms authentication

I have a client that is wanting to migrate to SQL 2019 from 2012. That upgrade path as you all know de couples SSRS from the SQL upgrade. The problem that I am having is that migrating the SSRS to ...
Mizmaul's user avatar
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
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
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
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
0 votes
1 answer
25 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