Questions tagged [ssrs]
Microsoft's SQL Server Reporting Services (SSRS), which provide "tools and services to help you create, deploy, and manage reports", usually querying MS SQL Server.
244
questions
-1
votes
1
answer
34
views
Are the results from Microsoft SSRS in real-time from SQL Server?
From my understanding MS SSRS is a data warehouse product. Its data is only as new as the last refresh. However, 3rd party support insists that SSRS results are in real-time.
If I am using a SQL ...
- 193
0
votes
0
answers
56
views
SSRS Sql Server Reporting Server Custom Security 2019 exception in Windows Server 2019
I am facing a problem with respect to SSRS(Sql Server Reporting Server) 2019 Custom security Exception in windows server 2019.
SSRS report works fine from winforms vb.net code in previous version of ...
0
votes
1
answer
294
views
SSRS 2019 - Report Builder TLS 1.2 error
I have 2 SSRS 2019 servers, and I'm using Report Builder 15 to connect to SSAS over an OLAP https connection. The connection works fine and I'll able to successfully build a report and get results ...
- 1
2
votes
2
answers
469
views
Sending SSRS reports to distribution groups
We have been using 'distribution groups' to send SSRS reports because they are easier to manage, but the reports are not being delivered when 'Senders inside and outside of my organization' is not ...
- 55
0
votes
0
answers
149
views
Sending email from SSRS using office365 mailbox Authentication issue
We have been sending scheduled reports from SSRS through Office365 Exchange. We are logging into a "DoNoReply" account using using SMTP basic auth. Since Microsoft is getting rid of SMTP ...
- 39
1
vote
1
answer
631
views
OpsMgr SDK Service Event ID 26219 - SCOM 2022
Every 5 minutes, the following log generates twice in the Operations Manager logs on the Management Server. It's definitely related to the reporting services. I uninstalled the reporting services ...
- 180
0
votes
1
answer
85
views
MSSQL reportserver behind web application firewall
Good Morning everyone!
First, please just point me in direction, where can I look into documentation.
I should get a consultant, but as a DBA, I want to solve this issue by myself.
Issue:
Management ...
- 1
0
votes
1
answer
132
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 ...
- 121
0
votes
2
answers
953
views
Reporting Services 2016: Cannot Edit or Upload RDL (Throws Exception and Memory Dump)
I have an SQL Reporting Services 2016 (13.0.5103.6) Standard native instance which won't let me edit Reports (RDLs) with Report Builder 15.0.19611.0 or upload them via the Reports portal, it throws an ...
- 1
0
votes
1
answer
892
views
SSRS 2019 not listening on IPv4 Ports, only iPv6
We installed SSRS 2019 on a Windows Server 2016 without any problems and configured it to use URLs with port 80.
Accessing those URLs (Service and Portal) via local browser works fine, but trying to ...
- 103
0
votes
1
answer
264
views
Configure SSRS to build reports using asp.net core app
I try to build the simplest report with SSRS via asp.net core application.
The asp.net core application has windows authentication, and I would like that any domain identified user could generate a ...
- 185
0
votes
2
answers
396
views
How do we install custom fonts on SSRS in AWS MS SQL hosted on RDS
We are using the new SSRS option on the AWS RDS, we have to install a custom font for a report that we are working on. I have checked the documentation and we notice that there is only option to ...
0
votes
1
answer
125
views
Recreate encryption Keys in MS-SQL RDS instance on AWS
We are running Microsoft SQL server Standard edition running on AWS RDS, We had recently upgraded from sqlserver-se version 14.00.3223.3.v1 to version 14.00.3281.6.v1 as per the recommendation. We had ...
0
votes
1
answer
1k
views
SQL Reporting Services email subscription configuration
I'm trying to configure a Microsoft SSRS 2014 server to send out emails. As far as I can tell all the settings are correct in RS Configuration Manager, and I can send an email from the server itself ...
- 13
0
votes
1
answer
343
views
SCCM - No Reports Available In The Reporting Section
I am trying to set up the Reporting feature in the SCCM Console (Version 1910) but I can't get anything to appear under the Reports tab - the text 'No Items Found' is displayed instead. I was able to ...
- 319
0
votes
1
answer
111
views
SQL Server Express Reporting Services is accesible from another server?
I am thinking of installing a Sql Server 2017 Express with Advanced Services.
All data will be stored in the local instance as well as the Reporting Services.
The question is if someone in another ...
- 141
0
votes
1
answer
796
views
Windows Memory Usage - Is something throttling available RAM
Can anyone tell by the images below if this machine is unnaturally throttling memory usage. The memory was upgraded from 32GB-64GB for SSRS report rendering, which is the only sizable process to run.
...
- 121
0
votes
0
answers
478
views
Configuring Second URL for Reporting Services to Respond on port 443
We have a web server hosting several websites.
DNS is configured to point ..com to the web server. One of the sites acts a proxy and redirects https requests
to a seperate SSRS server. We have a ...
- 595
1
vote
2
answers
559
views
SSRS shows blank page for 1 user
We have a ssrs portal for our clients. they use sonicwall to gain access to our network.
I have one external client/user that can access the vpn, but when he tries to hit the server he gets the ...
- 113
2
votes
0
answers
1k
views
Can I use a gMSA for stored credentials in a SSRS data source?
I have an instance of SQL Server 2016 Reporting Services service running under DOMAIN\reporting$ containing a data source that needs to query a database using the stored credential DOMAIN\database$. ...
- 1,271
2
votes
0
answers
256
views
Is it possible to limit SSRS authentication to Kerberos only?
We have an instance of SSRS (SQL Server Reporting Services) which uses Kerberos Constrained Delegation to fetch data for its reports from SQL Server on behalf of its users.
For this purpose, SSRS was ...
- 155
0
votes
1
answer
54
views
Unable to upload reports to TFS 2018 Project Collection
I'm trying to add reports to my TFS 2018 installation following the tutorial here. When I get to the 'Upload reports to a team project' step, I execute the command
TFSConfig addprojectreports /...
- 101
0
votes
2
answers
3k
views
Where is this hidden computer name coming from?
Environment:
I am baking Amazon Machine Images with SQL Reporting Services (SSRS) installed. The Windows Server 2016 machine is joined to the domain and its computer name is changed AFTER install.
...
- 143
0
votes
0
answers
69
views
Run SQL Server Standard 2017 Edition Together with SSRS 2017 Developer Edition
Has anybody ever tried running SQL Server 2017 Standard with SSRS Developer Edition and had it worked successfully?
I'm setting up a client environment in Azure. This will be there production ...
- 668
0
votes
0
answers
3k
views
Configure SSRS remotely - A connection to the computer cannot be established
I just installed the newest SQL Server Reporting Services 2017 using this instructions:
https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/install-reporting-services?view=sql-...
- 101
0
votes
1
answer
979
views
SSRS saved data source prompting for credentials
I have a shared data source in SSRS (SQL 2016) that has Windows credentials saved. I can click on that data source, test connection, and it works fine. However, when I attempt to use that data source ...
- 3
2
votes
0
answers
206
views
Bizarre SQL SRS error when trying to access SCCM reporting reports
In case this is an X-Y problem, what I'm trying to do is grab logs from SQL Server Reporting Services to tell me who did a couple horrible things in our SCCM environment - 1) deploying a rather large ...
- 53.7k
2
votes
0
answers
765
views
Left with 0 client certificates to choose from when moving SSRS service to TLS 1.2
Environment:
Reporting Services running on a SQL Server 2008 R2 SP3 installation on a Windows 2008 server with .Net 4.6.1 installed and .Net 3.5 enabled as feature. IIS, database and reporting ...
1
vote
1
answer
6k
views
SSRS Prompting for credentials when using FQDN
I came across this issue because I'm writing a web application which uses SSRS reports and, after configuring our production SSRS server to use HTTPS we found that reports won't run (we get error 401: ...
- 113
0
votes
1
answer
301
views
Unable to get SSRS 2016 to send subscription emails
I'm having an issue with sending reports via email on SSRS 2016
So basically I have a VM on the Azure platform configured as an SQL server.
SQL01 (Windows 2012 Server)
+ SQL SERVER 2008 R2
+ SQL ...
- 151
1
vote
1
answer
47
views
Windows 2012 Server inaccessible (using rdp) but SQL Server databases are accessible (ssms)
We have a Windows Server 2012 Standard, which runs SQL Server 2012 Enterprise edition. This morning we found the reporting services was inaccessible. We attempted to use Remote Desktop to connect to ...
- 11
0
votes
1
answer
613
views
SSRS Subscription fails, Server Response 4.4.1
I have an SSRS server that processes many subscriptions on a daily basis. I have just become aware of this, so I don't know if it is a new or an old problem, but only one subscription has been ...
- 111
0
votes
1
answer
254
views
How do I grant Auth to an Application Pool to a seperate server
I have a WebServer running IIS, and hosting a number of Webservices.
I have a new requirement to allow a WebService (Currently running as AppPoolIdentity) to connect to SSRS on a seperate server.
...
- 123
0
votes
1
answer
167
views
Unable to login to stand alone SSRS 2012 from domain joined computers
We have a non-domain joined SQL 2012 server running in Azure supporting several web sites, earlier this week an issue popped up where domain joined computers could not log in. There were no updates or ...
- 874
0
votes
1
answer
1k
views
Which Reporting Services instance is using this ReportServer database?
I have a SQL server - call it A - which I need to decommission. One of the databases on it is ReportServer, so (presumably) there is somewhere a Reporting Services instance which is storing its ...
- 125
0
votes
1
answer
559
views
SQL Reporting Services 2016 - "Content Manager" predefined role not listed
When assigning system roles to users, I only see "System Administrator" and "System User". I need to add a user with "Content Manager" as a role but do not see this option. SQL Reporting Services 2016 ...
- 188
10
votes
2
answers
5k
views
SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers
Tl;Dr
I have a SQL Server instance (SQLSERVER01-i01) with a dedicated IP address and port (162.xxx.xxx.51:1433) on a multi-instance SQL Server (each SQL Server instance on the Windows Server has its ...
- 2,045
1
vote
2
answers
8k
views
SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'
After applying hotfix KB3194725 to our SQL server, the SSRS server throws the following exception when trying to generate a report:
Exception type: InvalidReportServerDatabaseException
...
- 111
1
vote
1
answer
1k
views
cannot do any operation on the ssrs manager
I have installed a named instance of sql server with reporting services (2016) on my local machine. But in the reporting service manager (the web portal) I cannot perform any operation*. My guess is ...
- 121
1
vote
1
answer
637
views
IIS slow in loading Report Viewer
We are running IIS & SSRS on the same production server and have two types of reports - one running through Report Viewer, connecting to SSRS (remote mode) and the other calling the SSRS web ...
- 11
2
votes
1
answer
9k
views
SQL Failover Cluster Clients not updating DNS
I have a multi-subnet SQL Server 2012 failover cluster running on 2 Windows 2012 R2 nodes. The cluster is located on 192.168.1.10 when on NODE A and 192.168.5.10 when running on NODE B. When I look at ...
- 41
0
votes
1
answer
319
views
SSRS 2012 ODBC Driver architecture mismatch on remote computer, works locally
I have an SSRS 2012 server (Windows 2012) with Ingres ODBC drivers installed, ODBC entries have been configured in the 32 bit (SysWOW64) ODBC manager. Reports ran locally on the server run without a ...
- 11
1
vote
1
answer
4k
views
Install "Microsoft Report Viewer" on Windows Server 2012 R2
I am attempting to install Microsoft Report Viewer (2015) on a web server.
The web server is a Windows Server 2012 R2 (x64) instance. The web server will be running a .NET application that uses the ...
- 121
1
vote
1
answer
182
views
How do I stop SSRS from sending any missed reports when starting the service?
We fired up a test SSRS service that hasn't run for a couple of months.
It appears that it has decided to send all reports where it has missed the schedule (so any report that didn't send since it was ...
- 1,627
0
votes
0
answers
201
views
Adding a default front page to Reporting Services 2014
I have installed SSRS 2014 on a server, and it works fine.
But when a client connects to the server on HTTP/HTTPS, they get a 404 unless they add /Reports to the url.
Is there some way I can add a ...
- 318
2
votes
0
answers
747
views
Constrained Delegation between IIS, SQL Server, SSRS and File System
First of all, not sure which site is best suited for this question be it SO, SF or SU so please feel free to suggest migration!
I have a requirement to constrain delegation between several machines ...
- 735
1
vote
1
answer
9k
views
401: Unauthorized when connecting to Reporting Services
Ok, so here's the layout:
We have our AppServer and our Database Server.
Our AppServer is trying to connect to our Database Server which has Sql Reporting Services on it. However they are different ...
user57862
0
votes
1
answer
923
views
SSRS Report fails with conversion error but runs fine in ssms?
I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then ...
- 1
1
vote
0
answers
375
views
SSRS Returning 401 Unauthorised Error when calling web service
We have two web servers that call the SSRS service to query the reports held there. Both servers are set up identically but while one works the other returns a 401 unauthorised exception when trying ...
- 111
0
votes
2
answers
7k
views
Why isn't sql server using all of the available memory
I Have SQL server 2012 standard 64bit with 64GB RAM and 40 CPU cores. In the server properties, I can see that all the RAM is listed in the memory field on the general tab. Underneath the Memory tab, ...
- 1,065