266 questions with SQL Server Database Engine tags

Sort by: Updated
1 answer

SQL SERVER 2022 INSTALL FAILING File activation error on a drive that has never existed on my pc. File activation failure. The physical file name "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\modellog.ldf"

This is definitely a weird issue. Let me setup the scenario. Just bought a new CyberPowerPC with a AMD Ryzen 5 5500, 3600 mhz, 6 core(s) , 12 logical processors. My issue is with installing SQL server 2022 developer's edition. Checking the error log I…

SQL Server Database Engine
asked 2025-07-05T20:09:34.1733333+00:00
kevin miller 0 Reputation points
answered 2025-07-06T08:27:52.88+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer

Problème d’installation de SQL Server 2022 sur un serveur RDS avec User Profile Disks (UPD)

Je tente d’installer SQL Server 2022 Standard sur un Windows Server 2022 qui héberge déjà les rôles RDS (Remote Desktop Services), avec la fonctionnalité User Profile Disks (UPD) activée. L’installation échoue au niveau du moteur de base de données…

SQL Server Database Engine
asked 2025-07-03T15:26:50.9+00:00
Charlie GOURDIEN 0 Reputation points
answered 2025-07-04T14:46:45.3466667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
3 answers

SQL upgrade from 2019 to 2022. Error 1639. Specified instance {My GUID} via transform: InstID02.mst;: InstName01.mst is already installed. MSINEWINSTANCE requires a new instance that is not installed.

Hi there, We had a tech attempt to upgrade SQL Server from 2019 Standard to SQL Server 2022 Standard. The upgrade initially failed with the following error: 1706. An installation package for the product Microsoft OLE DB Driver for SQL Server cannot…

SQL Server Database Engine
asked 2025-06-30T13:29:58.4433333+00:00
Chris Rutherford 5 Reputation points
commented 2025-07-03T20:00:10.3466667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2 answers

SQL Server 2025 Installation Error

Action required: Use the following information to resolve the error, and then try the setup process again. Feature failure reason: An error occurred for a dependency of the feature causing the setup process for the feature to fail. Error details: § Error…

SQL Server Database Engine
asked 2025-06-10T14:07:02.23+00:00
Usman Jalil 0 Reputation points
commented 2025-07-03T19:37:47.4066667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer

SQL Server Data Import Error

I'm getting this error when trying to import an excel file into my server: TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: A network-related or instance-specific error has occurred while…

SQL Server Database Engine
asked 2025-07-02T19:55:22.25+00:00
Erik Rodriguez 0 Reputation points
answered 2025-07-02T21:25:14.44+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer

Error in installing Sql Server Express 2022

Use the following information to resolve the error, and then try the setup process again. Feature failure reason: An error occurred during the setup process of the feature. Error details: § Error installing SQL Server Database Engine Services Instance…

SQL Server Database Engine
asked 2025-07-02T01:42:16.9366667+00:00
vinod singh 0 Reputation points
answered 2025-07-02T07:55:05.5966667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer

Sql server history is not updating

Hi Team,I one of my sql server, jobs are not showing last run outcome and last run details.we have only 4 jobs in this server.These jobs are weekly maintenance plans only.if i start one job and stop it immediately also,its not showing stopped.Sql server…

SQL Server Database Engine
asked 2025-07-01T08:50:03.27+00:00
ACDBA 421 Reputation points
commented 2025-07-02T07:38:04.58+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
0 answers

How to identify MS SQL Server enterprise core software installation

Discovery solution uses patterns that execute- WMI commands on SQL Server to identify the installed edition. Recently, we've observed that in some instances, the discovered edition is returned as "Enterprise Edition: Core-based Licensing." As…

SQL Server Database Engine
asked 2025-07-01T11:37:00.59+00:00
Srinivas Ramanujaiah 0 Reputation points
commented 2025-07-02T06:20:46.93+00:00
Srinivas Ramanujaiah 0 Reputation points
1 answer

How I can fix the bug during installation "Unable to install SQL Server (setup.exe) Exit code(decimal) -2068119511"

I've made this mistake several times now. First, I completely uninstall SQL Server, reboot and delete the remaining folders. But every time I reinstall, I get a negative error. Please help me to solve this problem!!! The log that I get during the…

SQL Server Database Engine
asked 2025-07-01T11:30:48.6866667+00:00
Manoilo Kate 0 Reputation points
answered 2025-07-01T21:34:15.8366667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2025 Public Preview Maintenance Wizard plan runtime error

2 issues with Maintenance Plans - for some reason now I cant modify or create any new Maint Plans. Not available and greyed out. When creating any Maintenance wizard plans such as "Misc Cleanup" or DB "Integrity check" scans I am…

SQL Server Database Engine
asked 2025-07-01T20:39:25.7266667+00:00
Shervey, Jeff 1 Reputation point
answered 2025-07-01T21:17:57.7066667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

CU18 patch failed on my sql server 2022. SQL server is not restarting (Database engine patch failed)

How to fix this error, i got this error after applying cu18 patch to sql 2022, the error only cites that sql server agent coulnt start as sql server is down, the event viewer error code is 7001

SQL Server Database Engine
asked 2025-06-27T01:39:30.5866667+00:00
RejoicePM 20 Reputation points
commented 2025-07-01T15:50:17.6+00:00
RejoicePM 20 Reputation points
0 answers

How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar

How to remediate hadoop-common-2.6.0.2.2.0.0-2041.jar vulnerabilities in SQL Server path/Program Files/Microsoft SQL Server/130/DTS/Extensions/Common/Jars/hadoop-common-2.6.0.2.2.0.0-2041.jar

SQL Server Database Engine
asked 2025-06-30T11:13:04.09+00:00
Gorla, Siva 0 Reputation points
commented 2025-06-30T11:35:45.39+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer

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 116 Reputation points
answered 2025-06-30T08:06:31.4833333+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
2 answers

I can't download SSMS, It provide Visual Studio in SSMS's Link

Dear, I can not download SQL Server Management Studio, while i click to Download SSMS it automatically download Visual Studio. Why this happed, i got this problem for a long time. This is the link…

SQL Server Database Engine
asked 2025-06-29T07:51:38.34+00:00
Sowrov 0 Reputation points
answered 2025-06-29T09:19:22.2666667+00:00
Berneice Heaney 0 Reputation points
1 answer

microsoft sql server 2022 installation error

The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start. even i followed all steps…

SQL Server Database Engine
asked 2025-06-25T08:53:41.03+00:00
BHARGAV G 0 Reputation points
answered 2025-06-25T20:56:42.47+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Where is the Microsoft SQL Server 2022 Express License Terms for Redistribution and Hosting?

Where is the Microsoft SQL Server 2022 Express License Terms for Redistribution and Hosting? For SQL Server 2005 Express through SQL Server 2014 Express, the page is here: https://www.microsoft.com/en-sg/download/details.aspx?id=29693 However, that page…

SQL Server Database Engine
asked 2025-06-24T18:31:45.9466667+00:00
MichaelL 20 Reputation points
commented 2025-06-24T23:57:40.19+00:00
MichaelL 20 Reputation points
1 answer

COBOL V9 - SQL server query processing is reporting error | Need Help

Hello Experts, Greetings to All ! In our environment, there exist a COBOL V9 version POD which connects to SQL server (2019) using ODBC driver V18. In this client-server design, during the query retrieval process from COBOL to SQL server , we are getting…

SQL Server Database Engine
asked 2025-06-24T09:29:45.16+00:00
Naren 25 Reputation points
commented 2025-06-24T20:57:26.3666667+00:00
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator
3 answers

Is MS ODBC driver 18.5.1.1 compatible with SQL Server 2025 for new JSON and VECTOR types?

Hello, I would like to test the new JSON and VECTOR types of SQL Server 2025 with the Microsoft ODBC driver for SQL Server. I have installed SQL Server 2025 CTP 2.0 on my Windows 11. For now I have MS ODBC driver 18.5.1.1 for Linux (Debian 12). Is this…

SQL Server Database Engine
asked 2025-06-12T12:44:51.11+00:00
Sebastien Flaesch 31 Reputation points
commented 2025-06-24T15:11:35.57+00:00
Sebastien Flaesch 31 Reputation points
3 answers

How many logical cores supported by SQL Server 2022 Standard Edition without purchasing more cores?

I am looking at purchasing Microsoft SQL Server 2022 Standard Edition to run on premise. When researching the editions online I can see that there is a maximum core count of 24 logical cores per instance. And then when I look at the pricing page…

SQL Server Database Engine
asked 2025-06-20T18:19:20.2633333+00:00
Brian Athans 0 Reputation points
commented 2025-06-23T02:39:59.59+00:00
Bruce (SqlWork.com) 78,006 Reputation points Volunteer Moderator
1 answer

Best method to upgrade SQL to new version and remove older versions

We have several Windows servers that have multiple versions of SQL Server installed. A few servers are running SQL Server 2012, 2014 and 2016 (at least there are components from each build). IinfoSec would like the old versions removed for auditing…

SQL Server Database Engine
asked 2025-06-20T20:24:01.47+00:00
Daniel Andryszak 121 Reputation points
commented 2025-06-22T10:49:20.2466667+00:00
Lakshya Kurup 10 Reputation points