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
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
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
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
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
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
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
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
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
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
Microsoft ACE.OLEDB.12.0 is not registered while import excel file
Microsoft ACE.OLEDB.12.0 is not registered -
SQL Server Database Engine
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
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
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
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
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
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
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
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
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…