SQLGeordie's Blog

Helping the SQL Server community……where i can!

Docker – SQL on Linux image tag has changed! — October 4, 2017

Docker – SQL on Linux image tag has changed!

With the announcement of SQL Server 2017 last week came the updated microsoft/mssql-server-linux and microsoft/mssql-server-windows* docker images.

By default if you do a docker pull without a tag you will pull down the latest however with these new docker images this no longer works:

Docker pull latest.png

You get the error:

Error response from daemon: manifest for microsoft/mssql-server-linux:latest not found

I found this a bit strange so went onto the docker hub searching for microsoft/mssql images and see if they actually did exist:

Docker images on msft repo.PNG

SQL on Linux is what I was after and you can see from the image above it does exist but taking a close look at the tags tab you can see that they have now amended the tags to be microsoft/mssql-server-linux:2017-GA and microsoft/mssql-server-linux:2017-latest.

SQLonLinux-tags
The new tags

 

SQLonLinux-tags 2
This kind of tells us things have changed!

 

NOTE: The windows docker images still have the “latest” tag available

SQLonWIndows-tags

Now, if we run docker pull with the 2017-GA or 2017-latest tag it will grab it:

docker pull microsoft/mssql-server-linux:2017-GA

Docker pull 2017-GA.png

Obviously I have already done this and the image is up to date 🙂

 

Time to update all my demo scripts 😦

Advertisements
Docker and SQL Server series — July 23, 2017

Docker and SQL Server series

DockerBuildShipRunAnywhere

I’ve been playing around with Docker (more specifically with SQL Server on Linux) the beginning of 2017 to see if indeed I can “Build, Ship, Run, Any App Anywhere” and will be putting together a series of how-to’s and issues experienced so you guys don’t spend the countless hours trying to investigate and work out what is going on when things do not work.

I’ll be adding links to this main page as and when new posts are added as a central point of reference.

Docker and SQL Server – Useful links

 

 

Docker and SQL Server – Useful links —

Docker and SQL Server – Useful links

Docker

Below are a collection of links I’ve used as reference throughout my journey of Docker and running SQL Server containers. These have been invaluable in knowledge gathering and troubleshooting throughout this (at times) painstaking process.

First and foremost I would like to put a huge shout out to Andrew Pruski (b|t) for his Container Series which if you haven’t had a look at then I suggest you do, like now! He has put together some great content for anyone looking to get started with Containers.

I have tried to section them to make things easier to refer to and more than happy for others to suggest others to add:

Getting Started with Docker:

Tutorials

SQL Server on Linux:

Use cases:

General:

Licensing:

Installing:

Setup on Windows 10 VM:

SQL Server On Linux:

Connecting to SQL Server via sqlcmd:

Legacy SQL Server Containers

Performance

Issues and Troubleshooting

Using Volumes

Hyper-V containers