151 questions
0 answers
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-05-02T08:55:59.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 33%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Talent Mabuto
0
Reputation points
answered 2025-05-02T10:01:10.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 28.999999999999996%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-04-25T03:14:41.97+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-04-24T18:18:03.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 9%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Asharaf Pattarathil
0
Reputation points
commented 2025-05-02T05:48:02.1333333+00:00
Olaf Helper
46,631
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
151 questions
asked 2025-05-01T09:43:27.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 66%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Maneesh Murali
0
Reputation points
edited the question 2025-05-01T10:15:07.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
simo-k
7,810
Reputation points
0 answers
SQL Elastic Pool Stuck on Scaling for 22 Hours
For performance testing I've scaled my SQL Elastic Pool from: General Purpose - 18 vCores - 2TB Storage to Business Critical - 128 vCores - 3TB Storage The main database in the pool has between 1TB to 1.5TB of data in, the rest have under 100GB and the…
SQL Server Database Engine
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 37%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-04-29T16:04:17.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-04-27T10:36:04.7566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-04-30T10:31:00.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 26%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYA%3C/text%3E%3C/svg%3E)
Yasir Anis Janjua
0
Reputation points
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
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)
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
151 questions
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
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-04-28T04:24:18.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 93%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
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
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 24%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
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
151 questions
asked 2025-04-28T14:48:30.7966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 41%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jarle Holt
0
Reputation points
answered 2025-04-29T05:23:05.7666667+00:00
Olaf Helper
46,631
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
151 questions
asked 2025-04-26T14:13:18.2733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 40%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
sathish kumar
0
Reputation points
commented 2025-04-28T11:03:33.25+00:00
Olaf Helper
46,631
Reputation points
0 answers
SQL DB not Found
Hi, I have created SQL Server with multiple SQL Database in it, but when I try to click the Database in the Azure Portal, it says Resource Not Found, I can connect to the same database in the SQL Server Management Studio, I have also tried getting the…
SQL Server Database Engine
151 questions
asked 2025-04-28T08:46:47.8233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 28.000000000000004%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Shabir jan
21
Reputation points
asked 2025-04-28T08:46:47.8233333+00:00
Shabir jan
21
Reputation points
0 answers
Error during setup process of SQL 2022 express
Detailed results: Feature: Database Engine Services Status: Failed Reason for failure: An error occurred during the setup process of the feature. Next Step: Use the…
SQL Server Database Engine
151 questions
asked 2025-04-28T02:58:13.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 81%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nick Parker
0
Reputation points
commented 2025-04-28T06:38:12.73+00:00
Nick Parker
0
Reputation points
1 answer
SSMA Data Migration Issue DB2 to MSSQL 2022
Hi Everyone, Greetings! Request your expert advice and support. We need to migrate the Tables from Source AS400 DB2 to Target MSSQL 2022 server. Following steps has been followed by us - Installed SQL Server Migration Assistant software for DB2,…
SQL Server Database Engine
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 63%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Cannot figure out why I'm getting this error: Msg 102, Level 15, State 1, Line 74 Incorrect syntax near ')'
Pretty new to SQL, I keep getting an error on the final bracket at the end of the code, but I can't figure it out. Anyone see any reasons? ;with cte as ( SELECT SampleID ,SetpointID ,CDPercentDiff ,AuditID ,pointrn = ROW_NUMBER() OVER…
SQL Server Database Engine
151 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 74%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
