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
Ag listener fail to offline in 2 node always on without AD
Let me describe my env first: Two nodes always on without domain (with witness share file) Both node is sql server 2022 and windows server 2022 Both nodes are in the same subnet Set DNS server for these two nodes Didn’t register A record in DNS …
SQL Server Database Engine
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it logs many thing, Q1) can i reduce few thing so that file size and recording that is wirting from buffer to file can be reduced, thus i will save some resources. q2) and can i add few…
SQL Server Database Engine
Unreliable Microsoft.ACE.OLEDB.12.0. Excel import works sometimes
Hello I have a query that works all the time, 100 % success. I have a second one, with a different Excel file, that works the first 2 or 3 times I run it in a row. After that, the next run will run indefinitely and any other attempt at running any…
SQL Server Database Engine
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
SQL Server 2022 vs 2019 Query Performance gap
I am facing a performance issue with an SQL query. The query is generated dynamically via the webapp, I am testing with a static version to make things simpler. The SQL query includes temp tables and columns which get their values recalculated with…
SQL Server Database Engine
Trouble configuring SQL Server Always On
I have created an AD setup. Joined two sql vms(primary and secondary) into that AD. I have then installed failover clustering on both the sql nodes, and created a cluster. Then I have enabled SQL Server Always On Availability Groups. Next, while…
SQL Server Database Engine
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
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
Wait on the Database Engine recovery handle failed
Overall summary: Final result: Failed: see details below Exit code (Decimal): -2061893606 Start time: 2025-12-07 16:55:50 End time: 2025-12-07 16:59:41 Requested action: …
SQL Server Database Engine
SQL Server 2022 CU18 Crashing with EXCEPTION_ACCESS_VIOLATION
SQL Server 2022 CU18 is experiencing crashes approximately 1-2 times a month since installation. The error log shows the following message: 2025-03-18 08:20:04.77 spid70 SqlDumpExceptionHandler: Process 70 generated fatal exception c0000005…
SQL Server Database Engine
Microsoft Entra ID not working in SQL Server VSCode
Whenever I try to use my Microsoft Entra ID on the SQL Server extension in VSCode, I click 'Sign in', which takes me to the authentication page in my browser where I sign in. I get the page that says I am signed in and can close the browser, but the…
SQL Server Database Engine
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
Readable mirror database on Database mirroring
Hi expert, is Mirror database readable on Database Mirroring concept ? if YES, how to set it? great thanks & appreciation best regards, Urbel
SQL Server Database Engine
HOW TO FIX SQL SERVER(Local Instance MYSQL80)
MY SQL SERVER IS NOT RUNNING AND IT IS NOT CONNECED
SQL Server Database Engine
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.
hi, hi, i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means. DROP EVENT SESSION [CaptureSlowQueries] ON SERVER go CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER ADD EVENT…
SQL Server Database Engine
how fix the error that occurs when I try to install SQL Server 2019
The following is the error message that I keep getting each time I tried to install SQL Server 2019: Unable to install SQL server (setup.exe). Exit code (Decimal): -2061893606 Error description: Wait on the Database Engine recovery handle failed. Check…
SQL Server Database Engine
Setting Up Microsoft SQL Server on New Device
Hello, I recently set up MS SQL Server on a new computer. On my old machine, the server name was OLDCOMPUTER#\SQLEXPRESS and it used Windows Authentication with the username OLDCOMPUTER#\atsuser. On the new computer, the username is based on the new…
SQL Server Database Engine
BROOOOO I am trying to install sql server 2022 version but its saying fare wall warning no matter how many help i saw i couldnt just figure out the problem please help me
Bruhhhh Why cant i find the goddamn problem! i been trying to install the sql server but everytime i am stuck at Install Rules where there is a Windows farewell warning!!! Eventough i install it anyways i have a problem at Installation process where it…
SQL Server Database Engine
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) とは結び付いていない。