Windows 10: WHY I Can't install SQL Express 2022 or any other edition on a Asus vivo book S 15 Copilot+...

WHY I Can't install SQL Express 2022 or any other edition on an Asus vivo book S 15 Copilot+ PC 64-bit operating system, arm-based processor Qualcomm Snapdragon ARM* Moved from Community Center

:)

 

Windows 11 Microsoft SQL 2022 Express Edition

Hey,

currently in work we have PC with Windows 11 Pro license which is used as small "server". Here we have installed MS SQL servers.
We want to add new software database into MS SQL 2022 Express Edition but software creator said we need Windows Server License in order to use SQL Express in local network so client computers can connect to our "server".

Do we really need an Windows Server license for this?

 

SQL Express 2022 Installation is failing with error code - 2068052310

Hello Team,

Prerequisite:

SQL 2019 Express is installed and working properly.

Action performed:

SQL Express 2022 Installation is failing with error code 2068052310 in my Windows 10 (22 H2) machine.

below message is from the Summary.txt which was created by SQL installer

Feature: SQL Server Replication

Status: Failed

Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.

Next Step: Use the following information to resolve the error, and then try the setup process again.

Component name: Microsoft OLE DB Driver for SQL Server

Component error code: 1706

Component log file: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20240529_175257\msoledbsql_Cpu64_1.log Error description: An installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found. Try the installation again using a valid copy of the installation package 'msoledbsql.msi'. Error help link: Your request has been blocked. This could be due to several reasons.

when I searched against the error code, I found suggestions to uninstall ODBC driver 17 and retry the SQL installation.

I could not find the root cause why this issue would occur.

It would be of great help if someone please tell me if this can be detected before hand. We can mention this in readme, asking user to do a pre check and then perform the installation.

Thank you

regards,

Karthik

 

SQL server Express Edition

What's the last version of SQL server standard i can use on Windows 7 SP1?

Also, I DID install the express edition 2014, but i found out that the "SQL Agent' is not functional.. you must have full SQL for this..

SQL Server Agent (SQLEXPRESS) automatically stop

SQL agent in Express 'starts', then 'stops' and unable to even start the services in services.msc..

There are 'possible' workarounds like deleting and creating new user under Users & Groups, but that doesn't work either for me.

If SQL server standard my only option ? I'm assuming the SQL Server Agent brings mage and control dabases which is what i need in Nopcomerence.