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
17 views

How to connect to Azure SQL database from SSRS using integrated authentication

Could you please share the steps or documentation links for configuring SSRS reports in an Azure virtual machine to Azure SQL database using Windows / network account? The Azure VM is domain joined ...
0
votes
1answer
59 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
0answers
8 views

SSRS - no layout after migration

I have tried migrating SSRS (SQL Server Reporting Services) to a new application server and database, but the web app on the new server no longer has any CSS (layout). BEFORE SSRS and database on ...
0
votes
1answer
45 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
0answers
184 views

SSRS - Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host

I have this error message: enter image description here It's intermittent and calls a SSRS report, now if I run the same product at the Server works properly. My environment is SQL Server 2017 under ...
0
votes
1answer
232 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
19 views

Where is v_GS_SoftwareUsageData

I am trying to write a custom report on SCCM which will query the metered software products. When I create a report using report builder I am connecting to the report server database instance. When ...
0
votes
0answers
66 views

Unable to Customize Copied SCCM Report Properties

I am running SCCM 1810 and have a reporting point installed on SQL 2012. Using Report Builder, I opened an existing report and save it to a different name. I then edited the description of the new ...
0
votes
0answers
185 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
93 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
266 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
149 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
28 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
1answer
676 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
49 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
338 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
154 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 ...
1
vote
0answers
393 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
3k 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
141 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
34 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
320 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
149 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
113 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
558 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
277 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
3k 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
6k 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
921 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
420 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
4k 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
235 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
42 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
177 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
530 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 ...
0
votes
1answer
6k 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
826 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
365 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
5k 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, ...
4
votes
6answers
12k 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
2k 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
650 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
244 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
656 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
8k 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
vote
0answers
566 views

Can SharePoint 2013 and Microsoft Dynamics GP 2013 run on the same server?

We have a new Windows 2012 server with SQL Server 2012 and Microsoft Dynamics GP 2013 running on it. I have been asked to install SharePoint 2013 on this server also. I know GP 2013 now uses SSRS for ...
0
votes
2answers
3k views

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, ...

1
2 3 4 5