21,199 questions with SQL Server-related tags

Sort by: Updated
2 answers

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 Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,123 questions
asked 2025-12-22T16:18:33.1933333+00:00
Jauregui, Michelle R 0 Reputation points
answered 2025-12-22T17:21:08.7033333+00:00
Bruce (SqlWork.com) 82,146 Reputation points Volunteer Moderator
0 answers

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
asked 2025-12-22T16:37:34.3066667+00:00
Richard Stephens 0 Reputation points
commented 2025-12-22T16:50:05.3266667+00:00
Richard Stephens 0 Reputation points
2 answers

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 Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,123 questions
asked 2023-06-08T23:39:28.1966667+00:00
Blumberg, Jacob S 5 Reputation points
answered 2025-12-22T14:10:21.5933333+00:00
Mohan R 0 Reputation points
1 answer

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
asked 2025-12-19T13:15:23.24+00:00
Vijoy T Abraham 0 Reputation points
commented 2025-12-22T13:04:43.3033333+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-05-07T08:39:20.11+00:00
Lucas Bjorndal 0 Reputation points
recommended 2025-12-22T12:17:26.61+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
0 answers

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
asked 2025-12-22T12:14:41.9233333+00:00
PaulD 0 Reputation points
answered 2025-12-22T12:14:51.6533333+00:00
Q&A Assist
2 answers

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
asked 2025-12-18T09:33:08.6266667+00:00
Vishal Sharma-IT 0 Reputation points
commented 2025-12-22T10:57:31.1266667+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-16T09:18:18.59+00:00
Stephen Hayes 0 Reputation points
edited a comment 2025-12-22T10:44:56.1033333+00:00
Stephen Hayes 0 Reputation points
4 answers

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
asked 2025-12-04T05:16:29.8166667+00:00
Pratik Narottam Panchal 0 Reputation points
answered 2025-12-22T10:04:21.6733333+00:00
Pratik Narottam Panchal 0 Reputation points
1 answer

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
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,123 questions
asked 2025-12-18T13:43:13.5833333+00:00
Inga Minciuna 0 Reputation points
commented 2025-12-22T08:59:38.6033333+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-18T12:47:25.15+00:00
Chaitanya Kiran 821 Reputation points
commented 2025-12-22T08:56:21.68+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-18T03:44:01.12+00:00
Dvebrat Tripathi 0 Reputation points
commented 2025-12-22T08:53:14.7833333+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-17T21:41:34.68+00:00
West, Chelsea A 0 Reputation points
commented 2025-12-22T08:51:28.5266667+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-17T08:48:50.45+00:00
MichaelHorwell-4553 0 Reputation points
commented 2025-12-22T08:50:10.3433333+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-15T05:30:07.8033333+00:00
吉田明伸 0 Reputation points
commented 2025-12-22T08:45:33.6066667+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-12T12:06:09.9233333+00:00
Rajesh Kumar Yadav 20 Reputation points
commented 2025-12-22T08:44:22.18+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-11T19:27:28.0333333+00:00
VYAGHRESWARUDU KOTTURI 0 Reputation points
commented 2025-12-22T08:42:42.35+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-10T15:59:27.8+00:00
JamesHarsh-1587 0 Reputation points
commented 2025-12-22T08:37:53.4366667+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-10T14:34:02.6566667+00:00
Richard Williams 15 Reputation points
commented 2025-12-22T08:37:01.3066667+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator
1 answer

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…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
588 questions
asked 2025-12-09T14:53:39.7333333+00:00
Schmitt, Victor 0 Reputation points
commented 2025-12-22T08:35:53.64+00:00
Lakshmi Narayana Garikapati 735 Reputation points Microsoft External Staff Moderator