I wanted to do some testing of SQL Server 2025 on my laptop. I have written before how I avoided installing SQL Server on the laptop and use containers instead. This post looks at adding a new version on the default port.

This page on MSLearn shows how to run the SQL Server 2025 container. I started here, when searching for “SQL Server 2025 container” on Google.

It was nice to see this updated for 2025, and if I scroll down, I can see the docker container to pull. This is the important thing for me to add a new version of SQL Server.

2025-06_line0101

I could go to this URL to see all the tags, since I don’t want just latest. I want to know what version to run: https://mcr.microsoft.com/en-us/artifact/mar/mssql/server/tags

In this case, I want this tag: 2025-CTP2.1-ubuntu-22.04

Installing the New Version

If you read my previous article, I put a folder for each version on my system. In my case, I use c:data. I’ll make a new folder for SQL 2025.

Note: I tried to copy this folder and subfolder and then delete files, but got permission errors on stratup. I made new folders and things worked.2025-06_line0104

Once in here, I’ll create sub folders for my mappings.

2025-06_line0105 

I will then copy over the docker-compose.yml file. In my case, I have all the 2022 stuff. I need to edit things.

2025-06_line0106

Most things are fine here, but I’ll update the name and image. These need to use the 2025 values. Here are my edits.

2025-06_line0107

I save this, and then I copy/paste the two stop/start batch files. I’ve opened these in code and changed 2022 to 2025. I’ll show one file below, but basically I change the CD command in both.

2025-06_line0108

That’s it. If my SQL 2022 container that runs on the default port is stopped, I can double click the start2025.cmd file. Once I do that, I see the image coming down.

2025-06_line0110

As soon as that completes, the container starts. I can connect with SSMS to the local host. Same as my 2022 instance, whose container is stopped.

2024-07-16 20_35_33-000012

Once I connect, I see the new, default, instance of SQL Server 2025.

2025-06_line0113

I do have to remember to start/stop containers, but I love having multiple default instances Winking smile

Share.
Leave A Reply