In this post, you use Docker to pull and run the SQL Server Linux container image and see the demo of connecting from SQL Server Management Studio (SSMS).
\n<\/p>\n
Open your PowerShell with elevated permission and run the following command. It pulls the SQL Server 2022 (16.x) Linux container image from the Microsoft Container Registry.<\/p>\n
\n Fig 1: Docker run — SQL Server Linux Container<\/p>\n
Parameter
\n Description<\/p>\n
-e \u201cACCEPT_EULA=Y\u201d
\n confirm your acceptance of the End-User Licensing Agreement.<\/p>\n
-e \u201cMSSQL_SA_PASSWORD=»
\n Specify your own strong password.<\/p>\n
-p 1433:1433
\n Map a TCP port on the host environment (first value) with a TCP port in the container (second value).<\/p>\n
\u2013name sql1
\n Name of the container<\/p>\n
\u2013hostname sql1
\n Container hostname<\/p>\n
-d
\n Run the container in the background daemon<\/p>\n
mcr.microsoft.com\/mssql\/server:2022-latest
\n The SQL Server Linux container image.<\/p>\n
Run the following command, \u201cdocker ps\u201d to view your Docker containers.<\/p>\n
\n Fig 2: Docker ps — View containers<\/p>\n
If the STATUS column shows Up, then SQL Server is running in the Docker container and listening on the port.<\/p>\n
Docker engine,<\/p>\n
\n Fig 3: Docker Engine<\/p>\n
Connect the SQL Server from SSMS,<\/p>\n
\n Fig 4: SSMS — Connect SQL Server<\/p>\n
List all the database,<\/p>\n
\n Fig 5: Database list view<\/p>\n
Test database,<\/p>\n
\n Fig 6: Test database<\/p>","protected":false},"excerpt":{"rendered":"
In this post, you use Docker to pull and run the SQL Server Linux container image and see the demo of connecting from SQL Server Management Studio (SSMS). Open your PowerShell with elevated permission and run the following command. It pulls the SQL Server 2022 (16.x) Linux container image from … <\/p>\n