155 questions with SQL Server Database Engine tags

Sort by: Updated
0 answers

Availability Group Listener

I have four servers: a Domain Controller server, a Primary SQL Server, a Secondary SQL Server, and a fourth server intended to be the Listener server. All three servers—the Primary SQL Server, Secondary SQL Server, and the Listener server—are joined to…

SQL Server Database Engine
asked 2025-05-04T13:22:40.82+00:00
Haron Y 0 Reputation points
0 answers

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.

I am trying to install SQL server 2022 and I keep getting the same error: 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…

SQL Server Database Engine
asked 2025-05-04T12:40:55.49+00:00
Sai Deepika 0 Reputation points
0 answers

I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms

I am not seeing any option to upgrade. I am trying to connect to my Azure SQL datadase from ssms

SQL Server Database Engine
asked 2025-05-03T19:29:31.69+00:00
Moyan Martin 0 Reputation points
commented 2025-05-04T07:57:22.12+00:00
Erland Sommarskog 120.3K Reputation points MVP
2 answers

SQL Server Buffer Pool Persistence Feature Request

SQL Server Buffer Pool Persistence Feature Request Could SQL Server implement a feature to export buffer pool data? This would eliminate the need for data warm-up after database restarts or initial startups. By directly importing previously saved buffer…

SQL Server Database Engine
asked 2025-05-03T14:12:23.3433333+00:00
Steven Lam 20 Reputation points
commented 2025-05-04T07:54:31.1833333+00:00
Erland Sommarskog 120.3K Reputation points MVP
0 answers

MSSQL connection in Visual Studio Mac->(Socket Exception)

HI Community! I am facing the following problem and it is driving me crazy. I was creating a SQL Server in Azure, and I was trying to connect via Visual Studio Code, but using the exactly same configuration n Mac I am getting this error…

SQL Server Database Engine
asked 2025-05-03T20:21:38.7133333+00:00
moialbla 5 Reputation points
1 answer

Unable to install SQL server. Error code : -2068119551

I keep fail to install the SQL server. I have already tried using Basic and Media which is ISO. When i used ISO, the error is -The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an…

SQL Server Database Engine
asked 2025-05-02T17:11:52.83+00:00
Blaze 0 Reputation points
answered 2025-05-03T15:34:43.4633333+00:00
Erland Sommarskog 120.3K Reputation points MVP
1 answer

How to fix SQL Server Setup has encountered the following error: Failed to retrieve data for this request..

I'm trying to patch SQL Server 2019 in a clustered environment. The setup is failing with this error: Setup has encountered the following error: Failed to retrieve data for Summary.txtthis request..Detail.txt

SQL Server Database Engine
asked 2025-05-02T08:55:59.86+00:00
Talent Mabuto 0 Reputation points
answered 2025-05-02T10:01:10.67+00:00
Alban Berisha 80 Reputation points
1 answer

Issue to restore the schema

Dear all, How to resolve it below? Exclusive access could not be obtained because the database is in use. I ran the following     USE db_to_restore       go       ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE       go   but it…

SQL Server Database Engine
asked 2025-04-25T03:14:41.97+00:00
Peter_1985 2,731 Reputation points
edited a comment 2025-05-02T06:48:40.9333333+00:00
Peter_1985 2,731 Reputation points
1 answer

Third party backup tools for SQL server

Anyone please share a few names of good and faster backup tools for SQL server? Preferably a snapshot of physical file backup It is for stand-alone server and should support VM too.

SQL Server Database Engine
asked 2025-04-24T18:18:03.1466667+00:00
Asharaf Pattarathil 0 Reputation points
commented 2025-05-02T05:48:02.1333333+00:00
Olaf Helper 46,636 Reputation points
0 answers

MDS migration - No data in the mdm view MasterDataServices

Hi , I migrated a model of Master Data Services using MDSModelDeploy.exe createpackage -package "C:\temp\pck.pkg" -model "Product" -service MDS1 -includedata -version VERSION_1 and MDSModelDeploy.exe deploynew -package…

SQL Server Database Engine
asked 2025-05-01T09:43:27.76+00:00
Maneesh Murali 0 Reputation points
edited the question 2025-05-01T10:15:07.23+00:00
simo-k 7,885 Reputation points
1 answer

SQL Server error code 4014 on Linux

Hi there! I'm getting an error 4014, severity 20, state 10 error in my SQL Server error log. It seems to happen at random intervals. This is for a SQL Server 2022 instance running on Red Hat Enterprise Linux 9.5. The client is making a connection using…

SQL Server Database Engine
asked 2025-04-29T16:04:17.6766667+00:00
Tim Coleman 0 Reputation points
commented 2025-04-30T15:17:33.2433333+00:00
Tim Coleman 0 Reputation points
3 answers One of the answers was accepted by the question author.

While upgrading SQL server showing mentioned error all settings and bit are same.

While upgrading SQL server showing mentioned error all settings and bit are same urgent

SQL Server Database Engine
asked 2025-04-27T10:36:04.7566667+00:00
Anandhswarupp 165 Reputation points
accepted 2025-04-30T11:02:15.8366667+00:00
Anandhswarupp 165 Reputation points
0 answers

How to get audit details from sys.fn_get_audit_file, sys.dm_audit_class_type_map and sys.dm_audit_actions ?

Hi, I want to extract audit details by using following dmvs SELECT distinct event_time, succeeded, server_principal_name, database_name, object_name, statement,fng.action_id ,da.name,fng.class_type FROM sys.fn_get_audit_file('C:\Audit*.sqlaudit',…

SQL Server Database Engine
asked 2025-04-30T10:31:00.4933333+00:00
Yasir Anis Janjua 0 Reputation points
0 answers

Failed to update the SQL server 2019 CU27+GDR with KB5040948

Dear All, Currently I'm facing and issues of applying SQL server 2019 CU as below: Summary the Step:  1. Unable to open the file installer of KB5040948, as below: The below are the error logs in Setup Bootstrap log: Overall summary: Final result: The…

SQL Server Database Engine
asked 2025-04-30T08:49:13.38+00:00
Ung Seyha 21 Reputation points
1 answer

Not able to see 'select instance' option while upgrading the server.

while upgrading the SQL server 2017 to 2019 in upgrade process in my company laptop not able to see 'select instance' WhatsApp Image 2025-04-26 at 3.48.07 PM.jpeg option. 1.server name is correct. 2.upgrading same instance. How to fix the issue to…

SQL Server Database Engine
asked 2025-04-26T10:25:30+00:00
Anandhswarupp 165 Reputation points
answered 2025-04-30T07:28:56.2433333+00:00
Anandhswarupp 165 Reputation points
0 answers

Server Agent job running an SSIS package fails with the error: “The step did not generate any output. The return value was unknown. The process exit code was -1073741502. The step failed.”

Server Agent job running an SSIS package fails with the error: “The step did not generate any output. The return value was unknown. The process exit code was -1073741502. The step failed.”

SQL Server Database Engine
asked 2025-04-29T23:05:32.8866667+00:00
synccale 0 Reputation points
edited the question 2025-04-29T23:10:02.1033333+00:00
synccale 0 Reputation points
0 answers

sp_executesql is not working when sql server is running in a container

sp_executesql is not working when sql server is running in a container. The issue only happens when I specify collation as Latin1_General_BIN docker command: docker run -d -p 1433:1433 -e 'ACCEPT_EULA=Y' -e "MSSQL_SA_PASSWORD=$db_password" -e…

SQL Server Database Engine
asked 2025-04-28T04:24:18.5333333+00:00
Yeturu Jagadeesh Reddy 0 Reputation points
commented 2025-04-29T14:04:11.3933333+00:00
Dan Guzman 9,376 Reputation points
0 answers

SQL Database writes suddenly slow.

Writing to SQL Server Database has suddenly become very slow since April 26th 2025. Everything is run on premise within the same region. Nothing has changed on our end. Writing tasks that once took 11 seconds now take 3 minutes. Writing tasks that once…

SQL Server Database Engine
asked 2025-04-29T11:53:57.68+00:00
R 0 Reputation points
1 answer

How to index vector fields for semantic search in sql server azure

CREATE VECTOR INDEX idx_OpenAIEmbedding ON dbo.table_name (OpenAIEmbedding) WITH ( VECTOR_DIMENSION = 1536, -- Assuming OpenAI embedding dimension SIMILARITY_FUNCTION = 'COSINE' ); Started executing query at Line 1 Msg 343, Level 15, State 2, Line…

SQL Server Database Engine
asked 2025-04-28T14:48:30.7966667+00:00
Jarle Holt 0 Reputation points
answered 2025-04-29T05:23:05.7666667+00:00
Olaf Helper 46,636 Reputation points
0 answers

How to fix the below issue? I have tried all possible ways including cleanup and reinstalling but nothing worked and was exhausted of this issue. Kindly help me to sort out this issue.

How to fix the below issue? I have tried all possible ways including cleanup and reinstalling but nothing worked and was exhausted of this issue. Kindly help me to sort out this issue.

SQL Server Database Engine
asked 2025-04-26T14:13:18.2733333+00:00
sathish kumar 0 Reputation points
commented 2025-04-28T11:03:33.25+00:00
Olaf Helper 46,636 Reputation points