718 questions with SQL Server Database Engine tags

Sort by: Updated
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
recommended 2026-06-09T19:25:22.11+00:00
Erland Sommarskog 134.6K Reputation points MVP Volunteer Moderator
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

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
answered 2026-06-08T21:06:13.5666667+00:00
Erland Sommarskog 134.6K Reputation points MVP Volunteer 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-08T20:54:51.9266667+00:00
Erland Sommarskog 134.6K Reputation points MVP Volunteer 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.6K 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-08T06:28:09.0266667+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-08T06:06:20.86+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
1 answer

Facing an issue while Export/Backup SQL Database

While taking backup of an existing SQL Database using Export Database option, observed that its taking too much times in hours. After 3-4 hrs as well its showing progress of just 1% only. So want support for the same that what could be the reason behind…

SQL Server Database Engine
asked 2025-04-14T10:14:50.65+00:00
Gravitive Service 0 Reputation points
commented 2026-06-08T05:10:13.3+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff 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
commented 2026-06-05T12:23:35.3833333+00:00
Anjan Kumar Chippa (Quadrant Resource LLC) 0 Reputation points Microsoft External Staff Moderator
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
asked 2026-05-20T07:28:48.0066667+00:00
Sam Chung 0 Reputation points
recommended 2026-06-04T19:12:33.0966667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2026-05-06T03:12:42.8866667+00:00
Veasna Lay 0 Reputation points
recommended 2026-06-04T19:10:47.9133333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Sql server 2025 installation error

Hello Microsoft Support Team, I am reaching out regarding an installation issue with Microsoft SQL Server 2025 (Express Edition) on my ASUS TUF Gaming A15 laptop running Windows 10 Home Single Language (Build 26200). During installation, the server fails…

SQL Server Database Engine
asked 2026-04-20T17:33:12.6733333+00:00
sanjay MN 0 Reputation points
recommended 2026-06-04T19:07:28.67+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

SQL Server Login Failures (Error 18456) due to Reporting Services attempting to access non-existent ReportServer database

We are experiencing repeated SQL Server login failures (Event ID 18456) on one of our servers. Details: SQL Server Version: SQL Server 2016 Error Message: "Login failed for user 'REA\IND-WBN-DEV$'. Reason: Failed to open the explicitly specified…

SQL Server Database Engine
asked 2026-04-17T07:24:16.13+00:00
Kamarur Rama 0 Reputation points
recommended 2026-06-04T19:07:15.7866667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Unable to install micrsoft sql server

Unable to install sql server, there is some installtion of previous version is present so unable to install microsoft sql server 2019

SQL Server Database Engine
asked 2026-04-13T06:57:25.6866667+00:00
Akshay Hebbar 0 Reputation points
recommended 2026-06-04T19:06:49.3033333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Logon issue

Hi, Can you help to this? 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 configured to…

SQL Server Database Engine
asked 2026-06-04T09:33:24.9333333+00:00
Jonathan 150 Reputation points
accepted 2026-06-04T09:37:20.71+00:00
Jonathan 150 Reputation points
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
asked 2025-04-28T08:46:47.8233333+00:00
Shabir jan 21 Reputation points
edited a comment 2026-06-04T04:32:44.8833333+00:00
Akhil Gajavelly 1,830 Reputation points Microsoft External Staff Moderator
3 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
asked 2026-05-08T06:42:51.8466667+00:00
Sam Chung 0 Reputation points
recommended 2026-06-03T05:42:42.3+00:00
Madhavi Taniparthi 0 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
asked 2026-05-14T10:18:59.6533333+00:00
Youssef Maach 0 Reputation points
recommended 2026-06-03T05:32:30.5966667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator