Windows 10: 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 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.

 

Error during installation of SQL Server 2019 Express Edition

I'm unable to install SQL Server 2019 Express Edition. Every time it's giving me this error

Oops...

Unable to install SQL Server (setup.exe)

Exit code(Decimal):-2068052310Error description: Error writing to file: microsoft.sqlserver.batchparser.dll. Verify that you have to that directory.

I'm running windows 11 on an ARM Virtual Machine

 

SQL Server 2014 Express edition

I install Sql Server 2014 express edition successfully on a notebook running windows10 2 days ago and manage to log into the server using SQL server 2014 Management Studio with windows authentication. But today, I'm unable to log on using the same login settings citing
some instances or network problem.

Appreciate it if anyone can enlighten me on how to solve this issue.

Thank you in anticipation.