2022 Developer Survey is open! Take survey.

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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
23 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 ...
user avatar
  • 1
0 votes
1 answer
12 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 ...
user avatar
  • 111
0 votes
0 answers
27 views

Can't login to SSRS (SQL Server Reporting Services) using SSMS (SQL Server Management Studio)

I'm having an issue logging on to my reporting server via SSMS. I use the same hostname\instance found in the reporting server config GUI at the top. This used to work, but I have made some changes ...
user avatar
0 votes
1 answer
151 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 ...
user avatar
  • 1
0 votes
1 answer
355 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 ...
user avatar
  • 103
0 votes
1 answer
152 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 ...
user avatar
  • 185
0 votes
2 answers
185 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 ...
user avatar
0 votes
1 answer
66 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 ...
user avatar
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 ...
user avatar
  • 13
0 votes
1 answer
301 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 ...
user avatar
  • 309
0 votes
1 answer
97 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 ...
user avatar
  • 141
0 votes
1 answer
617 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. ...
user avatar
  • 111
0 votes
0 answers
366 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 ...
user avatar
1 vote
2 answers
358 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 ...
user avatar
  • 113
2 votes
0 answers
870 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$. ...
user avatar
  • 1,261
2 votes
0 answers
236 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 ...
user avatar
0 votes
1 answer
37 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 /...
user avatar
  • 101
0 votes
2 answers
2k 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. ...
user avatar
0 votes
0 answers
64 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 ...
user avatar
  • 578
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-...
user avatar
  • 101
0 votes
1 answer
695 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 ...
user avatar
  • 3
2 votes
0 answers
194 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 ...
user avatar
  • 53.2k
2 votes
0 answers
648 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 ...
user avatar
1 vote
1 answer
5k 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: ...
user avatar
0 votes
1 answer
285 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 ...
user avatar
  • 151
1 vote
1 answer
43 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 ...
user avatar
  • 11
0 votes
1 answer
556 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 ...
user avatar
0 votes
1 answer
206 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. ...
user avatar
  • 123
0 votes
1 answer
127 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 ...
user avatar
  • 874
0 votes
1 answer
976 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 ...
user avatar
  • 125
0 votes
1 answer
438 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 ...
user avatar
9 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 ...
user avatar
  • 1,925
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 ...
user avatar
  • 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 ...
user avatar
1 vote
0 answers
486 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 ...
user avatar
2 votes
1 answer
8k 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 ...
user avatar
0 votes
1 answer
280 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 ...
user avatar
  • 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 ...
user avatar
  • 121
1 vote
1 answer
113 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 ...
user avatar
  • 1,507
0 votes
0 answers
197 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 ...
user avatar
2 votes
0 answers
668 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 ...
user avatar
  • 735
1 vote
1 answer
8k 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 ...
user avatar
0 votes
1 answer
896 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 ...
user avatar
1 vote
0 answers
373 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 ...
user avatar
0 votes
2 answers
6k 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, ...
user avatar
  • 1,055
5 votes
6 answers
17k views

Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"

When I launch the Kerberos Configuration Manager for SQL Server and try to connect to the local machine it's on, I am getting the error "Kerberos Configuration Manager for SQL Server error "unable to ...
user avatar
0 votes
1 answer
3k views

Sharepoint and SSRS report trust relationship ssl/tls secure channel remote certificate is invalid

I have no experience with sharepoint at all. but this is what I observed. I intermittently getting this error message on my sharepoint. could not establish trust relationship for the ssl/tls secure ...
user avatar
1 vote
1 answer
831 views

SSRS Failing with error on App_global.asax

Our SSRS server has started failing. The Logs are currently showing the following error: System.BadImageFormatException: Could not load file or assembly 'file:///C:\Program Files\Microsoft SQL ...
user avatar
0 votes
1 answer
278 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
user avatar
  • 1
0 votes
1 answer
708 views

Clustered instance - kerberos double hop woes

We've recently migrated our virtualised SQL databases to a bare metal solution in an active/active cluster. Everything is working great except SQL Reports. Ok, so a rundown of our setup here as it ...
user avatar

1
2 3 4 5