SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,742 questions
1 answer
Kerberos fails on AG Listener — only from cluster nodes, ticket not generated
Environment: SQL Server Always On AG on top of FCI, Windows Server cluster, domain-joined nodes. Problem: Connections to the AG listener always fall back to NTLM, but only when connecting from the cluster nodes themselves. From any other machine on the…
SQL Server | Other
asked 2026-05-22T15:33:45.5866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 34%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Giorgio
0
Reputation points
answered 2026-05-22T15:34:10.26+00:00
AI answer
1 answer
One of the answers was accepted by the question author.
transactional replication between non-domain servers
Hi all, I have two sql server database servers. These are on the same network but there is no domain server. Can I configure these servers for transactional replication ? I know this is possible but how? Any document do you have to do this? Any…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-04-24T11:40:43.4133333+00:00
yunus emre ISIK
281
Reputation points
accepted 2026-05-22T06:58:19.0433333+00:00
yunus emre ISIK
281
Reputation points
1 answer
SQL Server Cluster Sync Issue After Windows Patch KB5091157
I have an issue related to patching Windows Server 2025. After installing patch KB5091157, our Microsoft SQL Server cluster cannot sync. Details: What happened: The SQL cluster worked fine before the patch. After patching, the cluster will not sync. …
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-22T02:04:04.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 2%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIS%3C/text%3E%3C/svg%3E)
ITD-Sreng Channy
0
Reputation points
answered 2026-05-22T02:04:27.94+00:00
AI answer
1 answer
SQL DB not Found
Hi, I have created SQL Server with multiple SQL Database in it, but when I try to click the Database in the Azure Portal, it says Resource Not Found, I can connect to the same database in the SQL Server Management Studio, I have also tried getting the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2025-04-28T08:46:47.8233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 28.000000000000004%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shabir jan
21
Reputation points
answered 2026-05-22T00:38:35.4766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Deepesh Dhake
0
Reputation points
1 answer
Security rules violation exception when running subscriptions with SSRS Custom Authentication
I have implemented SSRS Custom Authentication using Microsoft.Samples.ReportingServices.CustomSecurity. Everything works correctly in SQL Server 2022 ReportServer- except for subscriptions. When I add new subscriptions and executed it, I get 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,159 questions
asked 2025-06-26T05:23:56.6233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 54%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SAi
10
Reputation points
answered 2026-05-21T17:09:28.23+00:00
Deepesh Dhake
0
Reputation points
2 answers
Always on Group databases randomly changed to Not Synchronized
Hi Expert, Our organization has SQL Server 2022 Enterprise edition (version RTM-CU16 KB5048033) with enable Always On Availability Group feature was installed on Windows Server 2022 Server (65 bit) used for contain Sharepoint application databases It…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-08T09:29:31.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Urbel
585
Reputation points
edited an answer 2026-05-21T14:57:44.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 84%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vyas Kondreddi
0
Reputation points
3 answers
locking issue in MSSQL
Issue: the holdlock script has locking the multi-thread(10) insert/update We would like to revise the multi-thread script to from (HOLDLOCK) to (UPDLOCK, SERIALIZABLE) Original script: MERGE testtable WITH (HOLDLOCK) AS t USING (SELECT @P0 hjmpTS, @P1…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-20T07:28:48.0066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sam Chung
0
Reputation points
commented 2026-05-21T14:12:00.8866667+00:00
Deepesh Dhake
0
Reputation points
1 answer
Performance Degradation after moving from SQL 2019 to SQL 2025
I am in the processing of upgrading our SQL environment from 2019 to 2025. We are troubleshooting perf issues in our pre prod env right now before upgrading production and I have a fairly simple query that loads 1.6m rows to a temp table and typically…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-07T17:39:23.1566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 99%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mantini, Ronald M
6
Reputation points
commented 2026-05-20T15:29:17.04+00:00
Mantini, Ronald M
6
Reputation points
2 answers
We require clarification regarding Microsoft SQL Server 2025 licensing for our production environment.
Our current environment details are as follows: HCI Cluster Environment Two-node cluster setup Primary and Secondary SQL Server instances SQL Server configured in synchronous replication mode Secondary server intended for failover/disaster recovery…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,742 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 90%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
2 answers
Distribution Cleanup Job Failing Silently in SQL Server 2019 Transactional Replication Causing Distribution DB Growth to 1.5 TB
Hello All, We are facing an issue with SQL Server Transactional Replication where the Distribution Cleanup job has been failing silently, and the distribution database has grown to approximately 1.5 TB, causing severe disk space issues. Environment SQL…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,742 questions
asked 2026-05-16T08:14:26.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 81%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPN%3C/text%3E%3C/svg%3E)
Parag Nimbhore
5
Reputation points
commented 2026-05-20T11:14:39.32+00:00
Erland Sommarskog
134.1K
Reputation points MVP
Volunteer Moderator
2 answers
What is SQL error ID 8179 and how to fix it?
The customer often found NAV Server error at Event Viewer (Application log), Event ID 216, MicrosoftDynamicsNavServer$MBKNAV. It was NavSqlException, SQL error ID 8179 (“Could not find prepared statement with handle …”). This issue often occurs when…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
283 questions
asked 2026-02-18T02:58:30.2366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 86%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECT%3C/text%3E%3C/svg%3E)
Chirayu Traihirun
0
Reputation points
commented 2026-05-20T07:26:49.3133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 59%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWR%3C/text%3E%3C/svg%3E)
Watcharaphon Ruchiphong
0
Reputation points
1 answer
SSRS 2017 to 2022 migration users report that favorited linked reports disappear from the Browse tab
ISSUE: After SSRS 2017 to 2022 migration users report that favorited linked reports disappear from the Browse tab after page refresh, even though the favorite is still saved in the Favorites tab. When users try to re add the favorite - they get error:…
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,159 questions
asked 2026-05-15T10:15:41.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 69%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
RajeshKumar G
20
Reputation points
commented 2026-05-19T05:25:55.7066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Express ODBC Connection
Hi, I am trying to connect UPS WorldShip to a SQL server to pull shipping data. It keeps telling me the connection has failed, this is a replacement server, the old server still connects. I turned off the firewall on the server for testing, I…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,742 questions
asked 2026-05-13T11:23:01.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 39%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Brian Branco
0
Reputation points
commented 2026-05-19T05:13:37.3233333+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
1 answer
'Deny log on through Terminal Services' and 'Deny log on locally'to the domain service account that runs SQL Server AlwaysOn cluster
We are planning to apply Active Directory Group Policy settings — 'Deny log on through Terminal Services' and 'Deny log on locally' — to the domain service account that runs SQL Server cluster, SQL Server Always On services, and SQL Agent across our 16…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-12T12:20:15.79+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 80%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mona Seddik
20
Reputation points
commented 2026-05-19T05:11:27.3533333+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
2 answers
Facing issue in loading Report which contains Main and Sub report using Report builder in SSRS
we are working on SSRS Reporting using Report builder. we have a report which has a sub report in it which works well in Production Environment. The same report (RDL file) doesn't load anymore in QA Environment. after waiting 25-30 min, it shows error…
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,159 questions
asked 2026-05-08T07:20:52.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Madani, Ramya Krishna
0
Reputation points
commented 2026-05-19T05:08:31.52+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
1 answer
Claim space for TempDB on Sql Server
Dear Team, Dose Someone kindly advise how to shrink teamdb with effective way without affect Database Service ?
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-06T03:12:42.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 41%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Veasna Lay
0
Reputation points
commented 2026-05-19T05:07:48.7066667+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
1 answer
Mssql Log Shipping Requirement
I want to know about Mssql Log Shipping requirement to make it and the setup in details
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,742 questions
asked 2026-05-04T02:05:32.8966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
David Prodata
80
Reputation points
commented 2026-05-19T05:06:17.77+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
1 answer
sql server migration assistance oracle - accidently select always "words" while creating report. Need a report in HTML
accidently select always "words" while creating report. I need to create report in HTML How to reset this feature
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.
606 questions
asked 2026-05-02T17:40:15.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHB%3C/text%3E%3C/svg%3E)
Hussain, Baqir
0
Reputation points
commented 2026-05-19T05:05:32.07+00:00
Lakshmi Narayana Garikapati
1,315
Reputation points Microsoft External Staff
Moderator
0 answers
SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)
Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…
SQL Server | Other
SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
14,742 questions
asked 2026-04-29T12:20:04.25+00:00
Parag Nimbhore
5
Reputation points
commented 2026-05-18T20:48:34.8733333+00:00
Erland Sommarskog
134.1K
Reputation points MVP
Volunteer Moderator
2 answers
Stored Procedure running longer hours
Hello, I am facing currently issue as stored procedure running very longer hours although my DB is not that big means around 20 GB. We are also running OLA's maintenance solution for Update Stats Daily and Index maintenance weekly basis. Stored procedure…
SQL Server | SQL Server Transact-SQL
SQL Server | SQL Server Transact-SQL
Programming language used to interact with SQL Server databases
283 questions
asked 2026-03-21T16:55:37.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pdsqsql
436
Reputation points
commented 2026-05-18T05:14:52.69+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anjan Kumar Chippa (Quadrant Resource LLC)
0
Reputation points Microsoft External Staff
Moderator