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
SQL Server Express 2025 Fails to install
The current SQL Server Express 2025 comes up with a "Missing DLL. Contact you software supplier." message (twice) on a brand new Windows 11 PC. It does not tell you what DLL is missing. This download was taken right off of the Microsoft site.…
SQL Server | Other
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
SQL Server 2025 Installation Error
SQL Server 2025 Enterprise Developer Edition Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed command line help.
SQL Server Database Engine
Investigate Root Cause of DBCC CHECKDB error | (SQLSTATE 42000)(Error 8992 | Catalog Msg 3853)
Details: I am running Microsoft SQL Server 2022 I am running DBCC CHECKDB on a user database (of which raised this error), each saturday This has happened on one on-prem Windows Server with installation of SQL server, with a predefined set of…
SQL Server Database Engine
Can 'Always On Availability Groups' be used in Microsoft 5 server Work Group instead of a Domain?
Currently running a 5 server (all windows server 2022 ) workgroup with 2 servers running Microsoft SQL server 2022 with Mirroring with a 3rd server as the Witness. As mirroring is being deprecated in later versions of SQL Server we are being advised to…
SQL Server | Other
My SQL Server Services getting stopped automatically
Dear Community, As I have experienced that one of my client system SQL services getting stopped automatically. After rebooting the windows that service not getting started, I have to start the SQL server services manually. Can you guys please suggest me…
SQL Server | Other
How to fix this error with rxInstallPackages
I have installed the Machine Learning services on Microsoft SQL Server 2022 (RTM-GDR) (KB5068407) - 16.0.1160.1 (X64) Oct 3 2025 18:06:58 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build…
SQL Server Database Engine
SQL Configuration step issue in Ubuntu Instance
While configuring SQL Server for the first time on Ubuntu_22.04-x86_64-SQL_2022_Standard-2025.08.28, I encountered an error that occurs frequently. I need to retry the setup 2–3 times before it works properly. Any Solution to fix this part? ++ bash -c…
SQL Server Database Engine
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
DBCC CHECKDB on Secondary Replica
I have an AlwaysOn AG. The secondary replica is set as readable. But, when i run DBCC CHECKDB on secondary replica, it is throwing below error: DBCC CHECK cannot proceed on database because it is a secondary replica and snapshot creation failed.…
SQL Server Database Engine
Connection pool error I am getting
Error: operation timed out for an unknown reason at /node_modules/tarn/dist/PendingOperation.js:14:27 This is the error I am getting when I login to my applicaiton. In very next attempt I am able to login properly. What could be the possible reason…
SQL Server Database Engine
SCOM - Alert Parameter Replacement Failure on monitor in Microsoft SQL Server on Windows (Monitoring) MP
I am seeing Alert Parameter Replacement Failure alerts on the Memory-Optimized Data Stale Checkpoint File Pairs Ratio monitor. This is in the Microsoft SQL Server on Windows (Monitoring) management pack authored by Microsoft. I have disabled the monitor…
SQL Server | Other
Does SQL server retain the setting for IDENTITY_INSERT after a session closes
I have set IDENTITY_INSERT ON for a table, does that setting remain after the session ends?
SQL Server Database Engine
SQL Server Developer
SQL Server Developer Editionについて教えてください。 ライセンスの数量、有償、無償範囲、 Enterprise EditionとDeveloper Edition違い、 Developer Editionの5年稼働における注意点、AWS EC2で利用の注意点、 サポートの違い また、以下の構成でSQLライセンスを購入予定ですが 何か留意点はございますか? 本番用:32 vCPUのEC2 → SQL Server Enterprise Edition…
SQL Server Database Engine
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few…
SQL Server Database Engine
SQL Server licensing with SA for Distributed Availability Group
I need help in understanding how many licenses I need specific to Distributed Availability Group solution below with Software Assurance benefits and purchased licenses. Region A: 3 Replicas with 2 read-write and 1 HA replica Region B: 3 Replicas with 2…
SQL Server | Other
Select most recent data per record from multiple tables
I am trying to get the latest data for a record from multiple tables. The issue I am running into is that the data on each table could have been modified at different times and each table may contain multiple rows per record. I am currently using row…
SQL Server | SQL Server Transact-SQL
SSMS 20.2 Import Wizard Throwing Error at Server End
I was trying to use the import wizard in SSMS and found that the destination servers was throwing the above error. The error that the server administrator has sent me is: "The EXECUTE permission was denied on the object…
SQL Server | Other
Is it possible to use Entra id authentication in SSMS 22 new migration tool?
I'm attempting to migrate an on-premise server to azure using the new built-in migration tool in SSMS 22. I'm only able to use Entra ID to authenticate into the Azure server, and when attempting to connect to the target server I don't see any option…