697 questions with SQL Server Database Engine tags

Sort by: Updated
1 answer

Information on installation of Security Update for the Microsoft ODBC Driver for SQL Server.

I would like to know more about the installation of Security Update for the Microsoft ODBC Driver for SQL Server. Let us say, I need to install the KB (KB5037571) and I am using Microsoft catalog for downloading the binaries. However, I see many binaries…

SQL Server Database Engine
asked 2026-01-21T11:46:59.9333333+00:00
Dhanraj D 16 Reputation points
commented 2026-05-03T12:30:42.6333333+00:00
Nicolas Cardenas-Rada 0 Reputation points
2 answers

how to sucessfully connect sql Smm server profile to database engine?

i tried connecting sql 2025 model of server profiler 22 in my system of DESKTOP-UL2OACD BUT its showing TITLE: Connect to Server Cannot connect to DESKTOP-UL2OACD\iwunor kelechi. ADDITIONAL INFORMATION: A network-related or instance-specific error…

SQL Server Database Engine
asked 2026-05-02T14:05:18.68+00:00
Iwunor kelechi 0 Reputation points
answered 2026-05-02T20:47:59.19+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
2 answers

Tell me most used SQL server administration tools and some examples

I need to cover the most commonly used tools for administering SQL Server, such as SSMS, Azure Data Studio, sqlcmd, etc., along with practical examples of how each tool is used. Could anyone provide an overview of the most popular SQL Server admin tools…

SQL Server Database Engine
asked 2026-04-29T22:12:54.1066667+00:00
Gurdeep Vaidya 0 Reputation points
edited the question 2026-04-30T18:37:51.9033333+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
1 answer

What is the proper syntax

Hi, According to the documentation at https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver17, I can use the following syntax: ALTER TABLE [draft].[dbo].[temp2] ADD PRIMARY KEY(id) WITH( FILLFACTOR = 20 |…

SQL Server Database Engine
asked 2026-03-27T22:37:37.0366667+00:00
Igor Korot 56 Reputation points
recommended 2026-04-30T05:27:45.73+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Not able to install Microsoft SQL Express

I have attempted installation multiple times, but it keeps failing. Steps I have already tried: Cleaned up old SQL Server components and services Verified prerequisites (.NET Framework 4.8, Visual C++ Redistributables, Windows updates) Ran installer…

SQL Server Database Engine
asked 2026-03-26T16:15:30.4366667+00:00
Bobbala Anusha 0 Reputation points
recommended 2026-04-30T05:27:24.1+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
1 answer

transactional replication between non-domain servers

Hi all, I have two sql server database servers. These are on the same network but there is no domain server. Can I configure these servers for transactional replication ? I know this is possible but how? Any document do you have to do this? Any…

SQL Server Database Engine
asked 2026-04-24T11:40:43.4133333+00:00
yunus emre ISIK 261 Reputation points
commented 2026-04-30T04:47:16.9966667+00:00
Lakshmi Narayana Garikapati 1,310 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
commented 2026-04-30T04:43:14.7666667+00:00
Lakshmi Narayana Garikapati 1,310 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
commented 2026-04-30T04:41:19.7566667+00:00
Lakshmi Narayana Garikapati 1,310 Reputation points Microsoft External Staff Moderator
2 answers

vs_SSMS installation - Destination URLs

Dear all, I'm installing vs_SSMS (SQL Server Management Studio) on a client's server. I requested them to open internet connection to be able to install SSMS as i know that the installation once it runs, will download the required files. The client's IT…

SQL Server Database Engine
asked 2026-01-13T12:48:10.6633333+00:00
Alaa Al Halabi 0 Reputation points
commented 2026-04-29T14:49:37.47+00:00
Newman, Scott 0 Reputation points
1 answer

SQL Server Audit / Extended Events – Role‑based (sysadmin) filtering limitations

Hello Microsoft Team, We are implementing security monitoring for sysadmin account usage on an on‑premises SQL Server instance and would like to know what EX events or Audit to achieve our goal? We tried Audit and XE events but those are capturing all…

SQL Server Database Engine
asked 2026-04-24T17:19:09.7+00:00
Uday Paleti 0 Reputation points
commented 2026-04-29T13:06:36.3866667+00:00
Uday Paleti 0 Reputation points
1 answer

SQL Agent job fails to run Restart-Service but works interactively

I have a SQL Agent job that runs a CmdExec step using a proxy account. The text of this step is: powershell.exe -ExecutionPolicy Bypass -File D:\Scripts\RestartService.ps1 The content of this script is: Restart-Service -DisplayName "Some…

SQL Server Database Engine
asked 2026-04-28T10:24:00.1766667+00:00
Peter Bishop 256 Reputation points
commented 2026-04-29T09:06:51.69+00:00
Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
2 answers

Erro na instalação do SQL Server 2025 express - Exit Code-2061893606

Prezados, Estou enfrentando um problema recorrente ao tentar instalar o Microsoft SQL Server 2025 Express Edition em meu computador com Windows 11. Durante o processo de instalação, o setup falha com a seguinte mensagem: Exit code (Decimal):…

SQL Server Database Engine
asked 2026-04-25T17:49:50.47+00:00
Joao Beluso 0 Reputation points
commented 2026-04-29T05:50:11.7766667+00:00
Akhil Gajavelly 1,820 Reputation points Microsoft External Staff Moderator
2 answers

Deux codes d'activation de Ms MSQL Svr runtime 2022 lot ESD ne fonctionnent plus

Bonjour, Nous avions commandé deux licences SQL serveur 2019 Std Runtime 2022 lot EDS OEI 5 clt avec les cartons et tous les numéros de série encore disponibles, mais les serveurs sur lesquels ces licences ont été activées sont depuis quelques jours…

SQL Server Database Engine
asked 2026-04-14T16:11:53.8566667+00:00
Nawal TAHIRI 0 Reputation points
recommended 2026-04-28T16:24:54.2933333+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server 2025 Benchmarking with Vector Database

Hello folks, I’m looking for guidance on how to benchmark SQL Server 2025 with vector database workloads. Specifically, I’m interested in the following: Is there a ready‑made database backup (for example, 10 million or 100 million vectors) that can be…

SQL Server Database Engine
asked 2026-04-13T12:39:16.3266667+00:00
anup bharti 0 Reputation points
recommended 2026-04-28T16:24:29.4166667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

Error description: Could not find the Database Engine startup handle or Error Code 1639

I feel like ive tried everything, ive even completly reset my pc. I was orginally trying to install SQL Server 2025 Devolper edition but i also tried the 2022 version once and got handle error there as well. My sector size is 4096. I dont have the old…

SQL Server Database Engine
asked 2026-04-02T20:49:47.2166667+00:00
Miller, Madisyn 0 Reputation points
recommended 2026-04-28T16:22:52.59+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers

sql server crashes when restoring a DB

We recently installed sql server 2025 on a linux machine. While trying to restore a DB previously taken from a sql server 2016 system, the new sql server 2025 always crashes.

SQL Server Database Engine
asked 2026-03-04T20:00:51.7633333+00:00
Domouchtsis, Petros 0 Reputation points
recommended 2026-04-28T16:19:33.3466667+00:00
Madhavi Taniparthi 0 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

SQL Express 2025 - database size limit

Hi, I’ve installed SQL Server Express 2025 on a Windows Server 2019 Standard machine. I created a new instance and restored a database that was previously running on SQL Server Express 2019. The database size is currently close to 10 GB, and I only have…

SQL Server Database Engine
asked 2026-04-23T11:54:27.3833333+00:00
Mateusz Wantoch-Rekowski 20 Reputation points
accepted 2026-04-28T07:17:04.96+00:00
Mateusz Wantoch-Rekowski 20 Reputation points
2 answers

POC: Best approach to automate DB Query Stress Testing in CI/CD Pipeline for .NET Core + SQL Server + AKS?

Hi Community, We are planning a POC to automate database query stress and load testing integrated into our CI/CD workflow. Looking for guidance on tools, patterns, and real-world experience. Our Tech Stack: Backend: .NET / .NET Core Web API …

SQL Server Database Engine
asked 2026-04-17T16:07:06.1566667+00:00
Sikdar, Sameer 0 Reputation points
commented 2026-04-28T04:40:02.2833333+00:00
Akhil Gajavelly 1,820 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
commented 2026-04-27T04:49:33.5033333+00:00
Lakshmi Narayana Garikapati 1,310 Reputation points Microsoft External Staff Moderator
2 answers

SQL server generating different query_id for same query_text_id after mirroring failover

I am facing a strange problem with one of my SQL Server 2017 Clusters. I faced a query regression in the past and forced a known good plan for that query_id in query store. When the planned database failover happens every month for OS patching from HostA…

SQL Server Database Engine
asked 2026-01-30T13:50:19.4766667+00:00
udhayan d 181 Reputation points
commented 2026-04-23T09:15:01.8266667+00:00
Akhil Gajavelly 1,820 Reputation points Microsoft External Staff Moderator