SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
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
asked 2026-04-24T11:40:43.4133333+00:00
yunus emre ISIK
261
Reputation points
accepted 2026-05-22T06:58:19.0433333+00:00
yunus emre ISIK
261
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
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
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
![](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
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
SQL Server 2022 Express installation error -2061893606 and service error 1067
Hello, I have a problem installing Microsoft SQL Server 2022 Express for EBP Gestion Commerciale ELITE 2025. Errors: Error -2061893606 SQL Server service (EBP) cannot start Error 1067 Shared Memory Provider, error: 40 What I already tried: …
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-14T10:18:59.6533333+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(172.8, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Youssef Maach
0
Reputation points
commented 2026-05-14T12:04:35.8933333+00:00
Erland Sommarskog
134.1K
Reputation points MVP
Volunteer Moderator
2 answers
how to fix physica; sector size when PC has m.2 drives
LargeSectorSizeCheck Checks whether any disk intended for SQL Server data has a physical sector size greater than 4 KB, which is currently unsupported. Warning One or more disks intended for SQL Server data have a physical sector size greater than 4 KB.…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-12T11:49:12.42+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(124.80000000000001, 41%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Peterson Gideon
0
Reputation points
commented 2026-05-14T09:53:58.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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
2 answers
The long running select statement blocked the insert/update statement
The long running select statement blocked the insert/update statement execution Scenario: We have the multi-thread batch insertion logic to insert data to MSSQL database. When the insertion logic was executed, some users execute a long running select…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-08T06:42:51.8466667+00:00
Sam Chung
0
Reputation points
commented 2026-05-13T07:28:58.6+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
2 answers
Sql Server 2025 Updated Application working Slow
Application have been running really slowly since upgrading the database to SQL Server 2025.
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-07T07:36:42.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(310.4, 8%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ab Malik
0
Reputation points
commented 2026-05-13T06:54:38.02+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
3 answers
how to sucessfully connect sql Smm server profile to database engine?
i tried connecting sql 2025 model of server profiler 22 in my system of DESKTOP-UL2OACD BUT its showing TITLE: Connect to Server Cannot connect to DESKTOP-UL2OACD\iwunor kelechi. ADDITIONAL INFORMATION: A network-related or instance-specific error…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-02T14:05:18.68+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(288, 60%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
Iwunor kelechi
0
Reputation points
commented 2026-05-13T06:37:14.9466667+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
1 answer
SQL Server Audit / Extended Events – Role‑based (sysadmin) filtering limitations
Hello Microsoft Team, We are implementing security monitoring for sysadmin account usage on an on‑premises SQL Server instance and would like to know what EX events or Audit to achieve our goal? We tried Audit and XE events but those are capturing all…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-04-24T17:19:09.7+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(44.800000000000004, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uday Paleti
5
Reputation points
commented 2026-05-12T08:06:20.21+00:00
Akhil Gajavelly
1,820
Reputation points Microsoft External Staff
Moderator
3 answers
To Implement HA strategy require licensing Cost
HI Team, We are planning to implement SQL Server 2025 Enterprise Edition with Always On HA and would like to understand the complete licensing cost, including per-core pricing details. Could you please assist with this? Thanks Sadiq
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-05-05T10:06:08.2233333+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(249.60000000000002, 84%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sadiq Ali
0
Reputation points
commented 2026-05-08T12:10:43.25+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
2 answers
I am unable to connect on the SQL server
I've already contacted Windows support and they are only have limited resources and only found out the root cause of the issue. They said that the SSMS has an error means that the client tried to establish an encrypted connection, but the SSL cetificate…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-03-24T07:30:12.73+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(198.4, 45%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sakthi N
0
Reputation points
commented 2026-05-08T05:45:09.4733333+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, 40%, 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)
Somil Jain
660
Reputation points
2 answers
Microsoft Partner Information
Dear Team, There is a Procurement of SQL Server 2025 Licenses is under process in our Organization. My question is regrading the Ressler partner of Microsoft that How much time the following Organizations are Microsoft reseller Partners?. Pakistan…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-02-23T09:48:54.5466667+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(105.60000000000001, 89%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahmed Ali - Assistant Director (IT)
1
Reputation point
recommended 2026-05-08T05:30:02.14+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, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
1 answer
Broken upgrade from SQL Server 2017 to 2022
Hello, SQL Upgrade was started at 2026-02-08 17:52:04. End time was logged as 2026-02-08 17:52:15 with final result "Pending". But in the Detail.txt file I see that last log entry is about 18:10. How can I recognize what is the reason of the…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-02-17T15:19:23.0733333+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(144, 27%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michał Lis
0
Reputation points
recommended 2026-05-08T05:29:20.8666667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
4 answers
MSDASQL ODBC queries to Linked Servers hang with no response after a couple weeks.
Hi all, Our current setup is a linked server to NetSuite ODBC using MSDASQL 17 as the provider. Everything works and runs fine and fast for about 2 weeks. Then the error will occur. There will be no error message or anything, but the query just…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-02-05T18:29:07.92+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(230.39999999999998, 40%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Ted
0
Reputation points
recommended 2026-05-08T05:28:20.28+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator
3 answers
SQL server generating different query_id for same query_text_id after mirroring failover
I am facing a strange problem with one of my SQL Server 2017 Clusters. I faced a query regression in the past and forced a known good plan for that query_id in query store. When the planned database failover happens every month for OS patching from HostA…
SQL Server Database Engine
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
706 questions
asked 2026-01-30T13:50:19.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(134.4, 13%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
udhayan d
181
Reputation points
recommended 2026-05-08T05:09:57.1533333+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator