21,856 questions

Sort by: Updated
1 answer

SSRS retains old Windows username after account rename

Environment Details SQL Server Reporting Services: SQL Server 2022 SSRS Version: 16.0.1118.33 Operating System: Windows 11 Home Single Language SSRS Mode: Native Mode Authentication: RSWindowsNTLM Report Server URL: http://karesuneel/ReportServer Web…

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,192 questions
asked 2026-11-04T19:03:29.2466667+00:00
Suneel Karem 0 Reputation points
answered 2026-11-04T19:05:45.54+00:00

AI answer

1 answer

SSRS Subscription Owner Identity Issue

Environment Details SQL Server Reporting Services: SQL Server 2022 SSRS Version: 16.0.1118.33 Operating System: Windows 11 Home Single Language SSRS Mode: Native Mode Authentication: RSWindowsNTLM Report Server URL: http://karemsuneel/ReportServer Web…

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,192 questions
asked 2026-11-03T22:10:24.5366667+00:00
Suneel Karem 0 Reputation points
edited the question 2026-11-04T18:54:06.99+00:00
Suneel Karem 0 Reputation points
1 answer

PBIRS Scheduled Refresh displays incorrect timestamp – one-hour discrepancy in LastRunTimeDescription

Product:Power BI Report Server (On-premises) Issue type: Technical / Break-fix Description: Following our recent server timezone configuration changes to use British Columbia local time, we noticed an inconsistency in the Scheduled Refresh timestamp…

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,192 questions
asked 2026-11-04T03:54:58.9+00:00
Karduri, Naveen 0 Reputation points
edited a comment 2026-11-04T15:45:12.9333333+00:00
Karduri, Naveen 0 Reputation points
2 answers

Master Data Services web app renders empty after SQL Server CU26 update

Hi everyone, SQL Server 2022 CU26 appears to break Master Data Services web application. After patching to CU26 (16.0.4265.3), the MDS web application loads, but is completely empty. The MDS database and data remain intact and are visible through SQL…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,831 questions
asked 2026-09-03T11:43:17.93+00:00
Simon Lenk 10 Reputation points
commented 2026-11-04T14:19:20.2033333+00:00
Simon Lenk 10 Reputation points
1 answer

SQL Server 2025 severe T-SQL WHILE loop performance regression

SQL Server 2025 - Severe T-SQL WHILE Loop Performance Regression We are experiencing severe performance degradation when executing basic procedural T-SQL code on SQL Server 2025. To isolate the issue from application logic, indexing, disk I/O, and query…

SQL Server
SQL Server

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

8 questions
asked 2026-10-29T12:38:36.3133333+00:00
Dražen Đurinić 0 Reputation points
commented 2026-11-04T13:35:41.2+00:00
Dražen Đurinić 0 Reputation points
2 answers

How can we reduce cross-region write latency in a legacy .NET 4.8 application with row-by-row SQL operations?

We have a legacy .NET Framework 4.8 application using C#, ADO.NET and SQL Server 2019/2022, deployed across multiple regions. We are evaluating SQL Server 2025 and other possible improvements to our application architecture. Our architecture consists…

SQL Server | SQL Server Transact-SQL
asked 2026-11-04T11:57:21.41+00:00
Rohan Mano 25 Reputation points
answered 2026-11-04T12:58:39.47+00:00
Erland Sommarskog 138.6K Reputation points MVP Volunteer Moderator
3 answers

In SQL server 2025 version dump files are created after reboot, After checking its showing bug in the software

***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\LOG\SQLDump0027.txt                                                                             SqlDumpExceptionHandler: Process 13 generated fatal exception…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,831 questions
asked 2026-10-29T06:47:27.0866667+00:00
Marugalla, Naresh (Ext) 0 Reputation points
commented 2026-11-02T16:29:47.3266667+00:00
Paul Thomas 80 Reputation points
3 answers

SQL Server 2022 — How can SHARED_TRANSACTION_WORKSPACE lock ownership be independently verified? We're valida

Subject: SQL Server 2022 — How can SHARED_TRANSACTION_WORKSPACE lock ownership be independently verified? We're validating an isolated synthetic database with a multi-session concurrency test. SQL Server reports a granted database shared lock with these…

SQL Server | SQL Server Transact-SQL
asked 2026-10-29T01:58:28.31+00:00
Russell Services 0 Reputation points
commented 2026-10-31T09:52:49.74+00:00
Erland Sommarskog 138.6K Reputation points MVP Volunteer Moderator
2 answers

CoPilot inside SSMS (not a Fabric databse)

from inside SSMs, what CoPilot assistance or options do I have Could I for instance, ask for a T-sql snippet to search through the current database table names for a given string?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,831 questions
asked 2026-10-30T18:46:27.3666667+00:00
Rose, Lance 0 Reputation points
answered 2026-10-30T22:20:52.6533333+00:00
Deepesh Dhake 1,325 Reputation points
1 answer

copy activity from sql server to adls gen2 parquet format , getting below error

ErrorCode=Unknown,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=An unknown error occurred.,Source=Microsoft.DataTransfer.Common,''Type=JNI.JavaExceptionCheckException,Message=Exception of type…

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,810 questions
asked 2026-10-30T18:54:31.6566667+00:00
Akshay Kanade 0 Reputation points
answered 2026-10-30T18:56:09.01+00:00

AI answer

2 answers

How to prevent auto-update of SQL Server 2025 Engine?

Hi. I am convinced of a JSON bug introduced somewhere between CU4 and CU6. I want to reinstall my instances so I can troubleshoot and then post the bug if it exists. I have repeatedly uninstalled my SQL Server 2025 instances. I have reinstalled 3 RTM…

SQL Server Database Engine
asked 2026-08-20T16:21:39.5566667+00:00
Jeff Foushee 96 Reputation points
commented 2026-10-30T16:05:19.6233333+00:00
Erland Sommarskog 138.6K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Licencing SQL Server 2025 in a Virtualised Environment

Ref: https://www.microsoft.com/licensing/guidance/SQL#section-56-840 Per your licencing guide in the linked page, you provide conflicting information on licencing SQL Server on a VM. Comparing the sections on virtualising SQL Server with the section on…

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,831 questions
asked 2026-10-30T11:46:01.2133333+00:00
Gavin Harris 20 Reputation points
accepted 2026-10-30T12:43:38.73+00:00
Gavin Harris 20 Reputation points
1 answer

PC|Access Issue|Access Denied – Unable to Load Folder Contents in Web Portal|AWS|UAI|PROD

I am trying to access a folder through the web portal, It is SQL Reporting Services. but I am getting the following error:   “Could not load folder contents. You are not allowed to view this folder. Contact your administrator to obtain the necessary…

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,192 questions
asked 2026-10-30T09:41:08.8166667+00:00
Gade, Mudita (GE Vernova) 0 Reputation points
answered 2026-10-30T09:42:03.9733333+00:00

AI answer

2 answers

How to install transactional replication when publisher is 2022, distributor is 2022, and subscriber is 2019.

How to install transactional replication when publisher is 2022, distributor is 2022, and subscriber is 2019. Publisher uses Always On Distributor uses Always On Subscriber uses Always On SQL Server service_account is different for publisher,…

SQL Server Database Engine
asked 2026-10-29T19:44:27.57+00:00
Hickson, Melvin 0 Reputation points
answered 2026-10-30T01:10:32.1133333+00:00
Deepesh Dhake 1,325 Reputation points
3 answers

SQLCLR scalar function spins on DIAG_OBJECT at high DOP: CPU per call 36 times higher at DOP 24 than at DOP 4

On SQL Server 2025 CU10 (17.0.5035.5, KB5125471, also seen on CU4), on Linux with 24 schedulers, a trivial SQLCLR scalar function called once per row in a parallel plan costs far more CPU per call as DOP rises, and the query is slower at DOP 24 than at…

SQL Server Database Engine
asked 2026-10-25T16:16:45.3366667+00:00
Brien Send 0 Reputation points
answered 2026-10-29T16:50:59.29+00:00
Deepesh Dhake 1,325 Reputation points
1 answer

Backup table gets extra ID from source table after SELECT INTO, no concurrent DML, RCSI enabled

SQL Server 2016 RTM (13.0.1601.5), RCSI enabled. When doing `INSERT INTO backup_table SELECT * FROM source_table`, the backup table contains an extra data that no longer exists in the source table. I have confirmed: - No open transactions at the time. -…

SQL Server
SQL Server

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

8 questions
asked 2026-10-28T02:58:44.1533333+00:00
旭姣 张 0 Reputation points
answered 2026-10-28T08:06:01.8966667+00:00
Erland Sommarskog 138.6K Reputation points MVP Volunteer Moderator
2 answers

firewall rule preventing user login

I have a sql database "LIMLdb" running on "apgsystems01" sql server running on a virtual machine. I need to be able to have my users log in from different locations. When they try the are assigned a new ip and cannot log in until I…

SQL Server Database Engine
asked 2026-09-30T16:28:53.53+00:00
orville wright 0 Reputation points
edited an answer 2026-10-27T16:26:07.43+00:00
Alison A 5,320 Reputation points Microsoft External Staff Admin
3 answers One of the answers was accepted by the question author.

what happens if the cloud witness is unreacheble for a two node cluster

Hi, first of all thank for all your incoming aswers. I'm trying to deploy a two node WSFC and then create a SQL Server Availability Group. The scenario is that in a building, there are two Datacenter and I installed a server in each datacenter. So the…

Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

14,831 questions
asked 2023-05-12T19:06:52.3466667+00:00
Angel Rendiles 20 Reputation points
commented 2026-10-27T15:40:35.0066667+00:00
Erland Sommarskog 138.6K Reputation points MVP Volunteer Moderator
2 answers

Unable to open exsiting packages in visual studio 2026

I m not able to open exsiting packages in visual studio 2026 i have installed everything

SQL Server Integration Services
SQL Server Integration Services

A Microsoft platform for building enterprise-level data integration and data transformations solutions.

2,810 questions
asked 2026-10-23T09:58:15.8066667+00:00
answered 2026-10-26T16:15:41.93+00:00
Yitzhak Khabinsky 27,196 Reputation points
2 answers

SQL Server 2022 - Why does a DELETE using a clustered index scan block on an uncommitted INSERT’s key lock when its predicate excludes that row?

I have a single-column table (Number, bigint, PK, clustered, unique) that is usually small (always under 5,000 rows, typically 1,000 or fewer). Service A frequently INSERTs rows inside long-running transactions. A row is inserted but not committed…

SQL Server Database Engine
asked 2026-10-22T22:05:10.6466667+00:00
Seth 0 Reputation points
commented 2026-10-26T14:21:00.4566667+00:00
Erland Sommarskog 138.6K Reputation points MVP Volunteer Moderator