How to resolve issue of Audit log table containing incorrect data?
We have created a parent table & child table in SQL Server database. For one parent record, there are multiple child records. When a child record in updated, a Stored Procedure is called in which a few fields of all the child records are updated that…
SQL Server | Other

sql cluster failover slower failover when only cluster and client network fails much faster when all networks fail
We have setup a simple two node SQL Server Cluster using SQL cluster (not WSFC windows cluster), plus witness disk, with two network adaptors on each node Cluster network 1 = 'Cluster and Client' / Cluster network 2 = 'Cluster only'. SQL server version -…
SQL Server | Other
SQL cluster cannot failover. SQL services cannot start
Hi, I have a 2 node SQL server cluster which cannot failover. The SQL program and DB are located in the shared disk When we try to failover the resource, it cannot auto failover from node A to B. We need to stop node A, manual active all resource in node…
Windows for business | Windows Server | Storage high availability | Clustering and high availability
SQL Server | Other
MSOLEDBSQL19 driver seems to ignore TrustServerCertificate=yes if SQL Server Force Encryption is yes
Microsoft SQL Server 2019 with GDR 2101 (KB5021125) is installed on a Windows Server 2019 computer. The SQL Server has a self-signed certificate and is configured with Force Encryption = yes. A Windows Server 2012 R2 computer has Microsoft OLEDB…
SQL Server | Other
I have a two procedure, first one for Insert and the second one for update, When I update the table using "prcImage", it doesn't update. Can anyone help me to solve this. I provide the table and store procedures check it and also I provide the .cs Code
This is my table CREATE TABLE [dbo].[UserProfile] ON [PRIMARY] This is my 1st Store Procedure ALTER proc [dbo].[prcDataSubmit] @fname varchar(20), @lname varchar(10), @contact char(15), @password varchar(50) as begin declare @yy char(4) declare @mm…
Developer technologies | ASP.NET | Other
SQL Server | Other
Exit code (Decimal): -2068052377Error Invalid command line argument. Consult Windows Installer SDK..please help me fixing this
Log folder path C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220218_192800
SQL Server | Other
SQL Server 2019 Installation Fails due to 0x84BB0001 error code
Multiple feature installations (e.g., Python, R, Database Engine Service and others) fail during SQL Server 2019 express with advanced service installation. The summary reports (see attached) states the same error code and error descriptions for all…
SQL Server | Other
Unable to install SQL server
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Migration Assistant
SQL Server Analysis Services
SQL Server | Other
How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..
Hi Experts, For the first time, we install New SQL Failover clustering on primary host and it success, however when we tried to install now the SQL on the secondary host as Add node SQL failover cluster, we encountered an error at the beginning of the…
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
SQL Server | Other

SQL Server LocalDB Crashes on Windows 11 (c0000005) — Cannot Start Instances
I am unable to start any SQL Server LocalDB instances on my Windows 11 Pro system (Build 22621.5624) with 32 GB RAM and an SSD with 4 KB+ physical sectors. I have tried both LocalDB 2017 (v14.0.1000.169) and 2019 (v15.0.4382.1),…
SQL Server | Other

"Unable to locate package msodbcsql17" when installing on python:3.13 image in Docker
Until a pair of days ago, I had a Dockerfile with these instructions, that allowed me to install msodbcsql17, to be able to connect my project to a MSSQL Database, but for some reason, since 2 days ago it started failing, and we didn't change…
SQL Server | Other
Transaction Log Cannot Be Truncated After Memory-Optimized Filegroup Removal
Hello there, One of our clients is facing an issue with a database where the memory-optimized filegroup was forcibly removed using DBCC CHECKDB (test, REPAIR_ALLOW_DATA_LOSS). The database remains functional, but the transaction log continues to grow and…
Developer technologies | Transact-SQL
SQL Server | Other
Why MSDN deprecates the AddWithValue method
I am trying to connect to a SQL Server table and update or register data in a program created in C#. In order to create a program that can take measures against SQL injection and support N prefixes, I am thinking of using the AddWithValue method, a…
Developer technologies | Visual Studio | Other
SQL Server | Other
Developer technologies | C#
Anyone having horrible performance in DPM 2025?
Anyone else experiencing horrible performance with DPM 2025? After upgrading from the latest update rollup of DPM 2022, we have been experiencing major issues that after about a week of operation make the system unusable and requiring reboot. After…
SQL Server | Other
How to setup ODBC Connection with Kerberos?
Hello, I'm trying to setup a ODBC connection from Windows Server to Hive data sources. The data sources itself uses a Kerberos for authentication, so it is required kinit or keytab. When i tried to setup the ODBC i always get a error like…
SQL Server | Other
SQL Server 2019 Installation Error : 0x851a0019
I am trying to Install SQL Server 2019 Developer Edition in my personal laptop for some training purposes. But during installation, I keep getting the 0x851a0019 Could Not Find Database Engine Startup Handle error. I have tried changing the SQL…
SQL Server | Other
I am unable to download SQL server.While downloading it showing as Opps...Unable to install SQL server(setup.exe).Exit code (Decimal):Error description.Wait on the database Engine recovery handle failed.Check the SQL server error log for potential causes.
I am unable to download SQL server.While downloading it showing as Opps...Unable to install SQL server(setup.exe).Exit code (Decimal):Error description.Wait on the database Engine recovery handle failed.Check the SQL server error log for potential…
SQL Server | Other
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON + SQL Server
Hi Everyone, I am seeking help with analyzing an issue related to SQL Server linked server connections. Here is a description of the problem. All SQL server databases servers are on-premises. Scenario 1: (Working Properly) We tried to connect SQL server…
Azure SQL Database
SQL Server | Other
Microsoft Security | Microsoft Entra | Other

My 2022 SQL Server will not install
I have tried nearly everything that I can think of to make it work, but it refuses to install. The attached files are from an attempt at using the Developer option to download. Screenshot 2025-08-07 210604.png Screenshot 2025-08-07 212904.png
SQL Server | Other
How to Calculate salary of employee
I am calculating salary using below query SELECT '29' as Total_Days,'28' as Present_Days, (14000 / 29) AS Per_Day, (14000 / 29) * 28 AS Total_Salary; But Total_Salary should be 14000 because Total_Days 29 and Present_Day 29