742 questions with SQL Server Database Engine tags

Sort by: Updated
3 answers

Clarification on MSOLEDBSQL19 Behavior with TrustServerCertificate=True

Hello Team, We are currently using the MSOLEDBSQL19 driver on Windows systems and would like to better understand its connection behavior related to encryption and certificate validation. While testing SQL Server connectivity, we observed that a…

SQL Server Database Engine
asked 2026-07-13T09:22:07.6666667+00:00
Abhishek Modi (amodi) 20 Reputation points
commented 2026-07-20T09:44:51.4366667+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

how to fix this sql server install issuses ( wait on database engine recovery handle failed )

Am faced this issues on windows 11 (64 bit) - HP LAPTOP SQL SERVER 2025 EXPRESS EDITION UNABLE TO INSTALL SQL SERVER SETUP Exit code (decimal) - 2061893606 error decription - wait on database engine recovery handle failed . how to resolve this…

SQL Server Database Engine
asked 2026-07-18T16:06:39.3566667+00:00
Lavanya Sureshbabu 20 Reputation points
commented 2026-07-19T16:31:03.3266667+00:00
Bruce (SqlWork.com) 84,671 Reputation points
1 answer

SQL Server 2025 - Higher Worker Thread Consumption After Upgrade

Hi all, We're currently testing SQL Server 2025 (17.x) and have noticed significantly higher worker thread consumption compared to our SQL Server 2019 environment. We first observed this on SQL Server 2025 CU5 and have since observed the same behaviour…

SQL Server Database Engine
asked 2026-07-17T14:22:06.8366667+00:00
Andy 86 Reputation points
answered 2026-07-18T10:41:03.43+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
1 answer

Restore backup in parallel to primary and secondary of availability group with manual seeding

I have SQL Server availability group with manual seeding and two synchronous replicas - primary and secondary. I want to onboard a set of database backups onto the availability group : 1 full backup + 1 transaction log backup. Backups are large, so I…

SQL Server Database Engine
asked 2026-07-17T13:47:06.5466667+00:00
dekp 0 Reputation points
answered 2026-07-18T10:28:15.7833333+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
3 answers

SQL Server 2025 - Unable to run Python scripts

I have built a SQL Server 2025 instance and, following the instructions here I have installed and configure R and Python support. R is working fine but when I try to run a simple Python script I get the errors: EXEC sp_execute_external_script…

SQL Server Database Engine
asked 2025-11-25T14:50:01.7933333+00:00
Peter Bishop 256 Reputation points
commented 2026-07-17T18:06:10.53+00:00
Russ R 1 Reputation point
3 answers

SQL Server 2025 CU6 Serious Defect

SQL Server 2025 CU6 lists Linked Servers as a "Known Issue" - the workarounds are terrible - this needs fixing urgent. To summarise, users will get "Access to the remote server is denied because no login-mapping exists." when trying…

SQL Server Database Engine
asked 2026-07-13T14:25:34.9966667+00:00
JP 0 Reputation points
commented 2026-07-16T21:34:01.3166667+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

I need to create a remote connection to SQL Server (a login and password too).

I am getting errors installing FEMA's HAZUS Pro software which uses ESRI ArcGIS Pro as it's map engine. The failure is because the ArcGIS program will not connect to the SQL database. ESRI support says I have to configure SQL server to accept remote…

SQL Server Database Engine
asked 2026-07-10T22:29:19.01+00:00
Candace Snipes 20 Reputation points
commented 2026-07-15T15:23:35.9133333+00:00
Candace Snipes 20 Reputation points
2 answers

MSOLEDBSQL 19.4.1 — TrustServerCertificate=True does not bypass certificate validation (works in driver 18)

Environment: Windows Server 2022 client MSOLEDBSQL 19.4.1.0 (msoledbsql19.dll) SQL Server 2022, Force Encryption = Yes, default self-signed cert (CN=SSL_Self_Signed_Fallback, no SAN) Problem: The following connection string fails on driver 19 with…

SQL Server Database Engine
asked 2026-07-13T10:30:12.8133333+00:00
Abhishek Modi (amodi) 20 Reputation points
commented 2026-07-15T12:31:20.7833333+00:00
Abhishek Modi (amodi) 20 Reputation points
1 answer

Replication Monitor fails with "requires actual server name" when Distributor is on Always On AG registered via Listener Name — SQL Server 2022

Environment: SQL Server 2022 RTM-CU22 (KB5068450) - 16.0.4225.2 (X64) SSMS 19.x and 20.7.0 (tested both — same behavior on each) Publisher: PUBLISHER_HOST (standalone, default instance) Publisher Database: PUBLISHER_DB Distributor: Hosted on Always…

SQL Server Database Engine
asked 2026-07-14T01:09:46.5633333+00:00
Don Ferguson 0 Reputation points
recommended 2026-07-14T21:33:40.04+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2025 — BACKUP/RESTORE TO URL fails with OS error 13 on all Azure Blob SAS credentials

On SQL Server 2025 (17.0.4055.5, RTM-CU6), every BACKUP TO URL and RESTORE FROM URL against Azure Blob Storage fails with Msg 3201 ... Operating system error 13 (The data is invalid.), while the identical SAS token and blob succeed from a SQL Server 2017…

SQL Server Database Engine
asked 2026-07-07T21:17:01.86+00:00
Weezelboy 1 Reputation point
commented 2026-07-10T20:04:56.9933333+00:00
Weezelboy 1 Reputation point
3 answers

how do you download and install SQL Server

how do you download and install SQL Server onto a new PC

SQL Server Database Engine
asked 2026-07-09T21:20:18.6866667+00:00
Joe English 0 Reputation points
edited an answer 2026-07-10T15:26:05.9333333+00:00
Bruce (SqlWork.com) 84,671 Reputation points
0 answers

Vulnerability detected: SMB2/BruteForceAttempt.UN!SP.35605 Description: SMB Bruteforce Attempt Detected

Dear Team, Please check the server, as we have detected a potential unauthorized attack. The following AMSI detection was observed: AMSI: \Device\HarddiskVolume4\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\sqlservr.exe Kindly…

SQL Server Database Engine
asked 2026-07-08T13:08:43.56+00:00
Vishnu Kant Maurya 0 Reputation points
commented 2026-07-08T14:48:46.77+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
1 answer

ODBC Driver Issue with ARM64: Native Heap corruption.

Hello Microsoft Team, We are facing an issue when using ODBC Driver on ARM64 Linux(Graviton on AWS infra). There is a native memory corruption happening due to mssqlodbc driver v18 causing the application to stall/crash. Below are the details around…

SQL Server Database Engine
asked 2026-07-07T12:37:49.61+00:00
Yash Jain 5 Reputation points
answered 2026-07-07T13:49:02.54+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

SQL Server Doesn't Start Automatically

Good morning. After starting my computer, the SQL Server instance doesn't start automatically. I have to start it manually by restarting the service. This happens in both startup modes: automatic and automatic (delayed start). SQL Version: Microsoft…

SQL Server Database Engine
asked 2026-07-04T10:18:18.5666667+00:00
Waldemar Czarnecki 80 Reputation points
accepted 2026-07-07T11:00:04.5366667+00:00
Waldemar Czarnecki 80 Reputation points
4 answers

Issue to access

Hi, Can you help to this? TITLE: Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is…

SQL Server Database Engine
asked 2026-07-06T01:55:38.21+00:00
Jonathan 300 Reputation points
edited a comment 2026-07-06T10:19:09.1766667+00:00
Jonathan 300 Reputation points
1 answer

Error 8624, Severity 16: Internal Query Processor Error: The query processor could not produce a query plan.

Hi, Environrment : SQL Server 2022, build 16.0.4252.3 (CU24 + GDR, May 2026) We are experiencing an intermittent issue on Microsoft SQL Server 2022 Enterprise Edition running in an Always On Availability Group environment.A specific stored procedure…

SQL Server Database Engine
asked 2026-07-05T10:07:13.09+00:00
Mohanraj Selvarasu 20 Reputation points
edited a comment 2026-07-06T09:41:11.4566667+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
1 answer

how to copy usermappings from one to another

how to copy user mappings from one to another for sql server database 2017 EE

SQL Server Database Engine
asked 2025-09-15T06:35:19.7766667+00:00
drmrdba 0 Reputation points
commented 2026-07-04T04:01:46.3733333+00:00
mawisec 0 Reputation points
2 answers One of the answers was accepted by the question author.

Official Download Link for MS SSMS v20.2.1

Hello Everyone, I am trying to upgrade my existing MS SSMS from v18.12.1 to v20.2.1 in one of my environments. I am looking for the installer, but I could not find one from the Microsoft Official website. This page of 20.2.1 takes me to the download of…

SQL Server Database Engine
asked 2026-01-01T11:35:25.28+00:00
Arkapriya Gupta 20 Reputation points
commented 2026-07-03T09:45:52.73+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
1 answer

Using Local account for setting HA SQL Always ON

Hi expert, I use NT Service\MSSQL$MySQL account to running SQL Service then i've got error on SQL err log; "..Database mirroring login attempt by user [Domain\Node1$] failed with error; Handshake failed with login [Domain\Node1$] does have no…

SQL Server Database Engine
asked 2026-07-03T06:53:01.38+00:00
Urbel 665 Reputation points
answered 2026-07-03T09:23:42.9433333+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator
0 answers

SQL Server 2025 on Linux: Msg 19417 persists after dropping EXTERNAL Availability Group and resetting HADR cluster context

Product SQL Server 2025 Enterprise Edition (Linux) Ubuntu 24.04.4 LTS Version: 17.0.4025.3 (CU3) Secondary server: SQL Server 2025 Enterprise Edition (Linux) Ubuntu 25.10 Version: 17.0.4055.5 (CU6) Environment Two Linux servers connected through…

SQL Server Database Engine
asked 2026-07-02T14:23:11.0766667+00:00
Adil El Gatri 0 Reputation points
commented 2026-07-02T15:27:06.85+00:00
Erland Sommarskog 135.7K Reputation points MVP Volunteer Moderator