You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In this quickstart, you use Docker to pull and run the SQL Server 2017 container image, [mssql-server-linux](https://hub.docker.com/_/microsoft-mssql-server). Then connect with **sqlcmd** to create your first database and run queries.
27
27
28
28
> [!TIP]
29
-
> If you want to try the SQL Server 2019 preview image, see the [SQL Server 2019 preview version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-ver15).
29
+
> If you want to run SQL Server 2019 containers, see the [SQL Server 2019 version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-ver15).
In this quickstart, you use Docker to pull and run the SQL Server 2019 preview container image, [mssql-server](https://hub.docker.com/r/microsoft/mssql-server). Then connect with **sqlcmd** to create your first database and run queries.
35
+
In this quickstart, you use Docker to pull and run the SQL Server 2019 container image, [mssql-server](https://hub.docker.com/r/microsoft/mssql-server). Then connect with **sqlcmd** to create your first database and run queries.
36
36
37
37
> [!TIP]
38
-
> This quickstart creates SQL Server 2019 preview containers. If you prefer to create SQL Server 2017 containers, see the [SQL Server 2017 version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-2017).
38
+
> This quickstart creates SQL Server 2019 containers. If you prefer to create SQL Server 2017 containers, see the [SQL Server 2017 version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-2017).
39
39
::: moniker-end
40
40
41
41
This image consists of SQL Server running on Linux based on Ubuntu 16.04. It can be used with the Docker Engine 1.8+ on Linux or on Docker for Mac/Windows. This quickstart specifically focuses on using the SQL Server on **linux** image. The Windows image is not covered, but you can learn more about it on the [mssql-server-windows-developer Docker Hub page](https://hub.docker.com/r/microsoft/mssql-server-windows-developer/).
@@ -77,7 +77,7 @@ Before starting the following steps, make sure that you have selected your prefe
77
77
::: zone-end
78
78
79
79
> [!TIP]
80
-
> If you want to try the SQL Server 2019 preview image, see the [SQL Server 2019 preview version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-ver15#pullandrun2019).
80
+
> If you want to run SQL Server 2019 containers, see the [SQL Server 2019 version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-ver15#pullandrun2019).
81
81
82
82
The previous command pulls the latest SQL Server 2017 container image. If you want to pull a specific image, you add a colon and the tag name (for example, `mcr.microsoft.com/mssql/server:2017-GA-ubuntu`). To see all available images, see [the mssql-server Docker hub page](https://hub.docker.com/r/microsoft/mssql-server).
83
83
@@ -175,7 +175,7 @@ Setting `-h` and `--name` to the same value is a good way to easily identify the
175
175
176
176
Before starting the following steps, make sure that you have selected your preferred shell (bash, PowerShell, or cmd) at the top of this article.
177
177
178
-
1. Pull the SQL Server 2019 preview Linux container image from Docker Hub.
178
+
1. Pull the SQL Server 2019 Linux container image from Docker Hub.
179
179
180
180
::: zone pivot="cs1-bash"
181
181
```bash
@@ -196,9 +196,9 @@ Before starting the following steps, make sure that you have selected your prefe
196
196
::: zone-end
197
197
198
198
> [!TIP]
199
-
> This quickstart uses the SQL Server 2019 preview Docker image. If you want to run the SQL Server 2017 image, see the [SQL Server 2017 version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-2017#pullandrun2017).
199
+
> This quickstart uses the SQL Server 2019 Docker image. If you want to run the SQL Server 2017 image, see the [SQL Server 2017 version of this article](quickstart-install-connect-docker.md?view=sql-server-linux-2017#pullandrun2017).
200
200
201
-
The previous command pulls the SQL Server 2019 preview container image based on Ubuntu. To instead use container images based on RedHat, see [Run RHEL-based container images](sql-server-linux-configure-docker.md#rhel). To see all available images, see [the mssql-server-linux Docker hub page](https://hub.docker.com/_/microsoft-mssql-server).
201
+
The previous command pulls the SQL Server 2019 container image based on Ubuntu. To instead use container images based on RedHat, see [Run RHEL-based container images](sql-server-linux-configure-docker.md#rhel). To see all available images, see [the mssql-server-linux Docker hub page](https://hub.docker.com/_/microsoft-mssql-server).
202
202
203
203
::: zone pivot="cs1-bash"
204
204
For the bash commands in this article, `sudo` is used. On MacOS, `sudo` might not be required. On Linux, if you do not want to use `sudo` to run Docker, you can configure a **docker** group and add users to that group. For more information, see [Post-installation steps for Linux](https://docs.docker.com/install/linux/linux-postinstall/).
@@ -234,7 +234,7 @@ Before starting the following steps, make sure that you have selected your prefe
234
234
> The password should follow the SQL Server default password policy, otherwise the container can not setup SQL server and will stop working. By default, the password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols. You can examine the error log by executing the [docker logs](https://docs.docker.com/engine/reference/commandline/logs/) command.
235
235
236
236
> [!NOTE]
237
-
> By default, this creates a container with the Developer edition of SQL Server 2019 preview.
237
+
> By default, this creates a container with the Developer edition of SQL Server 2019.
238
238
239
239
The following table provides a description of the parameters in the previous `docker run` example:
In this quickstart, you install SQL Server 2019 preview on Red Hat Enterprise Linux (RHEL) 7.3+. You then connect with **sqlcmd** to create your first database and run queries.
26
+
In this quickstart, you install SQL Server 2019 on Red Hat Enterprise Linux (RHEL) 7.3+. You then connect with **sqlcmd** to create your first database and run queries.
27
27
28
28
::: moniker-end
29
29
@@ -54,10 +54,10 @@ To configure SQL Server on RHEL, run the following commands in a terminal to ins
54
54
```
55
55
56
56
> [!TIP]
57
-
> If you want to try SQL Server 2019 , you must instead register the **Preview (2019)** repository. Use the following command for SQL Server 2019 installations:
57
+
> If you want to install SQL Server 2019 , you must instead register the SQL Server 2019 repository. Use the following command for SQL Server 2019 installations:
In this quickstart, you install SQL Server 2017 or SQL Server 2019 preview on SUSE Linux Enterprise Server (SLES) v12 SP2. You then connect with **sqlcmd** to create your first database and run queries.
20
+
In this quickstart, you install SQL Server 2017 or SQL Server 2019 on SUSE Linux Enterprise Server (SLES) v12 SP2. You then connect with **sqlcmd** to create your first database and run queries.
In this quickstart, you install SQL Server 2019 preview on SUSE Linux Enterprise Server (SLES) v12 SP2. You then connect with **sqlcmd** to create your first database and run queries.
26
+
In this quickstart, you install SQL Server 2019 on SUSE Linux Enterprise Server (SLES) v12 SP2. You then connect with **sqlcmd** to create your first database and run queries.
27
27
28
28
::: moniker-end
29
29
@@ -57,10 +57,10 @@ To configure SQL Server on SLES, run the following commands in a terminal to ins
57
57
```
58
58
59
59
> [!TIP]
60
-
> If you want to try SQL Server 2019 , you must instead register the **Preview (2019)** repository. Use the following command for SQL Server 2019 installations:
60
+
> If you want to install SQL Server 2019 , you must instead register the SQL Server 2019 repository. Use the following command for SQL Server 2019 installations:
In this quickstart, you install SQL Server 2017 or SQL Server 2019 preview on Ubuntu 16.04. You then connect with **sqlcmd** to create your first database and run queries.
21
+
In this quickstart, you install SQL Server 2017 or SQL Server 2019 on Ubuntu 16.04. You then connect with **sqlcmd** to create your first database and run queries.
In this quickstart, you install SQL Server 2019 preview on Ubuntu 16.04. You then connect with **sqlcmd** to create your first database and run queries.
27
+
In this quickstart, you install SQL Server 2019 on Ubuntu 16.04. You then connect with **sqlcmd** to create your first database and run queries.
28
28
29
29
::: moniker-end
30
30
@@ -65,10 +65,10 @@ To configure SQL Server on Ubuntu, run the following commands in a terminal to i
65
65
```
66
66
67
67
> [!TIP]
68
-
> If you want to try SQL Server 2019 , you must instead register the **Preview (2019)** repository. Use the following command for SQL Server 2019 installations:
68
+
> If you want to install SQL Server 2019 , you must instead register the SQL Server 2019 repository. Use the following command for SQL Server 2019 installations:
Copy file name to clipboardExpand all lines: docs/linux/sql-server-linux-configure-docker.md
+7-7Lines changed: 7 additions & 7 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,6 +1,6 @@
1
1
---
2
2
title: Configuration options for SQL Server on Docker
3
-
description: Explore different ways of using and interacting with SQL Server 2017 and 2019 preview container images in Docker. This includes persisting data, copying files, and troubleshooting.
3
+
description: Explore different ways of using and interacting with SQL Server 2017 and 2019 container images in Docker. This includes persisting data, copying files, and troubleshooting.
4
4
author: vin-yu
5
5
ms.author: vinsonyu
6
6
ms.reviewer: vanto
@@ -25,10 +25,10 @@ This article explains how to configure and use the [mssql-server-linux container
25
25
26
26
## Pull and run the container image
27
27
28
-
To pull and run the Docker container images for SQL Server 2017 and SQL Server 2019 preview, follow the prerequisites and steps in the following quickstart:
28
+
To pull and run the Docker container images for SQL Server 2017 and SQL Server 2019, follow the prerequisites and steps in the following quickstart:
29
29
30
30
-[Run the SQL Server 2017 container image with Docker](quickstart-install-connect-docker.md?view=sql-server-2017)
31
-
-[Run the SQL Server 2019 preview container image with Docker](quickstart-install-connect-docker.md?view=sql-server-ver15)
31
+
-[Run the SQL Server 2019 container image with Docker](quickstart-install-connect-docker.md?view=sql-server-ver15)
32
32
33
33
This configuration article provides additional usage scenarios in the following sections.
34
34
@@ -37,9 +37,9 @@ This configuration article provides additional usage scenarios in the following
37
37
38
38
## <aid="rhel"></a> Run RHEL-based container images
39
39
40
-
All of the documentation on SQL Server Linux container images point to Ubuntu-based containers. Beginning with SQL Server 2019 preview, you can use containers based on Red Hat Enterprise Linux (RHEL). Change the container repository from **mcr.microsoft.com/mssql/server:2019-CTP3.2-ubuntu** to **mcr.microsoft.com/mssql/rhel/server:2019-CTP3.2** in all of your docker commands.
40
+
All of the documentation on SQL Server Linux container images point to Ubuntu-based containers. Beginning with SQL Server 2019, you can use containers based on Red Hat Enterprise Linux (RHEL). Change the container repository from **mcr.microsoft.com/mssql/server:2019-CTP3.2-ubuntu** to **mcr.microsoft.com/mssql/rhel/server:2019-CTP3.2** in all of your docker commands.
41
41
42
-
For example, the following command pulls the latest SQL Server 2019 preview container that uses RHEL:
42
+
For example, the following command pulls the latest SQL Server 2019 container that uses RHEL:
Starting with SQL Server 2017 preview, the [SQL Server command-line tools](sql-server-linux-setup-tools.md) are included in the container image. If you attach to the image with an interactive command-prompt, you can run the tools locally.
124
+
Starting with SQL Server 2017, the [SQL Server command-line tools](sql-server-linux-setup-tools.md) are included in the container image. If you attach to the image with an interactive command-prompt, you can run the tools locally.
125
125
126
126
1. Use the `docker exec -it` command to start an interactive bash shell inside your running container. In the following example `e69e056c702d` is the container ID.
The following example shows how to use these environment variables to pull and run a single SQL Server 2019 preview container configured for MSDTC. This allows it to communicate with any application on any hosts.
54
+
The following example shows how to use these environment variables to pull and run a single SQL Server 2019 container configured for MSDTC. This allows it to communicate with any application on any hosts.
0 commit comments