237 questions with SQL Server Database Engine tags

Sort by: Updated
1 answer

Increased CPU usages during SQL manged instance Maintenance

One of our SQL Managed Instances experienced a CPU usage increase from 40% to 90%, despite a constant user workload. We noticed that SQL was restarted around time, and Azure has confirmed ongoing maintenance through notification. However, the maintenance…

SQL Server Database Engine
asked 2025-06-14T06:54:02.4666667+00:00
Joby Mathew 5 Reputation points
answered 2025-06-14T15:28:36.83+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
1 answer

Performance issue while reorganizing an index on a very large table

Hello Team, We're encountering a performance issue while reorganizing an index on a very large table (1.4TB with 1.5 billion records) in one of managed instance in other tenant. Since index reorganization is an online activity less impact our user…

SQL Server Database Engine
asked 2025-06-10T14:10:34.1266667+00:00
Joby Mathew 5 Reputation points
commented 2025-06-14T06:57:41.9066667+00:00
Joby Mathew 5 Reputation points
2 answers One of the answers was accepted by the question author.

How to give a user SQL permission to execute stored procedure using powershell invoke-sqlcmd

Hi All, Hope someone has a solution for me. I have a MS SQL 2016 server. I have created a stored procedure and set execute as to Owner. I would like to have standard user be able to run this stored procedure using the PowerShell command invoke-sqlcmd.…

SQL Server Database Engine
asked 2025-06-05T22:39:26.3333333+00:00
Craig Garland 336 Reputation points
commented 2025-06-13T21:46:13.39+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
1 answer

SQL Server Enterprise Edition (Server + CAL) + Software Assurance – Licensing Compliance with More Than 20 Cores

I would like to confirm if my current SQL Server configuration is compliant with Microsoft licensing rules. Here are the key points: ·       We have a Microsoft SQL Server Enterprise Edition license. ·       Our company has always Software Assurance. ·  …

SQL Server Database Engine
asked 2025-06-13T12:31:45.9466667+00:00
Jaroslaw Pelc 0 Reputation points
answered 2025-06-13T20:14:38.0133333+00:00
Bruce (SqlWork.com) 77,476 Reputation points 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-13T16:55:32.9+00:00
Davide 11 Reputation points Microsoft Employee
0 answers

SQL Server Always On – Intermittent Cluster Failures in Test Setup

I am reaching out to receive support for SQL Server Always On configurations, specifically involving multi-node clusters with geographically distributed replicas in a test environment. I am currently evaluating the integration of an asynchronous…

SQL Server Database Engine
asked 2025-06-13T14:17:10.49+00:00
Matthew Tanner 0 Reputation points
1 answer

Configure Resource Governor for SQL Jobs with SQL Login

How can a CheckDB job be configured to use Resource Governor to assign work to the checkDBworkpool for a SQL Login (specifically mylogin)? The challenge arises from the inability to create a proxy for SQL Logins when setting up the SQL job step, which…

SQL Server Database Engine
asked 2025-06-11T12:42:49.72+00:00
Sai Praneeth Eranti 210 Reputation points
edited a comment 2025-06-12T16:58:50.35+00:00
Sai Praneeth Eranti 210 Reputation points
0 answers

Unable to install sql server 2022 in Windows 11

Unable to install SQL server 2022 screen got stuck so please help me. I have attached screenshot for your reference.

SQL Server Database Engine
asked 2025-06-12T06:19:59.57+00:00
Ramchandra Bhuse 0 Reputation points
commented 2025-06-12T15:40:08.52+00:00
Balmukund 176 Reputation points Microsoft Employee
1 answer

Error installing SQL Express

I am trying to install SQL server Express 2022. I have tried a few times including using https://www.sql-easy.com/learn/how-to-uninstall-sql-server/ and https://vladdba.com/2025/01/22/repair-a-sql-server-instance/ to uninstall and repair the install. I…

SQL Server Database Engine
asked 2025-06-11T16:39:00.3966667+00:00
JB 0 Reputation points
answered 2025-06-11T21:33:29.53+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
2 answers

Understanding SMTP Authentication in SQL Database Mail Configuration

In the SQL Database Mail Configuration Wizard, basic authentication is currently being used. Does this imply the use of interactive or non-interactive login? Some articles suggest that providing a username and password constitutes interactive login,…

SQL Server Database Engine
asked 2025-05-06T08:24:08.3066667+00:00
Sai Praneeth Eranti 210 Reputation points
commented 2025-06-11T12:31:00.26+00:00
Sai Praneeth Eranti 210 Reputation points
0 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-06-10T21:22:34.47+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
0 answers

Unable to connect Azure SQL Managed Instnace to Azure Function APP

I am experiencing connectivity issue with Azure Function app attempting to connect to a SQL Managed Instance, both resource being configured on same Vnet. Azure Function cannot establish connection to SQL Managed Instance Connection Attempts are…

SQL Server Database Engine
asked 2025-06-10T16:21:16.3433333+00:00
Omkar Raikar 0 Reputation points
commented 2025-06-10T21:15:56.5066667+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Unable to install SQL Server 2022 for windows 10 enterprise

https://www.microsoft.com/en-in/sql-server/sql-server-downloads I clicked on SQL Server 2022 Developer and downloaded it. After the download, I clicked on the Basic option → accepted the terms → clicked Install. Once the installation was successful, I…

SQL Server Database Engine
asked 2025-06-05T09:50:26.5666667+00:00
Paul 20 Reputation points
commented 2025-06-10T20:52:57.8166667+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Unable to install SQL Server(setup.exe)

I encountered this error during installation. I have tried several methods, including uninstalling SQL Server from 'Programs and Features' and deleting SQL Server entries in 'regedit', but I still face the same error when reinstalling. The detail.txt…

SQL Server Database Engine
asked 2025-03-06T06:07:28.7+00:00
Thai Huy 25 Reputation points
commented 2025-06-10T07:43:48.34+00:00
焱磊 朱 0 Reputation points
2 answers

how do i change the code page in sql server

I want to change the code page on a database to work with some data that I am importing from Excel.

SQL Server Database Engine
asked 2025-06-08T23:35:22.23+00:00
Martin Cudeck 0 Reputation points
answered 2025-06-10T06:19:02.11+00:00
Olaf Helper 47,416 Reputation points
1 answer

Windows NT creating additional backups, aside from ASR backups

VM Palmdale shows full backups are being created by Windows NT Authority, this is concerning because we already have ASR backups running through azure, please advise why SQL would allow additional backups

SQL Server Database Engine
asked 2025-06-09T14:24:11.31+00:00
Jessica Willman 0 Reputation points
commented 2025-06-10T05:47:11.7866667+00:00
Balmukund 176 Reputation points Microsoft Employee
0 answers

How to fix Exit code (Decimal): -2068119551 when reinstalling SQL Server?

I reinstall SQL server and get this error at the end of the installation process. To be honest, I not sure which child tag to choose. Summary_Admin_20250609_135416.txt Detail.txt

SQL Server Database Engine
asked 2025-06-09T07:23:19.87+00:00
Hoang LE 5 Reputation points
commented 2025-06-09T12:41:20.0133333+00:00
Balmukund 176 Reputation points Microsoft Employee
0 answers

SQL Server (SQLEXPRESS)

hi, I am unable to start the Windows SQL Server (SQLEXPRESS) service. help me please

SQL Server Database Engine
asked 2025-06-05T18:23:32.4866667+00:00
Anderson Silva Oliveira 0 Reputation points
commented 2025-06-08T12:49:02.6366667+00:00
Balmukund 176 Reputation points Microsoft Employee
1 answer

Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606

Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. Can anybody help?

SQL Server Database Engine
asked 2025-06-08T09:31:30.89+00:00
Tsuki 0 Reputation points
commented 2025-06-08T12:46:55.86+00:00
Balmukund 176 Reputation points Microsoft Employee
2 answers

SQL EXIT Code 2061893606

Have purchased a new laptop for a bridge club which uses SQL as part of its scoring system On previous laptops I have had no issues with SQL However on the new laptop HP 17.3inch Laptop i7-cn3029TU I am unable to install SQL 2019 express or 2022…

SQL Server Database Engine
asked 2025-06-04T00:29:50.2766667+00:00
William R 0 Reputation points
commented 2025-06-05T21:48:27.9433333+00:00
Erland Sommarskog 121.3K Reputation points MVP Volunteer Moderator