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
0answers
146 views

SQL Server Reporting Services error 2004, source PerfNet

SQL Server Reporting Services 2017 running on Windows Server 2016; the server is dedicated to SSRS, the actual SQL Server instance is elsewhere. SSRS is running as a domain user account. The SSRS ...
0
votes
1answer
22 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 ...
0
votes
2answers
62 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
0answers
54 views

SSRS Report date period field not working in iFrame

I've had to perform an in-place upgrade to a Windows 2008 R2 server -> 2012 R2 -> 2016 for reasons out of my control. The end result is actually quite stable from what I can see/tell but have a ...
0
votes
0answers
12 views

SSRS Server instances subscription service preferences

For SSRS, if you would have two server instances linked using scale-out deployment, why would server1 be heavily loaded and seems to handle all report subscriptions, while the server2 does not seem to ...
0
votes
1answer
35 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
1answer
248 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 ...
0
votes
1answer
249 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 ...
0
votes
1answer
88 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 ...
0
votes
1answer
468 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. ...
0
votes
0answers
263 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 ...
1
vote
2answers
235 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 ...
2
votes
0answers
543 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$. ...
2
votes
0answers
213 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 ...
0
votes
1answer
30 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 /...
0
votes
2answers
1k 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. ...
0
votes
0answers
58 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 ...
0
votes
0answers
2k 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-...
0
votes
1answer
446 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 ...
2
votes
0answers
167 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 ...
2
votes
0answers
551 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
1answer
4k 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: ...
0
votes
1answer
271 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 ...
1
vote
1answer
40 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 ...
0
votes
1answer
443 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 ...
0
votes
1answer
187 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. ...
0
votes
1answer
122 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 ...
0
votes
1answer
750 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 ...
0
votes
1answer
320 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 ...
9
votes
2answers
4k 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 ...
1
vote
2answers
7k 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 ...
1
vote
1answer
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 ...
1
vote
0answers
438 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 ...
2
votes
1answer
6k 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 ...
0
votes
1answer
245 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 ...
1
vote
1answer
3k 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 ...
1
vote
0answers
49 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 ...
0
votes
0answers
191 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 ...
2
votes
0answers
577 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 ...
1
vote
1answer
7k 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 ...
0
votes
1answer
862 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
vote
0answers
369 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 ...
0
votes
2answers
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, ...
5
votes
6answers
15k 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 ...
0
votes
1answer
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 ...
1
vote
1answer
740 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 ...
0
votes
1answer
257 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 ...
0
votes
1answer
680 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 ...
2
votes
1answer
3k views

Wildcard Domain with Google Analytics

Each user on our website has their own subdomain (e.g. bob.example.com, elephant.example.com) and they get paid for the traffic that they send to this subdomain. How can I wire up Google Analytics so ...
0
votes
2answers
9k views

Install RSClientPrint for Reporting Services 2012 using .bat file and still be able to use 2005

I have a Reporting Services 2005 server that when users accessed it and tried to print reports would get a message asking them to install the print control, which they could not do because of lack of ...

1
2 3 4 5