613 questions with SQL Server Database Engine tags

Sort by: Updated
1 answer

How to upgrade/activate MS SQL 2022 server

Hello Can someone please assist. I recently bought 2 MS SQL 2022 standard Global keys and wanted to activate the SQL 2022 application but every time I try and upgrade, it says that the key is invalid. I installed the SQL 2022-SSEI-Eval but when…

SQL Server Database Engine
asked 2026-02-04T08:20:52.7933333+00:00
Jason Bothe 0 Reputation points
answered 2026-02-04T08:21:05.7233333+00:00
Q&A Assist
2 answers

SQL server generating different query_id for same query_text_id after mirroring failover

I am facing a strange problem with one of my SQL Server 2017 Clusters. I faced a query regression in the past and forced a known good plan for that query_id in query store. When the planned database failover happens every month for OS patching from HostA…

SQL Server Database Engine
asked 2026-01-30T13:50:19.4766667+00:00
udhayan d 181 Reputation points
commented 2026-02-04T06:18:30.8933333+00:00
Akhil Gajavelly 1,155 Reputation points Microsoft External Staff Moderator
2 answers

DBF Table named Order in VFP

DBF Table named Order in VFP i think you can't have a tlb named order can anyone help with this problem. Update ORDER ; SET ORDER.GROUP = 'Apples' ; WHERE ORDER.GROUP == 'Apple'

SQL Server Database Engine
asked 2026-02-03T00:46:31.6266667+00:00
Paul Waldner 0 Reputation points
answered 2026-02-03T22:24:04.14+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2025 LocalDb installation is missing components

According to https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…

SQL Server Database Engine
asked 2025-12-09T15:15:18.17+00:00
Duncan Smart 0 Reputation points
commented 2026-02-03T21:35:22.2533333+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
3 answers

How do I fix an SQL Server issue

I recently transferred from one computer to another and forgot that one of the programs needed installed from scratch or it caused issues and would not open the program even after re-installation. The issue I am having involves SQL server. Windows cannot…

SQL Server Database Engine
asked 2026-01-11T19:35:52.46+00:00
Kevin Johnson 0 Reputation points
edited an answer 2026-02-03T11:44:19.85+00:00
Carl Walker 0 Reputation points
2 answers

Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS)

Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS) Microsoft SQL Server Enterprise Developer (64-bit) / Windows 11 Home / We hebben de volgende procedure…

SQL Server Database Engine
asked 2026-01-29T11:22:08.93+00:00
Patrick LEONARD 0 Reputation points
commented 2026-02-03T08:55:50.3566667+00:00
Shruti Dhruv 875 Reputation points Microsoft External Staff Moderator
3 answers

STAR Schema Model Design

Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…

SQL Server Database Engine
asked 2026-01-28T02:53:43.0233333+00:00
pdsqsql 436 Reputation points
edited an answer 2026-02-03T08:52:58.6433333+00:00
kagiyama yutaka 75 Reputation points
2 answers

How to recover from and MSDB database in “suspect” mode

Dear community, My SQL server MSDB DB is in suspect mode and i have no backup, i have tried to repair it to no avail, i have also run a full SQL repair which completeted successfully but i still have the error. Please advise on how i can repair…

SQL Server Database Engine
asked 2026-01-29T06:07:27.2133333+00:00
Rab Processors 0 Reputation points
commented 2026-02-03T08:52:49.0666667+00:00
Shruti Dhruv 875 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Databasemail stops working on SQL Server 2025 after CU1 install

We have server with SQL Server 2025 RTM that works fine but when we install CU1 for SQL Server 2025 the databasemail stops sending mail from SQL Server, nor error message no mail reach mailbox. SQL Server version 17.0.4005.7

SQL Server Database Engine
asked 2026-01-20T18:20:29.8566667+00:00
Micael Carlsson 26 Reputation points
accepted 2026-02-03T07:29:09.05+00:00
Micael Carlsson 26 Reputation points
2 answers

How to fix the identity issue in sql server 2025 AI feature while setting up Vector features

I am currently doing POC to explore SQL Server 2025 AI Feature in which I tried to set up Vector features. I am able to create scoped credential and external model but when I do the select statement it gives an error : here is the select state : SELECT…

SQL Server Database Engine
asked 2026-01-21T11:50:19.3833333+00:00
Venugopal, Kamalakkannan 0 Reputation points
commented 2026-02-02T21:36:03.31+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

Microsoft ACE.OLEDB.12.0 is not registered while import excel file

Microsoft ACE.OLEDB.12.0 is not registered -

SQL Server Database Engine
asked 2026-01-27T08:59:23.8633333+00:00
Noseda, Enzo 0 Reputation points
commented 2026-02-02T20:57:45.92+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2019 is not working

I went to update my Yearlie payroll tax program, and it now says that an error occurred while establishing a connection to the server. I contacted Yearlie and they spent a total of 12 hours on my computer and could not seem to fix the problem. They…

SQL Server Database Engine
asked 2026-01-12T17:14:37.2466667+00:00
Kathleen Bourcier 0 Reputation points
commented 2026-02-02T17:01:43.03+00:00
Kathleen Bourcier 0 Reputation points
2 answers

Linked server issue between SQL 2022 and SQL2008

Hi , I have installed new SQL Server 2022 and trying to create linked server with SQL Server 2008 but getting below error message. TITLE: Microsoft SQL Server Management Studio The linked server has been created but failed a connection test. Do you want…

SQL Server Database Engine
asked 2026-01-23T12:18:25.9766667+00:00
Sampath Challagonda 0 Reputation points
commented 2026-02-02T13:34:40.2933333+00:00
Rekha 0 Reputation points Microsoft External Staff Moderator
0 answers

SQL SERVER 2019 RTM GDR AND ERROR 0x851a0042

HP Elitebook 665 Device name XP07 Processor AMD Ryzen 7 Pro 7735U with Radeon Graphics (2.70 GHz) Installed RAM 32.0 GB (31.3 GB usable) Device ID 4B2E5BF5-204D-4848-9833-C35272AB43C8 Product ID 00355-62025-05789-AAOEM System type 64-bit operating…

SQL Server Database Engine
asked 2026-01-25T23:03:18.7833333+00:00
CP9100 POY 0 Reputation points
commented 2026-02-02T13:32:58.6+00:00
Rekha 0 Reputation points Microsoft External Staff Moderator
2 answers

SQL volume license not available

SQL server license was purchased through our reseller. Volume license is still not visible on my admin account

SQL Server Database Engine
asked 2026-01-29T03:51:41.4333333+00:00
Lynda Lawrence 0 Reputation points
commented 2026-02-02T12:07:54.7133333+00:00
Lakshmi Narayana Garikapati 675 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

When I create in Management Studio a query in a LSO on a table in DB2, the columns with decimal won't be in the autogenerated script

When I auto-create in Management Studio a query in a LSO on a table in DB2, the columns with decimal won't be in the autogenerated script and the values are displayed different to oledb

SQL Server Database Engine
asked 2026-01-29T09:24:18.98+00:00
Brigl, Karl 65 Reputation points
commented 2026-02-02T08:25:47.3833333+00:00
Brigl, Karl 65 Reputation points
2 answers

SQL Server Express 2025 installation issue on hp omnibook 7

I have got new HP Omnibook 7 flip ultra 7. I am trying to install sql server express 2025 but every time it failed. The exit code is -2061893606 (Error description: Wait on the Database engine recovery handle. Check sql server error log for potential…

SQL Server Database Engine
asked 2025-12-16T00:07:22.9033333+00:00
Amanullah Dar 0 Reputation points
commented 2026-02-02T07:46:55.56+00:00
Akhil Gajavelly 1,155 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-13T12:33:30.07+00:00
Kelvin Yu 0 Reputation points
commented 2026-02-02T07:44:57.0833333+00:00
Akhil Gajavelly 1,155 Reputation points Microsoft External Staff Moderator
2 answers

Running group MSA for agent service account won't let me back up to a NAS target

I'm running SQL Server 2022 in a clustered/AG environment, using a gMSA for the database engine and agent services. Even though I've granted full access to the NAS backup share, it cannot see it. We're using the Ola Hallengren maintenance solution. I've…

SQL Server Database Engine
asked 2026-01-23T20:34:15.87+00:00
DataMatt43 0 Reputation points
commented 2026-02-02T07:07:23.66+00:00
Akhil Gajavelly 1,155 Reputation points Microsoft External Staff Moderator
3 answers

I am having issues installing the SQL Server

I have been trying to install the SQL server for schoolwork. Every time I try the install process I get an error message stating (Wait on the Database Engine recovery handle failed). I have tried uninstalling and reinstalling the server and still no…

SQL Server Database Engine
asked 2026-01-21T13:44:24.9466667+00:00
Winchell Sossous 0 Reputation points
commented 2026-02-02T07:05:34.45+00:00
Akhil Gajavelly 1,155 Reputation points Microsoft External Staff Moderator