721 questions with SQL Server Database Engine tags

Sort by: Updated
3 answers

How do filter Action column on SQL Database Audit Specification?

Hi Expert, How to exclude Column [Action ID] with record 'SELECT','EXECUTE' & 'VIEW' action? I've filtered [Action ID] using conversion to INT type to getting ID of the action(Select,Execute,View) but it still not worked .. any suggestion? great…

SQL Server Database Engine
asked 2026-06-19T04:24:08.43+00:00
Urbel 605 Reputation points
answered 2026-06-19T21:35:20.1833333+00:00
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2 answers

how to fix sql installation problem in windows11

unable to install sql application since I have bought new laptop with windows 11. tried reaching out to hp support but still no use.facing the below error tried multiple times fixing but still the same.

SQL Server Database Engine
asked 2026-06-02T07:29:39.0266667+00:00
MOUNIKA DHUPAM 0 Reputation points
recommended 2026-06-19T06:18:45.9766667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
3 answers

getting below error while installing microsoft sql server 2025

SQL Server Database Engine
asked 2026-05-25T16:59:03.3033333+00:00
Manisha Shinde 0 Reputation points
recommended 2026-06-19T05:52:03.13+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

RedHat Linux 9.7 SQL Server 2025 CU2 Fails to write database backup to Linux NFS Share

Hello, I have a VMWare VM running RedHat Linux 9.7 and SQL Server 2022 CU 23. SQL Server 2022 can successfully write database backups and the mssql agent job text log file to the Linux NFS share. I successfully upgraded the VM to SQL Server 2025 CU2.…

SQL Server Database Engine
asked 2026-02-23T22:49:30.06+00:00
Marcelo Marques 0 Reputation points
answered 2026-06-18T14:51:38.94+00:00
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2 answers

I'm trying to restore sql instance that is about 100gb and there is this issue of limited

I'm not export, I know basics how to do in via SQL Management Studio and I get this message: Microsoft.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of…

SQL Server Database Engine
asked 2026-06-13T02:38:04.01+00:00
Arkadi 0 Reputation points
commented 2026-06-18T09:14:05.3366667+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
3 answers

Microsoft SQL Server 2022 - no TCP/IP connection in client protocols in SQLServer Configuration Manager

Hello, since SQL Server 2022 Standard edition I miss in "SQL Server Configuration Manager" under "client protocols" all protocols e.g. "TCP/IP", to enable client connection to the Database. Also I can not create manually a…

SQL Server Database Engine
asked 2026-05-26T06:58:27.8+00:00
Lackner, Mario 0 Reputation points
commented 2026-06-18T05:58:52.0933333+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
0 answers

SQL Server 2022 Oops... Error decompressing SQL Server media

Hello, I am trying to install SQL Server 2022 for the first time, but it gives me this error. I spent about 10 days to find the main cause of this problem and try to solve it, but it seems that is a new one. I tried to: remove .exe installation file…

SQL Server Database Engine
asked 2025-03-19T05:34:13.0433333+00:00
Mahmoud Khaled 0 Reputation points
commented 2026-06-18T05:27:41.5966667+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
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-06-16T22:31:57.5866667+00:00
Martin C Nagel 0 Reputation points
1 answer

Quiero descargar SMSS

¿Cómo descargo SSMS, estuve intentando y no me deja, además no me aparece la opción de: "Descarga de SMSS"?

SQL Server Database Engine
asked 2026-06-08T17:06:39.55+00:00
Rosita 0 Reputation points
commented 2026-06-16T03:42:46.5866667+00:00
Lakshmi Narayana Garikapati 1,330 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

SQL Developer license

I would like to request formal clarification regarding the permitted use of SQL Server Developer Edition in a specific customer environment scenario. Context We are designing and operating a non‑production environment with the following…

SQL Server Database Engine
asked 2026-06-11T11:41:06.2366667+00:00
Bertellini, Luca 20 Reputation points
commented 2026-06-11T22:48:17.38+00:00
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2 answers

Can't connect to sql server

I Downloaded SQL and I can't connect to the server.

SQL Server Database Engine
asked 2025-11-05T03:06:24.9766667+00:00
Luisa Jones 0 Reputation points
commented 2026-06-11T19:58:02.05+00:00
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2 answers

MSSQL prefer way to transfer big file from server to client.

Hello I have a cpp client which connects to MSSQL server 2025 using ODBC or Native client. I need to transfer large number of files (can vary from 100 MB to 1GB there can be many files from 1 to 100) what is best way to transfer such large amount of data…

SQL Server Database Engine
asked 2026-05-29T09:44:03.1433333+00:00
Vivek Mendse (vmendse) 0 Reputation points
commented 2026-06-11T06:35:53.7566667+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
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
asked 2026-05-07T17:39:23.1566667+00:00
Mantini, Ronald M 6 Reputation points
commented 2026-06-10T20:06:09.6266667+00:00
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2 answers

Symmetric key alter issue in SQL Server 2025

Context: I am using SQL Server 2025 with symmetric keys protected by a certificate, and I encrypt/decrypt data using the EncryptByKey and DecryptByKey functions. I now need to migrate the symmetric key protection to Azure Key Vault. However, while…

SQL Server Database Engine
asked 2026-06-01T14:17:15.8166667+00:00
Dipak Nile 0 Reputation points
commented 2026-06-10T07:42:36.7633333+00:00
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
2 answers

Unable install MSSQL ODBC Driver on the PPC64le

Dear Microsoft support, is there in near future planned to develop MSSQL ODBC driver for PPC64le architecture? From accessible documentation is not available/supported from your side at this moment. Thank you for response. Br, Erik

SQL Server Database Engine
asked 2026-05-27T10:13:52.5833333+00:00
Erik Tkac 0 Reputation points
commented 2026-06-10T06:48:52.4433333+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
4 answers

Prevent a thick-client app's Windows user from accessing the local SQL Express DB outside the app

Setup: A Windows desktop app runs on non-admin workstations. It uses a local SQL Server Express instance on the same machine over shared memory. The app connects to SQL using the logged-in Windows user's own identity (the app process runs as that…

SQL Server Database Engine
asked 2026-06-04T13:03:09.61+00:00
Mansoor R 0 Reputation points
edited a comment 2026-06-10T06:03:30.7366667+00:00
Mansoor R 0 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
asked 2026-05-22T02:04:04.07+00:00
ITD-Sreng Channy 0 Reputation points
recommended 2026-06-09T15:35:47.6133333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Upgraded sql server from sql 2016 to sql 2022, but master database still at 130 level. Should i change it ?

We upgraded sql server from sql 2016 to sql 2022, but master the database still at 130 compatibility level level. I get why the upgrade process needs to keep the master database at 130 level. Post upgrade, should we manually change the compatibility…

SQL Server Database Engine
asked 2026-06-03T08:08:57.19+00:00
Greg Booth 1,536 Reputation points
accepted 2026-06-09T08:15:57.5+00:00
Greg Booth 1,536 Reputation points
2 answers

how to open sql server from visual studio

I 'am traying to open the SQL server 2022 folder after installing visual studio 2026 but the folder that I have for SQL server 2022 is empty folder why?

SQL Server Database Engine
asked 2026-05-26T22:09:12.9266667+00:00
elamin osman 0 Reputation points
commented 2026-06-09T05:19:10.5733333+00:00
Lakshmi Narayana Garikapati 1,330 Reputation points Microsoft External Staff Moderator
1 answer

Unable to install SQL Express

I get the following error when trying to install SQL Server Express: Oops... Unable to install SQL Server (setup.exe) Exit code (Decimal):-2061893606 Error Description: Wait on Database Engine recover handle failed

SQL Server Database Engine
asked 2025-11-03T16:21:04.7733333+00:00
John McKenna 0 Reputation points
commented 2026-06-08T20:48:19.75+00:00
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator