Error occurred during local report processing
Hi Experts, i am getting error while generating the report: I have used parameters like : and getting error as below screenshot The 'Value' expression for the query parameter '?' contains an error: Overload resolution failed because…
Critical Error for SharePoint_Config Database
Hi, I searched all forums for three days but can't find the answer. These topics won't work : Answer 1 Answer 2 Answer 3 The server returns this critical error: SQL database login for 'SharePoint_Config' on instance 'ServerSql' failed.…
How to create a Database for Power BI Report Server
Hi All, I am using SQL Server 2022 with Windows Authentication. I have downloaded the Power BI Report Service instance on my machine. I am trying to create a new database using the Report Server Configuration Manager. As Service Account, I have…
Where and how do I add the SQL license key when SQL server reporting services expire
Our SQL 2022 reporting services stopped working. We figured out it had expired, and I must add the SQL license key. I need to know the process of adding the license key to SQL reporting services.
How to install Reporting Services in an Azure SQL VM
Hello, I have an Azure SQL VM and i need to install SQL Reporting Services. I downloaded the setup but it asking for a serial number that i don't have. How do i know the serial number of SQL to insert in the instalation process? Or there is another way…
SCCM 2012 sql query
Need assistance to pull a report that can provide the asset name, domain, username, product, warranty, cpu, total size HDD, free disk space, OS,
Ssrs server changes nls language randomly.
Hi, I have a very stramge issue every now and then the server decides to change the languade settings for my oracle datasource. Nothing happens on the oracle database. The issue happens and my datasource that notmally works fine swaps to Czech or Brasil…
Identifying Unused Tables in AAS Cube Over the Last 30 Days
I have a question regarding identifying unused tables in Azure Analysis Services (AAS). In our organization, we’re using AAS, and due to limited storage, our cube refresh is failing. I’ve been tasked with finding a list of tables that haven’t been used…
SQL Server Reporting services 2019 Slow on new server
Moving SSRS from Windows Server 2016 to new Windows Server 2019. Looking at the XML from ExecutionLog3 (Below). Connections take around 20 seconds before it moves on to actually running the report, instant on 2016 server. Testing data sources takes…
VS Version 17.11.5 - SSRS report RDLs open BLANK
Hello, Version 17.11.5 - SSRS report RDLs open BLANK I have submitted this from VS but have not received any help. It gets set to Triaged or marked as a duplicate and I have not heard back. I am a tad surprised this is not a widespread issue because…
Can SSRS cached shared-datasets be accessed from backend database table?
Is the cached dataset available inside the SSRS TempDB or anywhere in the database? This way, the cached SSRS datasets can be accesssed from backend DB, instead of web portal So need only to execute 1-time DB query, and subsequent accesses will be from…
How to download Sql Server Configuration Manager
Hello, BRAND NEW to SQL Server. I was following along with a tutorial and downloaded the SSMS, however, doesn't seem like i have the configuration manager installed properly. I tried entering the credentials first prompted once SSMS was done…
SSRS 15.0.8760.20928 causes errors in data driven subscriptions
My Server SSRS 2019 was upgraded with a windows update to version 15.0.8760.20928 The SSRS Wed looks completely different, but that's OK (I don't like the new look but that's just me :)) I tried to change a Data driven subscription, and I get the below…
Using Temporary Tables and Re-Using Temporary Tables in a SSRS Report
So we need to standardize Member Eligibility by using a SQL Server Stored Procedure that will be called, Executed by our Patient/Member SSRS Reports. The SQL Server Stored Procedure currently uses a Global Temporary Table to pass its result set back to…
How to Connect Microsoft Report Builder with Apache Druid?
Iam Trying to connect with my Microsoft Report Builder with Apache Druid, Is any roadmap to follow or step and any alternative solutions with any tools that i require to connect them is avalilable then please ping me
Running RDL results in System Out Of Memory Error
I'm running SSRS on SQL Server 2016. I'm using Visual Studio 2017 for development (these versions are both restrictions from my company). When running a particular report (RDL) I'm getting the following error. Before I go to my IT department, I just want…
Unable to send scheduled email using the SSRS - Report Server error
Had setup the email configuration for a report to auto schedule email due to some error unable to move forward, have tried with everything - are we missing something here? Does this Guide is enough from the Stackoverflow forum in anyway? or else any…
Unable to install sql server 2022 express on my Personal laptop. Could you please help with it? Iam struggling here. Any amount of help is appreciated
The following is the message i see in my log file Overall summary: Final result: Failed: see details below Exit code (Decimal): -2147467259 Start time: 2024-10-31 14:13:52 End time: …
Does SQL Server Reporting Services 2019 (Enterprise Ed or Dev Ed) really still support mobile reports?
A colleague and I have stumbled across something confusing regarding SSRS 2019 Ent Ed. According to the MS site, mobile reports are still supported in 2019, see: SQL Server Reporting Services features supported by editions - SQL Server Reporting…
Powebi license
HIf i want to publish my ssrs report to powerbi service, Which lisence should i pay for?