Cannot create a connection to data source Error ...
In SQL Server 2008 in addition to the above two options you have a third option to make this setting through SQL Server Management Studio. 1.Start Management Studio and connect to …
The report server can’t connect to its database
Mar 30, 2018 · System administrators: The report server can’t connect to its database because it doesn’t have permission to do so. Use Reporting Services Configuration Manager to update …
performance - Fast query runs slow in SSRS - Stack Overflow
SQL Server was producing a convoluted execution plan when executed from the SSRS report due to 'parameter sniffing'. The workaround was to declare variables inside of the stored procedure …
sql server - SSRS - Unable to connect to datasource - Stack Overflow
Aug 13, 2020 · Context: I have an installation of SQL Server 2019 installed on my local workstation and within an SSRS Report Project I'm trying to create a dataset that connects to …
Could not load folder contents - SSRS Report Manager
Oct 6, 2016 · The solution is: 1- Browse the Report Manager URL 2- Top right of the page/ Manage folder / Add group or user 3- An important point is that in Group or user, you have to …
sql server - Get size of all tables in database - Stack Overflow
Oct 25, 2011 · 797 If you are using SQL Server Management Studio (SSMS), instead of running a query (which in my case returned duplicate rows) you can run a standard report. Right click on …
SSRS Subscriptions - How to view ALL report recipients
Sep 23, 2013 · I've written an SSRS report to help me keep track of SSRS subscriptions. I've repurposed a script that will use Reportserver.dbo.Subscriptions.LastStatus to view email …
SQL Server - SSRS - Where to find query generating the report
Feb 18, 2011 · The guy who created all the reporting using SSRS has left, and I am trying to troubleshoot one of the reports being generated. How do I get access to look at the query that …
sql server - Download all SSRS reports - Stack Overflow
Oct 17, 2017 · I want to get a copy of all .rdl files in one server. I can do the download manually one report at the time, but this is time consuming especially that this server has around 1500 …
Query to get list of all SSRS Subscriptions with parameters
15 I've be searching and trying for hours to get a query that gives me all current subscriptions from an SSRS serv with parameters and their values, so that they can be recreated on a new …