{"id":758,"date":"2019-12-05T14:44:16","date_gmt":"2019-12-05T20:44:16","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=758"},"modified":"2019-12-05T14:49:55","modified_gmt":"2019-12-05T20:49:55","slug":"install-sql-server-on-windows-10-using-docker","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/install-sql-server-on-windows-10-using-docker\/","title":{"rendered":"Install SQL Server on Windows 10 using Docker"},"content":{"rendered":"\n
\"\"<\/a><\/figure><\/div>\n\n\n\n

Starting with SQL Server 2017, Microsoft announced you can run SQL in Docker containers. This is great news for DBA\u2019s because we tend to run multiple installations of SQL Server locally and with Docker we can spin up (or remove) a SQL instance fairly quickly.<\/p>\n\n\n\n

I\u2019m not going to go into what Docker is because there\u2019s\nan entire website<\/a>\nthat goes into much more detail than I ever could. This post is going to focus\non a simple SQL installation on Windows 10 using Docker. Let \u2018s gooooooo!<\/p>\n\n\n\n

First, let\u2019s download and install the latest version of Docker. To find the latest version, open an internet browser and navigate to https:\/\/docs.docker.com\/docker-for-windows\/install\/<\/a>. From here, click \u201cDownload from Docker Hub\u201d<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

You will need to create a docker ID and password if you don\u2019t have one. Once you have this info let\u2019s login.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Next, let\u2019s click \u201cGet started with Docker Desktop\u201d from the home page and \u201cDownload Docker Desktop for Windows\u201d<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

After the download is complete, go ahead and start the install. On the Configuration screen, I\u2019m going to Use Windows containers instead of Linux. Click OK.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Docker Desktop is installing:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

 After\ninstallation succeeds, you must log out so make sure to save everything!<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Upon logging back in, you will be greeted with this message, Hit OK and reboot.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

After reboot, let\u2019s open Powershell (as administrator)\nand issue the following statement. This will show you that Docker is installed\nproperly and it will give you the version we are running.<\/p>\n\n\n\n

Docker Version<\/em><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Next, let\u2019s do a search for a SQL Server image. Back in Docker Hub, in the search box, let\u2019s type SQL Server and click on Microsoft SQL Server:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

This page will give you all sorts of valuable information. <\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

You can also use the following PowerShell statement to\npull SQL Server images:<\/p>\n\n\n\n

Docker search Microsoft<\/em><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Again, from Powershell, let\u2019s download the Microsoft SQL\nServer Developer Edition images. To do this use the following:<\/p>\n\n\n\n

Docker pull microsoft\/mssql-server-windows-developer <\/em><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

This will take a few minutes so grab some coffee\u2026..or a\nbeer.<\/p>\n\n\n\n

Once the download is complete you can run the following statement to see the images downloaded:<\/p>\n\n\n\n

Docker images<\/em><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

OK, we have Docker installed and our SQL Server image\ndownloaded. Now the fun part\u2026.install SQL Server! In PowerShell, let\u2019s run the\nfollowing:<\/p>\n\n\n\n

Docker run –name DockerSQL -d -p 14331:1433\n-e sa_password=<\/em> St0ngP@SSw0rd! -e ACCEPT_EULA=Y microsoft\/mssql-server-windows-developer\n<\/em><\/p>\n\n\n\n