785 questions with SQL Server Database Engine tags

Sort by: Updated
2 answers

SQL Server 2022 Always On metadata calls slow after patching

Following recent patching of our on-premises SQL Server 2022 environment, transaction log backups have become significantly slower than before the patch.   The servers are configured with SQL Server Always On Availability Groups. The issue affects…

SQL Server Database Engine
asked 2026-10-01T15:56:58.9866667+00:00
Jagadeesh Vadivel 0 Reputation points
commented 2026-10-03T18:37:32.3933333+00:00
Erland Sommarskog 137.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
commented 2026-10-02T13:33:55.69+00:00
Maksood Ahmed 15 Reputation points Microsoft External Staff Moderator
4 answers One of the answers was accepted by the question author.

SQL Server 2025 executing request with in SQL connexion is very slow

Hello, I installed SQL 2025 on a new VM to test the installation of my application, which currently runs on SQL 2022. I’m facing an issue with SQL 2025 (fresh installation on a new machine with a new DB): the queries are extremely slow when I use a SQL…

SQL Server Database Engine
asked 2025-12-15T07:24:18.83+00:00
MT 45 Reputation points
accepted 2026-10-02T08:56:02.0766667+00:00
MT 45 Reputation points
1 answer

SQL Server 2022 performance degradation (2x slower) with increased Context Switches/sec under Compatibility Level 110 after migration

Hi, Please note that this message was translated using Generative AI. I apologize in advance for any unnatural phrasing or translation errors. We recently migrated our database from SQL Server 2017 to SQL Server 2022 on a new virtual machine. After the…

SQL Server Database Engine
asked 2026-09-30T14:42:05.9633333+00:00
k.a 0 Reputation points
commented 2026-10-01T19:31:31.18+00:00
Erland Sommarskog 137.6K Reputation points MVP Volunteer Moderator
3 answers

Is MS ODBC driver 18.5.1.1 compatible with SQL Server 2025 for new JSON and VECTOR types?

Hello, I would like to test the new JSON and VECTOR types of SQL Server 2025 with the Microsoft ODBC driver for SQL Server. I have installed SQL Server 2025 CTP 2.0 on my Windows 11. For now I have MS ODBC driver 18.5.1.1 for Linux (Debian 12). Is this…

SQL Server Database Engine
asked 2025-06-12T12:44:51.11+00:00
Sebastien Flaesch 51 Reputation points
commented 2026-10-01T19:16:46.27+00:00
Erland Sommarskog 137.6K Reputation points MVP Volunteer Moderator
1 answer

SQL 2016 to 2022 AG migration on Azure VMs: how to keep the existing DNN listener name working for apps that cache DNS and can't be restarted?

Environment Source: 2-node SQL Server 2016 AG on Azure VMs, using a DNN listener Target: new 2-node SQL Server 2022 AG on Azure VMs, Database: about 4 TB, to be migrated using a distributed AG Clients: many applications and reports that use the…

SQL Server Database Engine
asked 2026-09-30T23:26:27.3066667+00:00
Abimbola Adeniran 106 Reputation points
commented 2026-10-01T07:31:20.51+00:00
Senthil kumar 2,580 Reputation points
1 answer

Geography STDistance() and ShortestLineTo() overestimate polygon-to-polygon distance in SRID 104001 (unit sphere)

(Microsoft SQL Server 2022) In SRID 104001 (unit sphere), STDistance() between two non-intersecting polygons returns values that are too large. In the cases tested, the error was up to about 63 km (converted with R = 6371 km) for polygons 200–500 km…

SQL Server Database Engine
asked 2026-09-30T21:14:29.73+00:00
KoizumiJunko-6191 0 Reputation points
answered 2026-09-30T21:59:37.57+00:00
Erland Sommarskog 137.6K Reputation points MVP Volunteer Moderator
0 answers

sys.fn_hadr_backup_is_preferred_replica() are taking much longer than expected since the patch

We’ve noticed that SQL transaction log backups have become significantly slower following the recent SQL Server 2022 patching. The issue appears to be affecting multiple Availability Groups rather than a single database. For example, even checks such as…

SQL Server Database Engine
asked 2026-09-25T19:37:04.7+00:00
Jagadeesh Vadivel 0 Reputation points
commented 2026-09-25T20:30:58.5433333+00:00
Erland Sommarskog 137.6K Reputation points MVP Volunteer Moderator
2 answers

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
commented 2026-09-25T09:22:36.8666667+00:00
Maraiah Kasetti (Wipro Limited) 85 Reputation points Microsoft External Staff Moderator
5 answers

Source files within source systems are not synchronized with raw tables in Azure database

Hello, I would like to ask for suggestions regarding the following problem: Our DWH architecture was initially configured in the way, that source files from various source systems should be aligned with actual raw tables in our Azure database [we…

SQL Server Database Engine
asked 2026-09-04T12:44:56.3166667+00:00
recommended 2026-09-24T21:13:41.57+00:00
Erland Sommarskog 137.6K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2025 PBKDF2 login performance regression with Microsoft Access/ACE – supported mitigation?

We have reproduced a significant SQL Authentication performance regression after migrating an on-premises Microsoft Access application from SQL Server 2022 to SQL Server 2025. Environment SQL Server 2025 Express CU9, 17.0.5005.3 Windows Server 2022 …

SQL Server Database Engine
asked 2026-09-23T21:01:52.2466667+00:00
devswick 5 Reputation points
commented 2026-09-24T08:15:02.26+00:00
Erland Sommarskog 137.6K Reputation points MVP Volunteer Moderator
5 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
answered 2026-09-23T14:42:16.5033333+00:00
Bruce (SqlWork.com) 85,456 Reputation points
1 answer

What AES mode does TDE use in on-premises SQL Server?

We are certifying a software product that uses Microsoft SQL Server as its database engine. The certification body has asked us to identify the AES mode of operation used by Transparent Data Encryption (TDE) when SQL Server is deployed on-premises. The…

SQL Server Database Engine
asked 2026-09-23T09:47:15.7866667+00:00
Raúl Porras Martín 0 Reputation points
edited a comment 2026-09-23T14:39:15.0866667+00:00
Marcin Policht 109.6K Reputation points MVP Volunteer Moderator
0 answers

SQL Server: Unexpected CPU Spike on Primary Replica — Troubleshooting Assistance Needed

Problem description I am experiencing an issue with my SQL Server virtual machine where the primary replica of an Always On availability group in the UK South region is experiencing unexpected CPU utilization spikes up to 100%. This occurs under a…

SQL Server Database Engine
asked 2026-09-05T12:21:24.7233333+00:00
Prakash Nandwana 0 Reputation points
commented 2026-09-20T15:38:14.7066667+00:00
Himaja Y 555 Reputation points Microsoft External Staff Moderator
1 answer

Log shipping backups

Good Morning Can we take full backup of primary database and full backup of secondary database in Log Shipping?

SQL Server Database Engine
asked 2026-09-19T06:14:16.33+00:00
Chaitanya Kiran 841 Reputation points
answered 2026-09-19T19:49:03.0733333+00:00
Erland Sommarskog 137.6K Reputation points MVP Volunteer Moderator
1 answer

Fix a broken Log shipping

Good Morning, In our environment, we have log shipping backup configured every 15 minutes. In the middle, manual log backup was taken and this breaks log chain. How to fix this?

SQL Server Database Engine
asked 2026-09-18T00:15:26.51+00:00
Chaitanya Kiran 841 Reputation points
answered 2026-09-18T12:30:01.0433333+00:00
Deepesh Dhake 1,245 Reputation points
1 answer

How to download sql server 2022 developer edition

How to download sql server 2022 developer edition,i search many but not to find it..

SQL Server Database Engine
asked 2026-07-29T05:38:11.3766667+00:00
Jenshiya M 10 Reputation points
commented 2026-09-17T04:34:00.61+00:00
SIVASANKAR YEDDULA 250 Reputation points Microsoft External Staff Moderator
2 answers

how do I add a user

How do I add a remote user on the same network to use the data in ms sql server

SQL Server Database Engine
asked 2026-09-13T13:28:06.26+00:00
Ceci Bylls 0 Reputation points
answered 2026-09-16T04:05:42.2433333+00:00
Asemeit 0 Reputation points
4 answers One of the answers was accepted by the question author.

Installed SQL server 2022 express on windows 11 PC - Database engine services failed

After the install have "Completed with failures" with "Database Engine Services" with Failed status I just a desktop tech and do not know much about SQL server express and the end-user does not either but needs this software…

SQL Server Database Engine
asked 2026-09-02T13:13:03.4766667+00:00
Collins, John L 20 Reputation points
accepted 2026-09-11T20:41:40.6066667+00:00
Collins, John L 20 Reputation points
6 answers One of the answers was accepted by the question author.

Where are the SQL Server developer edition downloads

Where are the developer edition download files for SQL Server 2022, SQL Server 2019, and SQL Server 2017?

SQL Server Database Engine
asked 2026-03-24T22:21:49.96+00:00
Steve Margolis 30 Reputation points
edited a comment 2026-09-11T06:52:59.34+00:00
SIVASANKAR YEDDULA 250 Reputation points Microsoft External Staff Moderator