Accessing Database on Mac from within Parallels

We have a .NET app that uses Framework 4.7, so no go on Mac. We bought parallels so that we can run windows and I tried to install SQL Server 2022 express edition just so I can run a very small basic database, but the installation crashed and directed me to an error folder but I didn't get which file was the error log.

Anyway, since it's a brand new fresh install of Windows 11 ARM edition with running windows update and restarting I'm assuming its the ARM part of that it's not liking. Is there a solution to get this working? I heard you can just install docker and run the SQL Server through that? How would I interact with it then? Would it just be a web app like PHPMyAdmin?

Alternatively, I do have azure data studio on Mac and the database is already up and running on there, does anyone know how I can access the database running on MacOS from my Visual Studio inside Parallels?

 

Add a line to your hosts file (C:\Windows\System32\drivers\etc\hosts)
10.211.55.2 host

10.211.55.2 is a default IP Parallels assigns to host machine, "host" could be anything you like - this will allow you to connect to servers running on your Mac OS from your Windows VM using host:[port]