Questions tagged [ssrs-2019]
11 questions
4
votes
2 answers
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 multiple (named) instances of SSRS 2017 on the same…
MHeld
- 432
- 1
- 5
- 14
2
votes
0 answers
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 of the reports use an oracle data source, these…
Patrick
- 698
- 3
- 9
- 23
1
vote
0 answers
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 reasons, we have connections between user databases…
Hannah Vernon
- 70,928
- 22
- 177
- 323
1
vote
1 answer
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 instances on the same server, so I was wondering if it…
Gavin Harris
- 13
- 5
0
votes
0 answers
Authentication error when refreshing a SSRS 2019 report
We are encountering authentication issue when refreshing the report in SSRS 2019 web portal.
Report Server is configured to run using Virtual Service Account. In the RSReportServer.config file, RSWindowsNTLM authentication type is used.
The report…
jnesis
- 1
0
votes
0 answers
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,
c.DATE,
c.TITLE,
c.DESCRIPTION
FROM…
UK1539
- 25
- 5
0
votes
1 answer
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 the methods of defining the report path as…
0
votes
0 answers
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 test I also created a blank ReportServer and…
0
votes
0 answers
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 avoid porting thousands of reports and associated…
Ross Bush
- 683
- 1
- 5
- 18
0
votes
1 answer
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 to make it work? Any help is appreciated.
DRST
- 19
- 3
0
votes
1 answer
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’t change.
Sources
Server A – Has the database…
SQL_NoExpert
- 1,107
- 1
- 21
- 37