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)
Check LocalHost DB:
-Open powershell
-Execute: Get-Service | Where-Object {$.Name -like “MSSQL*” -or $.Name -like “SQL*” } | Select-Object Name, Status
- it should show:
MSSQL$SQLEXPRESS Running
SQLWriter Running
-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
Happy scripting!
