DEV Community

MANOJ AP
MANOJ AP

Posted on

Parallels and MSSQL Server

I recently purchased a Mac-Mini-M2 (Base Model), it was awesome and fast enough to kill my Windows 11 Laptop , :). Since I am supposed to develop Mac and Windows, also looking for a VM which utilise the power of M2 Silicon.

Development setup on Parallels

Firstly I installed Microsoft Visual Studio ,and it work better than ** ASUS Laptop with 8 GB Intel Core i5**

Also need a Microsoft SQL Server for backend needs and I started the install the setup, it just went with errors.

Docker

The second option for me is Docker on the Parallel. I tried and it succesfulluy installed. But the engine doesn't work for me. I google it, since it is container it is not possible.

Docker Solution

Docker container on Mac OS - That will be work right. Note that Some of the Docker Images (most) were built for Intel M1 chip. In such cases need to install Rosetta first, which help the transition of Intel to silicone.

softwareupdate--install--rosetta

How do I connect Mac Docker to Parallel Visual Studio ?

We can simply use the Mac IP with container exposed port as bellow. Go to Network click the Network option to get the IP.


 <add name="Dolphin_Accounts.Properties.Settings.sql_connection" connectionString="Data Source=192.168.20.101,1433;Password=mssql1Ipw;User Id=sa;Initial Catalog=dolphinedb;Integrated Security=False" />
Enter fullscreen mode Exit fullscreen mode

The Docker Compose iml

`version: '3.9'

services:
mssql-azur-edge2:
image: mcr.microsoft.com/azure-sql-edge
platform: linux/arm64
ports:
- 1433:1433

volumes:
- ~/apps/mssql/data:/var/lib/mssqlql/data
environment:
- ACCEPT_EULA=Y
- SA_PASSWORD=mssql1Ipw

From the terminal run docker-compose up -d and also make sure it is running by issuing the docker-compose ps command.

More post on M2,Docker and Mac-Mini-M2 setup

Top comments (0)