SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
1 answer
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
![](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(12.8, 16%, 11%)' 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)
Arkadi
0
Reputation points
answered 2026-06-13T02:38:13.67+00:00
AI answer
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-06-11T11:41:06.2366667+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(9.6, 65%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bertellini, Luca
20
Reputation points
commented 2026-06-11T22:48:17.38+00:00
Erland Sommarskog
134.6K
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2025-11-05T03:06:24.9766667+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, 12%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Luisa Jones
0
Reputation points
commented 2026-06-11T19:58:02.05+00:00
Erland Sommarskog
134.6K
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-29T09:44:03.1433333+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(156.8, 19%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vivek Mendse (vmendse)
0
Reputation points
commented 2026-06-11T06:35:53.7566667+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-07T17:39:23.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(240, 99%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mantini, Ronald M
6
Reputation points
commented 2026-06-10T20:06:09.6266667+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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-06-01T14:17:15.8166667+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, 30%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Dipak Nile
0
Reputation points
commented 2026-06-10T07:42:36.7633333+00:00
Erland Sommarskog
134.6K
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-27T10:13:52.5833333+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(227.2, 12%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Erik Tkac
0
Reputation points
commented 2026-06-10T06:48:52.4433333+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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-26T06:58:27.8+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(137.6, 63%, 23%)' 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)
Lackner, Mario
0
Reputation points
commented 2026-06-10T06:39:34.5433333+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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 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(297.6, 30%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-22T02:04:04.07+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(236.8, 2%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIS%3C/text%3E%3C/svg%3E)
ITD-Sreng Channy
0
Reputation points
recommended 2026-06-09T15:35:47.6133333+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(227.2, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-06-03T08:08:57.19+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(230.39999999999998, 73%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-26T22:09:12.9266667+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(115.19999999999999, 61%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEO%3C/text%3E%3C/svg%3E)
elamin osman
0
Reputation points
commented 2026-06-09T05:19:10.5733333+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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-06-08T17:06:39.55+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(70.4, 5%, 16%)' 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)
Rosita
0
Reputation points
answered 2026-06-08T21:06:13.5666667+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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2025-11-03T16:21:04.7733333+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(256, 92%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
John McKenna
0
Reputation points
commented 2026-06-08T20:48:19.75+00:00
Erland Sommarskog
134.6K
Reputation points MVP
Volunteer 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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2025-04-14T10:14:50.65+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(249.60000000000002, 37%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-06-02T07:29:39.0266667+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(118.4, 96%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
MOUNIKA DHUPAM
0
Reputation points
commented 2026-06-05T12:23:35.3833333+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(137.6, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-20T07:28:48.0066667+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(16, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-05-06T03:12:42.8866667+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, 41%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-04-20T17:33:12.6733333+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(131.20000000000002, 98%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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
SQL Server Database Engine
Core component of SQL Server for storing, processing, and securing data
720 questions
asked 2026-04-17T07:24:16.13+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(44.800000000000004, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kamarur Rama
0
Reputation points
recommended 2026-06-04T19:07:15.7866667+00:00
Madhavi Taniparthi
0
Reputation points Microsoft External Staff
Moderator