528 questions with SQL Server Database Engine tags

Sort by: Updated
1 answer

SQL server 2014 for Calypso

I am trying to install SQL server as part of a program package ZEISS Calypso. I get though the install but it fails to start the service. I can not start it manually. I have made sure the TLS 1.2 and the .NET 3.5 are enabled. This is on Windows 10…

SQL Server Database Engine
asked 2025-12-04T16:35:45.21+00:00
Jay E Dorminey 0 Reputation points
commented 2025-12-05T16:15:57.8733333+00:00
Jay E Dorminey 0 Reputation points
2 answers

DB STARTUP events in AG replica SQL error log

HI Team, we got an Availability group with 4 nodes (1 primary, 2 synch nodes, 1 asynch node). in the secondary replica sql error logs I see frequent messages as below for various secondary databases. Example: Buffer Pool scan took 11 seconds: database…

SQL Server Database Engine
asked 2025-11-16T22:59:43.8533333+00:00
subhash-DBA 155 Reputation points
commented 2025-12-05T12:16:04.79+00:00
Lakshmi Narayana Garikapati 640 Reputation points Microsoft External Staff Moderator
2 answers

SQL Server installation fails with error 0x851A001A after removing old instances

Hi, I’m unable to install SQL Server 2025 Express or 2019 Express. The setup fails every time with: Error: Wait on the Database Engine recovery handle failed Exit code: -2061893606 (0x851A001A) Component: SQL Server Database Engine Services The setup…

SQL Server Database Engine
asked 2025-12-01T13:58:58.7866667+00:00
Ailin 0 Reputation points
commented 2025-12-05T12:11:56.1166667+00:00
Lakshmi Narayana Garikapati 640 Reputation points Microsoft External Staff Moderator
1 answer

SSMS not showing Attach Database/Locate Database Files Dialog DIR Tree.

I am unable to Attach a Database in SSMS. The Locate Database Files Dialog text is frozen on a USB port folder that no longer exists. Even entering a dummy database file *.mdf, the OK button does not enable. When I tried to repair SSMS, Error message;…

SQL Server Database Engine
asked 2025-05-07T12:34:09.6366667+00:00
Shane P. Watson 0 Reputation points
commented 2025-12-05T11:54:04.85+00:00
Lakshmi Narayana Garikapati 640 Reputation points Microsoft External Staff Moderator
1 answer

Changing Custom 445 Port for SQL Log Shipping

Hello team, We have a banking enclosed environment. Here we are planning to install SQL Server 2022 in DC and DR, and then there will be log shipping between DC and DR via shared network drive. Port 445 cannot be provided due to some bank compliance…

SQL Server Database Engine
asked 2025-11-04T17:01:27.8033333+00:00
Kiran Varekar 20 Reputation points
commented 2025-12-05T11:47:12.4933333+00:00
Marcin Policht 67,905 Reputation points MVP Volunteer Moderator
2 answers

What happens to my account when the Volume Licensing Service Center (VLSC) is replaced by the Microsoft M365 Admin Center?

ボリューム ライセンス サービス センター(VLSC) からMicrosoft M365 管理センターに変わったため、SQLサーバ2008R2や、2019のボリュームライセンスがダウンロードできない。 弊社のアカウントが現在Microsoft M365と紐づいているが、過去のボリューム ライセンス サービス センター(VLSC) とは結び付いていない。

SQL Server Database Engine
asked 2025-12-05T04:57:21.5133333+00:00
しんどう 0 Reputation points
answered 2025-12-05T10:31:20.8333333+00:00
Lakshmi Narayana Garikapati 640 Reputation points Microsoft External Staff Moderator
2 answers

SQL Configuration step issue in Ubuntu Instance

While configuring SQL Server for the first time on Ubuntu_22.04-x86_64-SQL_2022_Standard-2025.08.28, I encountered an error that occurs frequently. I need to retry the setup 2–3 times before it works properly. Any Solution to fix this part? ++ bash -c…

SQL Server Database Engine
asked 2025-12-04T05:16:29.8166667+00:00
Pratik Narottam Panchal 0 Reputation points
edited an answer 2025-12-05T05:15:59.57+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

Missing Client Protocols in SQL Server Configuration Manager

I installed SQL Server 2025, but when I try to enable TCP/IP from SQL Server Configuration Manager, the Client Protocols field is empty. I've tried everything: uninstalling, reinstalling, checking ports, using snap-ins—I'm at a loss. I have the correct…

SQL Server Database Engine
asked 2025-12-03T23:41:08.02+00:00
Serrato, Mario 0 Reputation points
answered 2025-12-04T22:53:41.9466667+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
2 answers

need to kill long running SPIDs

hi, i have seen in my server sometimes some SPIDs get stuck. so we find the logest running SPIDs and kill them . resons are many but in the last i have to kill them. so kindly tel me how to automate this task. on internet some one told me to, use…

SQL Server Database Engine
asked 2025-12-04T09:32:47.72+00:00
rajesh yadav 291 Reputation points
answered 2025-12-04T22:48:28.5133333+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
2 answers

Can I install SQL 2008R2 on server with TLS1.2 or higher enabled

Hello, I have a requirement to upgrade SQL 2000 databases. I am thinking to install SQL 2008R2 , restore SQL 2000 backup file on SQL 2008R2, upgrade database ( provided it goes through). If successful, i will upgrade it further to SQL 2016 or SQL 2019,…

SQL Server Database Engine
asked 2025-12-02T16:24:47.6533333+00:00
Mudit Gupta 81 Reputation points
commented 2025-12-04T18:03:41.5+00:00
Mudit Gupta 81 Reputation points
1 answer

When trying to create a SQL Managed Instance link, we keep receiving a "Create Failed for 'New Certificate'." error.

When trying to create a SQL Managed Instance link, we keep receiving a "Create Failed for 'New Certificate'." error. We have tried every instruction in documents we were able to find online. We've created master keys, we've verified…

SQL Server Database Engine
asked 2025-12-04T17:19:42.7333333+00:00
JoeP 0 Reputation points
answered 2025-12-04T17:19:54.4033333+00:00
Q&A Assist
2 answers

Migration of Data

Hello, What is is the best and most efficient (performance wise) method to migrate of full data from large database to small multiple database (microservices) during cutover. Thanks

SQL Server Database Engine
asked 2025-06-26T13:22:39.49+00:00
SVA 121 Reputation points
commented 2025-12-04T10:15:09.4833333+00:00
Singam shetty Sri ganesh 80 Reputation points Microsoft External Staff Moderator
3 answers

How to fix the SQL server to start - error logs " Master data"?

HI I just recently download SQL When i connect to sql server it give me error code 1067and try to sql server configuration manager to start sql server but it get me error msg which i attach the file or screenshot. please help me out .. errorlog.pdf

SQL Server Database Engine
asked 2025-07-14T18:50:22.7566667+00:00
Joli shah 0 Reputation points
commented 2025-12-04T10:13:45.42+00:00
Singam shetty Sri ganesh 80 Reputation points Microsoft External Staff Moderator
2 answers

How do I cancel a database restore that is stuck

I have a database restore that is stuck and been running for 3 hours. How do I cancel it?

SQL Server Database Engine
asked 2025-04-15T19:56:50.4233333+00:00
Patrick Nelson 0 Reputation points
commented 2025-12-04T06:53:07.5866667+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
2 answers

How to fix MS SQL Server Express 2019 startup error?

Hi guys. I'm trying to install MS SQL Server Express 2019 on Windows 11. I did end up installing MS SQL Server Express 2019 and verified my installation using "where sqllocaldb" on Windows Cmd. However, I get error when I try "sqllocaldb…

SQL Server Database Engine
asked 2025-04-05T06:35:53.54+00:00
SH Bae 0 Reputation points
edited a comment 2025-12-04T06:42:43.6133333+00:00
Shruti Dhruv 405 Reputation points Microsoft External Staff Moderator
1 answer

HOW TO FIX SQL SERVER(Local Instance MYSQL80)

MY SQL SERVER IS NOT RUNNING AND IT IS NOT CONNECED

SQL Server Database Engine
asked 2025-12-03T07:13:45.21+00:00
Isha Jangid 0 Reputation points
commented 2025-12-03T22:12:39.9566667+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
1 answer

begin stack dump error no sql server 2012

Tenho um micro com Windows Server 2008 R2 enterprise com o SQL Server 2012. Este vem apresentando falha. No Event Viewer aparece esta mensagem: The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 8 time(s). No log do SQL, no…

SQL Server Database Engine
asked 2025-12-03T10:51:55.7+00:00
answered 2025-12-03T22:10:06.2+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
1 answer

SQL SERVER 2022 FAIL TO INSTALL

PLEASE HELP I ATTACHED THE SQL SERVER REPORT ERROR. I WAS TRYING TO INSTALL SQL SERVER 2022 ON MY DESKTOP Summary_DESKTOP-SBG67VR_20251105_155239.txt Detail.txt

SQL Server Database Engine
asked 2025-11-05T07:04:06.2366667+00:00
RYU 0 Reputation points
commented 2025-12-03T21:45:55.0433333+00:00
Erland Sommarskog 128.6K Reputation points MVP Volunteer Moderator
1 answer

Transaction Replication - Missing data in Target

Good day Team, Source: SQL Server: DB Version: SQL-2019 CU-19 OS: Windows 2019 Target: SQL Server: DB Version: SQL-2022 OS: Windows 2022 Publisher and Distributor are the same as of Source Server Subscriber is the Target mentioned above.…

SQL Server Database Engine
asked 2025-11-06T15:00:40.53+00:00
Gladias Mariadoss 0 Reputation points
commented 2025-12-03T15:15:30.6366667+00:00
Gladias Mariadoss 0 Reputation points
1 answer

Alerts for low work tables from cache.

Greetings. "Percentage of work tables available from the work table cache is low (below 90% for 5m)" We use a product called Zabbix for alerting. Not my fav, but we've had it for a couple years now with no real complaints. As of this morning…

SQL Server Database Engine
asked 2025-04-02T15:49:48.3666667+00:00
chrisrdba 471 Reputation points
commented 2025-12-03T12:17:42.81+00:00
vinay kumar eshwara 0 Reputation points