I finally got it to work! I’ve attempted this many times, but this is the first time I’ve gotten it to work. I haven’t done extensive testing, but I will primarily use this for creating scripts. Here are the screen shot of it working:
My setup: (reboot windows after each install)
Install Parallels Desktop with Windows 11 Install Microsoft .Net 3.5
Install SQL2022 Express using GitHub .bat file (Run as Administrator)
-Execute: Get-ChildItem ‘HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL’
-That should give you the name of your server: SQLEXPRESS MSSQL16.SQLEXPRESS
Install Venus 6.3:
-unchecked the SQL Database since I will be connecting it to a separate DB
-check the other box to create shortcuts for all the other software (method editor, run edititor, etc)
Open Hamilton System Configurator
-Turn on Vector Database
-Edit Vector Database Connection
-Server should be LOCALHOST\SQLEXPRESS
-Click on “Prepare Server”
-Check “Trusted Connection: Yes” → OK
-Under Login Setting Check Yes for Trusted Connection
Do you know if it also working for M2/M3/M4? Anything else that might prevent it from working on a MacBook air M4? I have 6.2 and is not successful with the above. I have no option to deselect the installation of the SQL server. Do you have that with 6.3?
It should work on all M chipset. I would not see why it wouldn’t unless the CPU architecture changed. Try it and report back if you run into any errors.
Also, I just found out that Microsoft officially supports SQL server for ARM based chipset. You can download SQL Server 2025 that is available now as a “Preview”. You can try that as well. LINK
I just tried installing this on an M4 Max chipset and the commands were slightly different for the powershell to grab the server name:
-Get-Service | Where-Object { $_.Name -like ‘MSSQL*’ }
Also tried using the official Microsoft SQL Server and the connection string is just “LOCALHOST” instead of “LOCALHOST\SQLEXPRESS”
