266 questions
1 answer
Why doesn't Entra work on FCI (on-prem) and what workaround is available (and not other 3rd party providers)
Why doesn't Entra work on FCI (on-prem) and what workaround is available (and not other 3rd party providers)
SQL Server Database Engine
asked 2025-05-29T17:08:05.3766667+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(214.4, 5%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFP%3C/text%3E%3C/svg%3E)
Frank Pivonka
0
Reputation points
commented 2025-05-31T18:18:54.7066667+00:00
Ben Miller-(DBADuck)
195
Reputation points MVP
2 answers
publication having 2 subscribers
We have transactional replication configured. We have a publication having 2 subscribers. If snapshot is generated on 1 subscriber, will it generate snapshot on the second subscriber?
SQL Server Database Engine
266 questions
asked 2025-05-14T14:37:29.3066667+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, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
801
Reputation points
answered 2025-05-31T05:14:40.7133333+00:00
Ben Miller-(DBADuck)
195
Reputation points MVP
2 answers
SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring
Subject: SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring Dear Microsoft Support, I am writing to request assistance with a database mirroring issue I'm encountering in our SQL Server environment. Environment…
SQL Server Database Engine
266 questions
asked 2025-05-14T14:47:24.9866667+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, 45%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Deepak Kumar | Veracity
0
Reputation points
answered 2025-05-31T05:12:50.0866667+00:00
Ben Miller-(DBADuck)
195
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Can not attach database to SQL Server Express 15.0
SQLIssue1.pdfSQLIssue2.pdf Want to attached FosterTrak database to SQL server but it does not appear on the add list as shown in images. Have done this dozens of times. How do I fix this?
SQL Server Database Engine
266 questions
asked 2025-05-30T15:44:06.1033333+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(102.4, 56.00000000000001%, 19%)' 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)
SuperCoder
236
Reputation points
accepted 2025-05-30T22:54:11.01+00:00
SuperCoder
236
Reputation points
1 answer
I am attempting to complete the learning lab in MS Learning for Power Bi certificate and I've been troubleshooting for hours to no avail - I am unable to connect to the SQL database in Power Bi (or so the error messages say). See attached. Thank you.
SQLprob.png SSMIprob.png configsql.png sqlconfig.png I'm at a loss. Please be advised, this is all new to me but I've never had so much trouble connecting to an app.
SQL Server Database Engine
266 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(172.8, 0%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
SQL Server 2022 TLS 1.3 Protocol Support
Hi, For SQL server and https communication, we want to implement TLS 1.3 protocol support in our existing .Net & Delphi based applications. setup details1. Windows Server 2022 Standard (Version 21H2)1. Microsoft SQL Server 2022 (RTM-CU18)…
SQL Server Database Engine
266 questions
asked 2025-05-26T08:10:08.4933333+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(140.8, 20%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amjad Subhani
0
Reputation points
commented 2025-05-29T08:51:40.08+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
3 answers
One of the answers was accepted by the question author.
Cannot shrink my DB after backup logs: Seems the backup marks last VLF
Hi, I have a hard used DB (the log files grows about 5Gb per day), that I cannot shrink the log file after backup. This is my backup sql file: GO print 'Set single user'; ALTER DATABASE [My DB name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE BEGIN TRY print…
SQL Server Database Engine
266 questions
asked 2025-05-20T08:57:37.0033333+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, 42%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Lucio Menci
20
Reputation points
commented 2025-05-29T08:05:25.4133333+00:00
Lucio Menci
20
Reputation points
0 answers
SQL Server 2025 AG health-check diagnostics to actually spit out their perf-counter dump (per the docs here: Lease & Health-Check Timeout),
Hey SQL Friends - I’ve been banging my head against the wall trying to get SQL Server 2025 AG health-check diagnostics to actually spit out their perf-counter dump (per the docs here: Lease & Health-Check Timeout),…
SQL Server Database Engine
266 questions
asked 2025-05-28T22:14:31.2133333+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(211.20000000000002, 42%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Michael Fuller
0
Reputation points
asked 2025-05-28T22:14:31.2133333+00:00
Michael Fuller
0
Reputation points
0 answers
SQL Server replication agent invariable reports "incorrect username or password"
I am currently setting up transactional (as well as snapshot) replication on an Azure SQL Managed instance. There are 5 databases and since there are dependencies between these databases I started in reverse dependency order. All agents, including the…
SQL Server Database Engine
266 questions
asked 2025-05-28T17:52:00.01+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, 23%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBT%3C/text%3E%3C/svg%3E)
Bryce Tutt
1
Reputation point
commented 2025-05-28T21:02:14.2333333+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
One of the answers was accepted by the question author.
MSSQL server keeps on dumping .mdmp .txt and .log files. I would appreciate it if someone can assist me in correcting this problem.
We run a Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) on a Windows server 2019 Datacenter version 1809 The contents of the ERRORLOG 2025-05-27 09:25:26.94 spid18s ex_dump_if_requested: Exception raised, major=52, minor=43, state=8,…
SQL Server Database Engine
266 questions
asked 2025-05-27T11:43:33.33+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(224.00000000000003, 87%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chris du Preez
20
Reputation points
accepted 2025-05-28T05:15:34.4666667+00:00
Chris du Preez
20
Reputation points
0 answers
I am experiencing an issue where my MSSQL Server continuously generates .mdmp, .txt, and .log files. Could someone please help me understand why this is happening and how to resolve it?
I am experiencing an issue where my MSSQL Server continuously generates .mdmp, .txt, and .log files. Could someone please help me understand why this is happening and how to resolve it?
SQL Server Database Engine
266 questions
asked 2025-05-27T13:35:15.1733333+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(57.599999999999994, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHC%3C/text%3E%3C/svg%3E)
hirwa cedric
0
Reputation points
commented 2025-05-27T21:15:04.0533333+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
2 answers
SQL SERVER 2022 Express Edition
SQL SERVER 2022 Express Edition Oops... Unable to install SQL Server(setup.exe). Exit code (Decimal) - 2061893606 Error description. Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
SQL Server Database Engine
266 questions
asked 2025-05-26T07:36:55.7966667+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(275.2, 31%, 36%)' 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)
Rolly G. Jr Carrascal
0
Reputation points
commented 2025-05-27T14:18:56.2766667+00:00
Dan Guzman
9,406
Reputation points
1 answer
Exit code (Decimal): -2061893606
I am getting this error, I have made changes in registry editor as well Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log…
SQL Server Database Engine
266 questions
asked 2025-05-24T15:45:45.9466667+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, 53%, 16%)' 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)
Sania Jain
0
Reputation points
commented 2025-05-26T05:37:41.75+00:00
Olaf Helper
47,441
Reputation points
0 answers
Server got hacked
Server got hacked and not able to open any file and all extensions are changed for all files
SQL Server Database Engine
266 questions
asked 2025-05-25T16:40:01.52+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(297.6, 26%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sridhar Vuyyuri
0
Reputation points
commented 2025-05-25T17:28:29.51+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
1 answer
One of the answers was accepted by the question author.
SQL query to know which user taked database backup.
SQL query to know which user taked database backup.Please respond ASAP.
SQL Server Database Engine
266 questions
asked 2025-05-25T13:37:14.6566667+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, 73%, 29%)' 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)
Anandhswarupp
185
Reputation points
accepted 2025-05-25T14:16:50.7566667+00:00
Anandhswarupp
185
Reputation points
1 answer
SQL replication changing subscriber @sync_type without dropping
SQL Replication I Incorrectly added some subscribers and need to change the @sync_type -can we alter a replication subscriber and not drop it
SQL Server Database Engine
266 questions
asked 2025-05-22T15:43:11.8133333+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, 90%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Marty Figueroa
0
Reputation points
answered 2025-05-22T20:54:45.6966667+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator
1 answer
Cannot access master database Error 40613 after Microsoft planned maintenance some 24 hours ago
If the problem persists, contact customer support, and provide them the session tracing ID of '{0691132C-C41D-4836-9A67-93DFB5D033F2}'. (Microsoft SQL Server, Error: 40613)
SQL Server Database Engine
266 questions
asked 2025-05-22T07:46:14.4866667+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, 57.99999999999999%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Baker | Xpert360
1
Reputation point
answered 2025-05-22T08:38:18.8433333+00:00
David Baker | Xpert360
1
Reputation point
2 answers
How to license this scenario?
Hello Team, I have a Cluster with 8 Physical Server(2 proc and 56 cores) and 56 VMs. with multiple environment prod, dev and test. VMotion is enabled. 1.What is the best way to license this scenario? 2. Is it allowed to license by virtual Machine…
SQL Server Database Engine
266 questions
asked 2025-05-19T15:53:40.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(272, 80%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shwetha K R
0
Reputation points
commented 2025-05-21T19:01:53.5733333+00:00
Shwetha K R
0
Reputation points
2 answers
Maintenance Plan Wizard not available in SQL Server 2025 CTP
I'm currently using Microsoft SQL Server 2025 CTP2.0 with SSMS. When I try to use the Maintenance Plan Wizard to create backup jobs, I get the message: "This feature is not currently available in this version of SSMS." Is this a known…
SQL Server Database Engine
266 questions
asked 2025-05-20T11:32:35.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(198.4, 84%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
sai ganesh
0
Reputation points
answered 2025-05-21T06:42:27.2733333+00:00
Olaf Helper
47,441
Reputation points
1 answer
how to fix 'sqllocaldb' is not recognized as an internal or external command, operable program or batch file.
Please help, how can I resolve this . I have been trying to connect to my localdb on my mssms and when i try to run it on the cmd it says this: C:\Users\Ricky>sqllocaldb info 'sqllocaldb' is not recognized as an internal or external command, operable…
SQL Server Database Engine
266 questions
asked 2025-05-20T04:16:54.0533333+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(73.60000000000001, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ricky
0
Reputation points
answered 2025-05-20T21:48:26.0066667+00:00
Erland Sommarskog
121.9K
Reputation points MVP
Volunteer Moderator