SSRS Going Away?
I was informed by my IT department that the next upgrade they are making to upgrade our SQL server will not be supporting SSRS. I couldn't find any information to back-up their claim from Microsoft's website, other than that in SQL Server 2022,…
SQL Server Reporting Services
SQL Server | Other
SSRS 2022 is working on https but not on http (503)
Hi Team, I have ssrs installed on standalone aws instance, i have https working for /Reports and /ReportServer both but http doesnt work, it starts working but then it stops i didnt change anything. EC2 instance is a standalone server with no…
SQL Server Reporting Services
Is there any better disaster recovery than Transactional Replication?
I am trying to implement Transactional replication on SQL Server 2016 from Prod server to Report server. But it is not carried lot of tables that doesn't have Primary keys and those tables are important too. Is there different disaster recovery tools…
SQL Server Reporting Services
How to fix An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset 'Work'. (rsErrorReadingNextDataRow) Transaction (Process ID 1461) was deadlocked on lock resources with another process and has
How do I fix the following error message? An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset 'Work'. (rsErrorReadingNextDataRow) Transaction (Process ID 1461) was deadlocked on lock…
SQL Server Reporting Services
Possible to host SQL server 2022 in AWS RDS as SSRS database?
Hello, I would like to know is that possible to host SSRS database sql server 2022 in AWS RDS? I trying to host SSRS in EC2 and SQL server in RDS then I use rds admin user to connect database on Configuration manager set up and getting this permission…
SQL Server Reporting Services
The login is from an untrusted domain and cannot be used with integrated authentication
Hi, After Windows patches on Dec 10th, all my SQL and Report servers login is failing with the error: "The login is from an untrusted domain and cannot be used with Integrated Authentication". The report server would be able to comunicate with…
SQL Server Reporting Services
SSRS REST API GetReportParameterDefinitions fails to populate ValidValues for dependent parameters
Product: SQL Server Reporting Services (SSRS) REST API v2.0 API Endpoint: /reports({id})/ParameterDefinitions Swagger Documentation: https://app.swaggerhub.com/apis/microsoft-rs/SSRS/2.0#/Reports/GetReportParameterDefinitions Issue Summary The SSRS REST…
SQL Server Reporting Services
Getting HttpException, Unable to validate data
I'm setting up brand new SSRS 2022 Reporting Services with custom (Forms) authentication. I followed instruction from here,…
SQL Server Reporting Services
Is there an offline installer for SSRS ? Need to install it in a production machine with SQL server and SSMS currently running on it ?
Hi Team, Is there an offline installer for SSRS ? Need to install it in a production machine with SQL server 2022 and SSMS 18 currently running on it ? The link on MS download center only provides the installer which can't do the job as it requires…
SQL Server Reporting Services
WSUS on windows server 2022 _ Microsoft Reports viewer 2012 Requires
Hello, I have a problem with WSUS reports. I am running Windows Server 2022 with SQL Server Express 2022, and I am facing an issue where WSUS reports require Microsoft Report Viewer 2012. I downloaded the installation package from here:…
SQL Server Reporting Services
SQL Server Express 2022 software installation issuse
Hai Im Mohamed Ibrahim Im facing issuse of SQL Server Express 2022 software installation in Laptop Laptop condition and Specifications Hp Brand new laptop with window 11 pro, 12th generation,corei5 with 8GB RAM its not more than 2 years age Error pop…
SQL Server Reporting Services
Missing Branding tab
I cannot see Branding tab in Site Settings menu, I am running the latest SSRS which is >16.018 and I am running SQL standard edition 2022
SQL Server Reporting Services
When Subscribing to a Report via SSRS 2019 when a user select leave null as the value for a paramater it is reverting to the deault value after Save.
I recently migrated our reports from 2012 Reporting Services 2019 Have noticed an issue with a report that has a date/time parameter. The parameter has a default of today's date with an option to tick the Null box The report works fine and returns the…
SQL Server Reporting Services
Issue with SSRS Reports Portal after migration from 2016 to 2022
We have recently migrated from SSRS 2016 to SSRS 2022. The installation of SSRS 2022 has been done. ReportServer is working fine but Reports portal is throwing error "Exception: System.Web.HttpException (0x80004005): Unable to validate data."…
SQL Server Reporting Services
Why is run now not showing for SSRS subscriptions
I don't have the option to run now on my subscriptions.
SQL Server Reporting Services
where can I download report builder for mac or linux (arm 64)
I am looking for installation binary or the like. Even an APT or Cask command.
SQL Server Reporting Services
Catalog max connection pool size: 100
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise: a) Why this is being reported so frequently? b) Does it indicate the limit is being hit? c) If b is true, how can I increase…
SQL Server Reporting Services
Is there a changelog/release notes for MS Report Builder?
Is there a changelog/release notes for MS Report Builder? Note: This is not Power BI Report Builder. I couldn't find a separate forum for MS Report Builder, but knew that the product was associated with SSRS. FYI, the download link for the product I…
SQL Server Reporting Services
How to delete subscriptions in PowerBI RS
Hello, I have a user which has lot of subscription in PowerBI Report server. I want to delete all the subscriptions associate with this user. Please let me know how can i do it? Thanks
SQL Server Reporting Services
Following an upgrade KPI tiles have disappeared
Has anyone else had this issue version SQL2019 migrated to SQL2022