183 questions with SQL Server Database Engine tags

Sort by: Updated
0 answers

SQLserver2022 standard edition to SQLserver2022 1dvice CAL

お客様番号:契約番号利用開始日記載のMicrosoft software inCSPサービス開通通知は頂いているのですが、https://www.office.comの管理センターで商品が記載されない状況でダウンロードも出来ない状態です。記載させる方法、手法を知りたいです。 宜しくお願い致します

SQL Server Database Engine
asked 2025-05-15T03:16:33.3233333+00:00
外園 0 Reputation points
commented 2025-05-15T21:12:45.5233333+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer

SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring

Subject: SQL Server Database Mirroring Configuration Error - Database Not Configured for Mirroring   Dear Microsoft Support, I am writing to request assistance with a database mirroring issue I'm encountering in our SQL Server environment. Environment…

SQL Server Database Engine
asked 2025-05-14T14:47:24.9866667+00:00
Deepak Kumar | Veracity 0 Reputation points
commented 2025-05-15T20:59:59.27+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer

publication having 2 subscribers

We have transactional replication configured. We have a publication having 2 subscribers. If snapshot is generated on 1 subscriber, will it generate snapshot on the second subscriber?

SQL Server Database Engine
asked 2025-05-14T14:37:29.3066667+00:00
Chaitanya Kiran 801 Reputation points
commented 2025-05-15T13:37:04.02+00:00
Chaitanya Kiran 801 Reputation points
1 answer

Free SQL Server Editions for Commercial Use.

What free SQL Server editions am i allowed to use in a production environment (for commercial use) in Windows where i both use .NET web-applicationa as well as desktop applications? I have investigated some of this but it's not clear - i do know that i…

SQL Server Database Engine
asked 2025-05-15T11:42:17.0333333+00:00
Staffan Vinsa 0 Reputation points
answered 2025-05-15T12:25:17.7666667+00:00
Olaf Helper 46,861 Reputation points
2 answers

Failure to instal SQL Server 2022

Everytime I try to instal SQL server, keeps on showing this Oops ... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893607Error description: Could not find the Database Engine startup handle. C:\Program Files\Microsoft SQL…

SQL Server Database Engine
asked 2025-05-14T09:42:53.31+00:00
Joshua Mworia 5 Reputation points
answered 2025-05-14T20:54:37.6633333+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
0 answers

database currently unavailable

database on server is not currently available please retry the connection later. if the problem preseists contact customer support and provide them the session tracid ID SQL error 40613

SQL Server Database Engine
asked 2025-05-14T11:24:44.49+00:00
Diane Roy 0 Reputation points
commented 2025-05-14T20:53:10.6166667+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer

How to fix "exit code decimal -2147467259" on Microsoft SQL Server Express 2022

I can't install Microsoft SQL Server 2022 on my computer. I have tried to download it many times, but it is still not working. Attached here is the SQL Server Install Log: Summary_DESKTOP-G10K08E_20250513_212204.txt Detail.txt

SQL Server Database Engine
asked 2025-05-13T13:43:02.7966667+00:00
John Paul 0 Reputation points
answered 2025-05-13T20:54:54.7266667+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer One of the answers was accepted by the question author.

SNAC 11.0 driver on third party Azure storage inconsistencies

Looking for some assistance if possible. I do understand that Native Client 11.0 is no longer supported or downloadable. We have an ODBC connection setup through a third-party vendors Azure Blob Storage that uses the Native Client 11.0 drivers. Problem…

SQL Server Database Engine
asked 2025-05-12T17:27:55.2133333+00:00
Mark Bovenzi 60 Reputation points
commented 2025-05-13T20:43:54.1+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer

How to fix Error 0x800706aa: Process returned error: 0x6aa while installing SQL SERVER 2019?

Hi, Could you please help to fix Error 0x800706aa: Process returned error: 0x6aa while installing SQL SERVER 2019? Note: OLE DB version 18.7.4.0 has been installed. Windows update has been done

SQL Server Database Engine
asked 2025-05-12T19:24:37.64+00:00
Murugan Rajendran 0 Reputation points
commented 2025-05-13T20:13:39.12+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer

Migrate sql enterprise rds database to postgresql

Hi, I am asked at work if it migrate an SQL Enterprise database to Postgresql. The database is used for RDS that supports 50 jumpservers. I have not done migrations like this before, so I guess my first question is, is it at all possible? Best…

SQL Server Database Engine
asked 2025-05-12T11:36:22.79+00:00
Frank Christiansen 21 Reputation points
commented 2025-05-13T10:35:06.43+00:00
Frank Christiansen 21 Reputation points
3 answers

How to recreate sql from read transaction logs

How to read the transaction log to re-create an insert statement

SQL Server Database Engine
asked 2025-05-08T13:14:08.5333333+00:00
Jensen, Randy 0 Reputation points
answered 2025-05-13T09:49:42.7166667+00:00
Vignesh K 20 Reputation points
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
commented 2025-05-12T14:53:16.31+00:00
Alban Berisha 80 Reputation points
2 answers

when tried to export database facing export size limit error

when tried to export database facing export size limit error suggest with steps to export my 1.7 TB DB to blob storage container

SQL Server Database Engine
asked 2025-05-11T12:58:11.3433333+00:00
Sripathi Eravelly 0 Reputation points
answered 2025-05-12T06:20:48.8233333+00:00
Olaf Helper 46,861 Reputation points
1 answer

Issue with SQL Server 2022 RTM GDR (KB5046861) Update - Error code (Install error - 0x851a0020)

Greetings, I need help with an issue I’ve been experiencing for the past month. Below is a short description of the problem: I regularly install Windows updates, and about a month ago I encountered an issue with installing the SQL Server update…

SQL Server Database Engine
asked 2025-05-09T11:47:12.7733333+00:00
Havaji69 0 Reputation points
answered 2025-05-09T20:42:52.01+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer

How to Migrate SQL Server from One Tenant to Azure SQL VM with Minimum Downtime

we have a scenario where we have a sql server on 1 tenant that needs to be transitioned to Azure SQL Virtual Machine. Scenario: 1, Minimum down time migrate from 2016 SQL on windows 2019 to SQL 2022 on windows 2022 Integration services need to be…

SQL Server Database Engine
asked 2025-05-09T17:05:32.98+00:00
Perera, Priyantha 0 Reputation points
answered 2025-05-09T20:32:55.45+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer

Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Suddenly getting this error when using SSMS Import/Export Wizard and importing from Excel spreadsheet.

SQL Server Database Engine
asked 2025-05-07T19:08:52.1+00:00
Guy Petty 0 Reputation points
edited a comment 2025-05-09T14:24:27.86+00:00
Yitzhak Khabinsky 26,491 Reputation points
1 answer

Trigger on cascading update target doesn't fire when the OUTPUT clause is used

Hello. I asked this question on stackexchange and the guys from the community recommended me report it to Microsoft https://dba.stackexchange.com/questions/346386/trigger-on-cascading-update-target-doesnt-fire-when-the-output-clause-is-used Below is the…

SQL Server Database Engine
asked 2025-05-05T09:50:45.2+00:00
Igor Telegin 0 Reputation points
commented 2025-05-08T16:21:05.5733333+00:00
Igor Telegin 0 Reputation points
1 answer

Investigate Root Cause of DBCC CHECKDB error | (SQLSTATE 42000)(Error 8992 | Catalog Msg 3853)

Details: I am running Microsoft SQL Server 2022 I am running DBCC CHECKDB on a user database (of which raised this error), each saturday This has happened on one on-prem Windows Server with installation of SQL server, with a predefined set of…

SQL Server Database Engine
asked 2025-05-07T08:39:20.11+00:00
Lucas Bjorndal 0 Reputation points
answered 2025-05-08T07:22:23.6533333+00:00
Lucas Bjorndal 0 Reputation points
0 answers

SQL Stretch DB - error Msg 40673, Level 16, State 1, Line 24

Hi when setting up StrechDB from an on prem server i get the error below Msg 40673, Level 16, State 1, Line 24 The service objective assignment for the database has failed This happens when i run the following script ALTER DATABASE XXXXXXX SET…

SQL Server Database Engine
asked 2025-05-07T17:36:13.0966667+00:00
Arthur Moulding 0 Reputation points
commented 2025-05-07T20:52:46.9233333+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator
1 answer One of the answers was accepted by the question author.

the file %commondir%\dte80.olb could not be loaded

Hi .. Today I woke up and just open the server and start SQL server manegment studio and I received this message "the file %commondir%\dte80.olb could not be loaded an attempt to repair this condition failed because the file could not be found…

SQL Server Database Engine
asked 2025-05-05T18:29:25.52+00:00
Hussam Homsi 20 Reputation points
commented 2025-05-07T20:46:46+00:00
Erland Sommarskog 120.6K Reputation points MVP Moderator