Blog Post

Install SQL Server 2025 Container on macOS Using OrbStack

,

My old Dell XPS that I used for personal stuff started to degrade; well, it’s old, and it has already served past its useful life. So, a few months ago I bought a 14-inch Macbook Pro M5 Pro with 24GB of memory and the standard for M5 Pro 15-core CPU. It’s not my ideal config and I would have opted for the M5 Max. This machine is quite decent for what I need and I am not complaining.

Switching from Windows to Mac has been a challenge, to say the least. This is my first time using macOS as my primary operating system. Suffice it to say, it hasn’t been easy. There’s that.

And, SSMS is not supported in this platform, and Microsoft said that SSMS in Mac is “out of scope” and it will never ever be supported. Period. So, if I were to use this Macbook as my primary learning sandbox, I have no choice but to make it work. My macOS version as of this writing is Tahoe 26.5.1.

For my Mac SQL Server sandbox, I used OrbStack instead of Docker Desktop. I used Docker in my old sandbox on my Dell XPS. Why OrbStack? Simply because it’s the more efficient option on a Mac. First, it’s a native macOS app. The biggest factor is how these two allocate memory. OrbStack’s memory management is dynamic, meaning it doesn’t hold onto memory that it isn’t using. Although Docker has introduced improvements to memory management, such as Resource Saver and other optimizations, OrbStack is still better in that regard. Compared to Docker, OrbStack has low power usage, low memory usage, and a bunch of other advantages.

The usual Docker commands work as-is in OrbStack, so there’s no need to learn new commands or build new scripts if you already have them. Of course, caveats would include Docker Extensions and other features native to Docker.

Install OrbStack

The easiest way to install OrbStack on a Mac is via the package manager Home Brew. My preferred terminal is iTerm2.

Zsh

brew install --cask orbstack

And that’s pretty much it. Next is the container. Run OrbStack if it isn’t already running.

IMPORTANT: Enable Rosetta / Update Rosetta 2

Zsh

orb config set rosetta true

My SQL Server 2025 container keeps getting stuck at the initialization process. Enabling Rosetta fixed the issue.

Pull and Run the Container

As I said, you don’t have to use any new commands to pull the image and run the SQL Server 2025 container. Commands such as docker pull/run and docker compose should run fine out of the box in OrbStack.

Zsh

docker pull mcr.microsoft.com/mssql/server:2025-latest

Then simply run the container. Just a note, if you are using the default command interpreter Z Shell (szh) in iTerm2, get rid of the double quotes and run the following instead:

Zsh

docker run -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD='password_here' -p 1433:1433 --name sql2025 --hostname sql2025 -d mcr.microsoft.com/mssql/server:2025-latest

You might get a warning that says “The requested image’s platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested <container_id>.

This simply is saying you’re on the ARM64 architecture of the Apple Silicon and the Linux SQL Server container provided by Microsoft is on the AMD64 architecture (no native ARM64 image).

The container should be fine even with that warning. But if you’re bothered by it, just rebuild the container with explicit Linux/amd64. Just stop and delete the existing container and add the --platform flag in the Docker command.

Zsh

docker stop sql2025
Zsh

docker rm sql2025
Zsh

docker run --platform linux/amd64 -e ACCEPT_EULA=Y -e MSSQL_SA_PASSWORD='password_here' -p 1433:1433 --name sql2025 --hostname sql2025 -d mcr.microsoft.com/mssql/server:2025-latest

The warning should now be gone.

VS Code with mssql Extenstion

Install VC Code on your Mac via Home Brew if you haven’t done so.

Zsh

brew install --cask visual-studio-code

Then, Open your VS Code and install the SQL Server (mssql) extension. The extension version as of this writing is v1.43.0.

Create new connection:

Then, that’s it!

Press ? + ? + P, and select MS SQL: Open New Query and Connect.

In the editor, check the master_files just to see if the database is queryable ??

SQL

select * from sys.master_files ;

Troubleshooting Stuck SQL Server 2025 Container

Just a quick check to see if you can connect to the SQL Server from your Mac

Zsh

nc -vz localhost 1433

If port exposure looked fine, but still failing connection from VS Code, then something else might be causing the error. I was getting the following error from VS Code.

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 – An internal exception was caught)

I checked my container stats, and one thing I noticed immediately is that the CPU is hitting the max of 100% usage.

Zsh

docker stats sql2025

Upon futher digging, I found that emulation path getting stuck during SQL Server initialization. Check if enabling Rosetta on fixes the issue.

We’ll restore a SQL Server 2025 database in the next post.

The post Install SQL Server 2025 Container on macOS Using OrbStack first appeared on SQL, Code, Coffee, Etc..

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating