通过DOCKER运行MSSQL2017,并对外提供访问

最新推荐文章于 2024-08-11 20:41:49 发布
最新推荐文章于 2024-08-11 20:41:49 发布
阅读量4.3k 收藏 3
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/lsysafe/article/details/89552425
版权

拉取镜像,有1.35G

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

[root@v73 ~]# docker images
REPOSITORY                     TAG                 IMAGE ID            CREATED             SIZE
microsoft/mssql-server-linux   2017-latest         314918ddaedf        4 months ago        1.35GB

 

运行容器,并把数据文件映身到主机的/datas目录下,服务端口映射主机的1499端口提供服务,容器运行先运行一个/bin/bash,不然启动后会退出容器

docker run -it -v /datas:/var/opt/mssql -v /etc/localtime:/etc/localtime:ro -e TZ="Asia/Shanghai" -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=abcd1234!*' -p 1499:1433 -d --name=linuxmssql 314918ddaedf /bin/bash

 

进入容器手动开启SQLSERVER服务,要有2G以上的内存才跑得起来,内存不足容器会有提示

[root@v73 ~]# docker ps -a
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS                    NAMES
89e08cc9e120        314918ddaedf        "/bin/bash"         3 hours ago         Up 2 hours          0.0.0.0:1499->1433/tcp   linuxmssql

[root@v73 ~]# docker exec -it 89e08cc9e120 /bin/bash
root@89e08cc9e120:/# ls  
bin  boot  dev  etc  home  install.sh  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var
root@89e08cc9e120:/# cd /opt/mssql
root@89e08cc9e120:/opt/mssql# ls
bin  lib
root@89e08cc9e120:/opt/mssql# cd bin/
root@89e08cc9e120:/opt/mssql/bin# ls
compress-dump.sh  crash-support-functions.sh  generate-sql-dump.sh  handle-crash.sh  mssql-conf  paldumper  sqlservr
root@89e08cc9e120:/opt/mssql/bin# ./sqlservr 
2019-04-26 12:26:30.68 Server      Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64) 
        Nov 30 2018 12:57:58 
        Copyright (C) 2017 Microsoft Corporation
        Developer Edition (64-bit) on Linux (Ubuntu 16.04.5 LTS)
2019-04-26 12:26:30.69 Server      UTC adjustment: 8:00
2019-04-26 12:26:30.69 Server      (c) Microsoft Corporation.
2019-04-26 12:26:30.70 Server      All rights reserved.
2019-04-26 12:26:30.70 Server      Server process ID is 4120.
2019-04-26 12:26:30.70 Server      Logging SQL Server messages in file '/var/opt/mssql/log/errorlog'.
2019-04-26 12:26:30.71 Server      Registry startup parameters: 
         -d /var/opt/mssql/data/master.mdf
         -l /var/opt/mssql/data/mastlog.ldf
         -e /var/opt/mssql/log/errorlog
2019-04-26 12:26:30.78 Server      SQL Server detected 2 sockets with 1 cores per socket and 1 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2019-04-26 12:26:30.80 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2019-04-26 12:26:30.80 Server      Detected 2268 MB of RAM. This is an informational message; no user action is required.
2019-04-26 12:26:30.81 Server      Using conventional memory in the memory manager.
2019-04-26 12:26:30.95 Server      Buffer pool extension is already disabled. No action is necessary. 
2019-04-26 12:26:31.05 Server      InitializeExternalUserGroupSid failed. Implied authentication will be disabled.
2019-04-26 12:26:31.05 Server      Implied authentication manager initialization failed. Implied authentication will be disabled.
2019-04-26 12:26:31.05 Server      Successfully initialized the TLS configuration. Allowed TLS protocol versions are ['1.0 1.1 1.2']. Allowed TLS ciphers are ['ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA256:AES128-SHA256:AES256-SHA:AES128-SHA:!DHE-RSA-AES256-GCM-SHA384:!DHE-RSA-AES128-GCM-SHA256:!DHE-RSA-AES256-SHA:!DHE-RSA-AES128-SHA'].
2019-04-26 12:26:31.10 Server      The maximum number of dedicated administrator connections for this instance is '1'
2019-04-26 12:26:31.10 Server      Node configuration: node 0: CPU mask: 0x0000000000000003:0 Active CPU mask: 0x0000000000000003:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2019-04-26 12:26:31.11 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2019-04-26 12:26:31.12 Server      In-Memory OLTP initialized on lowend machine.
2019-04-26 12:26:31.16 Server      Database Instant File Initialization: enabled. For security and performance considerations see the topic 'Database Instant File Initialization' in SQL Server Books Online. This is an informational message only. No user action is required.
ForceFlush is enabled for this instance. 
2019-04-26 12:26:31.17 Server      Query Store settings initialized with enabled = 1, 
2019-04-26 12:26:31.18 spid6s      Starting up database 'master'.
2019-04-26 12:26:31.18 Server      Software Usage Metrics is disabled.
ForceFlush feature is enabled for log durability.
2019-04-26 12:26:31.92 spid6s      25 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
2019-04-26 12:26:32.70 spid6s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
2019-04-26 12:26:32.70 spid6s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2019-04-26 12:26:32.72 spid6s      Recovery completed for database master (database ID 1) in 2 second(s) (analysis 112 ms, redo 277 ms, undo 491 ms.) This is an informational message only. No user action is required.
2019-04-26 12:26:33.30 spid6s      Resource governor reconfiguration succeeded.
2019-04-26 12:26:33.30 spid6s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
2019-04-26 12:26:33.33 spid6s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
2019-04-26 12:26:33.43 spid6s      SQL Trace ID 1 was started by login "sa".
2019-04-26 12:26:34.05 spid6s      Server name is '89e08cc9e120'. This is an informational message only. No user action is required.
2019-04-26 12:26:34.16 spid23s     Always On: The availability replica manager is starting. This is an informational message only. No user action is required.
2019-04-26 12:26:34.16 spid6s      Starting up database 'msdb'.
2019-04-26 12:26:34.17 spid23s     Always On: The availability replica manager is waiting for the instance of SQL Server to allow client connections. This is an informational message only. No user action is required.
2019-04-26 12:26:34.17 spid9s      Starting up database 'mssqlsystemresource'.
2019-04-26 12:26:34.19 spid9s      The resource database build version is 14.00.3048. This is an informational message only. No user action is required.
2019-04-26 12:26:34.22 spid9s      Starting up database 'model'.
2019-04-26 12:26:34.23 spid20s     A self-generated certificate was successfully loaded for encryption.
2019-04-26 12:26:34.35 spid20s     Server is listening on [ 'any' <ipv4> 1433].
2019-04-26 12:26:34.36 Server      Server is listening on [ 127.0.0.1 <ipv4> 1434].
2019-04-26 12:26:34.37 Server      Dedicated admin connection support was established for listening locally on port 1434.
2019-04-26 12:26:34.65 spid6s      9 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
2019-04-26 12:26:34.67 spid20s     SQL Server is now ready for client connections. This is an informational message; no user action is required.
2019-04-26 12:26:34.85 spid9s      1 transactions rolled forward in database 'model' (3:0). This is an informational message only. No user action is required.
2019-04-26 12:26:35.06 spid9s      0 transactions rolled back in database 'model' (3:0). This is an informational message only. No user action is required.
2019-04-26 12:26:35.07 spid9s      Recovery is writing a checkpoint in database 'model' (3). This is an informational message only. No user action is required.
2019-04-26 12:26:35.29 spid6s      0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
2019-04-26 12:26:35.29 spid6s      Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2019-04-26 12:26:35.35 spid9s      Polybase feature disabled.
2019-04-26 12:26:35.36 spid9s      Clearing tempdb database.
2019-04-26 12:26:37.34 spid9s      Starting up database 'tempdb'.
2019-04-26 12:26:38.76 spid9s      The tempdb database has 1 data file(s).
2019-04-26 12:26:38.83 spid23s     The Service Broker endpoint is in disabled or stopped state.
2019-04-26 12:26:38.83 spid23s     The Database Mirroring endpoint is in disabled or stopped state.
2019-04-26 12:26:39.21 spid23s     Service Broker manager has started.
2019-04-26 12:26:39.25 spid6s      Recovery is complete. This is an informational message only. No user action is required.
2019-04-26 12:28:16.04 spid51      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
2019-04-26 12:28:16.08 spid51      Using 'xplog70.dll' version '2017.140.3048' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2019-04-26 12:28:16.45 spid51      Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
2019-04-26 12:28:16.46 spid51      Using 'xpsqlbot.dll' version '2017.140.3048' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2019-04-26 12:28:16.73 spid54      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2019-04-26 12:28:16.77 spid54      Using 'xpstar.dll' version '2017.140.3048' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2019-04-26 12:28:40.71 spid52      Starting up database 'testlinuxmssql'.
2019-04-26 12:28:40.89 spid52      Parallel redo is started for database 'testlinuxmssql' with worker pool size [1].
2019-04-26 12:28:41.02 spid52      Parallel redo is shutdown for database 'testlinuxmssql' with worker pool size [1].
2019-04-26 12:28:41.11 spid52      Setting database option COMPATIBILITY_LEVEL to 140 for database 'testlinuxmssql'.
2019-04-26 12:28:41.12 spid52      Setting database option ANSI_NULL_DEFAULT to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.13 spid52      Setting database option ANSI_NULLS to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.13 spid52      Setting database option ANSI_PADDING to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.14 spid52      Setting database option ANSI_WARNINGS to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.14 spid52      Setting database option ARITHABORT to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.15 spid52      Setting database option AUTO_CLOSE to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.16 spid52      Setting database option AUTO_SHRINK to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.16 spid52      Setting database option INCREMENTAL to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.16 spid52      Setting database option AUTO_CREATE_STATISTICS to ON for database 'testlinuxmssql'.
2019-04-26 12:28:41.17 spid52      Setting database option AUTO_UPDATE_STATISTICS to ON for database 'testlinuxmssql'.
2019-04-26 12:28:41.18 spid52      Setting database option CURSOR_CLOSE_ON_COMMIT to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.19 spid52      Setting database option CURSOR_DEFAULT to GLOBAL for database 'testlinuxmssql'.
2019-04-26 12:28:41.19 spid52      Setting database option CONCAT_NULL_YIELDS_NULL to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.20 spid52      Setting database option NUMERIC_ROUNDABORT to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.21 spid52      Setting database option QUOTED_IDENTIFIER to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.22 spid52      Setting database option RECURSIVE_TRIGGERS to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.22 spid52      Setting database option DISABLE_BROKER to ON for database 'testlinuxmssql'.
2019-04-26 12:28:41.24 spid52      Setting database option AUTO_UPDATE_STATISTICS_ASYNC to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.24 spid52      Setting database option DATE_CORRELATION_OPTIMIZATION to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.24 spid52      Setting database option PARAMETERIZATION to SIMPLE for database 'testlinuxmssql'.
2019-04-26 12:28:41.25 spid52      Setting database option READ_COMMITTED_SNAPSHOT to OFF for database 'testlinuxmssql'.
2019-04-26 12:28:41.25 spid52      Setting database option READ_WRITE to ON for database 'testlinuxmssql'.
2019-04-26 12:28:41.25 spid52      Setting database option RECOVERY to FULL for database 'testlinuxmssql'.
2019-04-26 12:28:41.26 spid52      Setting database option MULTI_USER to ON for database 'testlinuxmssql'.
2019-04-26 12:28:41.26 spid52      Setting database option PAGE_VERIFY to CHECKSUM for database 'testlinuxmssql'.
2019-04-26 12:28:41.26 spid52      Setting database option target_recovery_time to 60 for database 'testlinuxmssql'.
2019-04-26 12:28:41.27 spid52      Setting database option delayed_durability to disabled for database 'testlinuxmssql'.
2019-04-26 12:31:34.28 spid55      Using 'dbghelp.dll' version '4.0.5'
 

用SQLSERVER客户端管理工具Microsoft SQL Server Management Studio 连接服务成功

 

 

数据文件都在运行容器主机映射的目录下

[root@v73 ~]# ls /datas
data  log  secrets
[root@v73 ~]# ls /datas/data/
master.mdf  mastlog.ldf  modellog.ldf  model.mdf  msdbdata.mdf  msdblog.ldf  tempdb.mdf  templog.ldf  testlinuxmssql_log.ldf  testlinuxmssql.mdf

 

lsysafe
关注
使用docker创建和运行跨平台的容器化的mssql数据库
xuhss_com的博客
05-26 668
🚀 优质资源分享 🚀 学习路线指引（点击解锁） 知识定位 人群定位 🧡 Python实战微信订餐小程序 🧡 进阶级 本课程是python flask+微信小程序的完美结合，从项目搭建到腾讯云部署上线，打造一个全栈订餐系统。 💛Python量化交易实战💛 入门级 手把手带你打造一个易扩展、更安全、效率更高的量化交易系统 我们一般启用sql server数据库要么选择安装SQL Server实例和管理工具（SSMS），要么用vs自带的数据库。如今net跨平台成为趋势，今天给大家介绍另一种
三分钟解决使用docker创建和运行跨平台的容器化的mssql数据库
aa119101的博客
05-29 1019
我们一般启用sql server数据库要么选择安装SQL Server实例和管理工具（SSMS），要么用vs自带的数据库。如今net跨平台成为趋势，今天给大家介绍另一种我最近在玩的方式，即使用docker创建并启用sql数据库。 本章介绍了在window10专业版下如何利用docker创建mssql数据库，包括以下主题： 安装并验证docker 利用docker创建mssql实例 使用vs2022连接sql 首先我们看下sql自带的数据库管理工具，打开vs2022-视图-SQL Server对象资源
Docker 安装 MSSQL 2017
du512280414的博客
10-28 466
前言 微软数据库开源安装，可以在linux环境进行安装，笔者也跟着进行感受了一下在linux docker环境安装MSSQL 2017 。安装过程如下 1 安装docker 环境(此处不在讲述) 2 在docker 拉取mssql 2017 镜像文件 3 安装并启动镜像服务 4 连接访问 笔者系统环境 Unbuntu 20.04.2 Docker 20.10.7 部署安装 1 docker 拉取mssql 2017 镜像文件 docker pull mcr....
Docker简介
最新发布
m0_52796585的博客
08-11 1375
Docker 是一个开源的容器化平台，它使开发者能够自动化应用程序的部署、管理、扩展和运行。Docker 利用容器技术，允许在一个隔离的环境中运行应用程序，并确保不同环境（如开发、测试、生产环境）之间的一致性。这种技术使得应用程序可以在各种不同的操作系统和基础设施上运行，而不必担心兼容性问题。Docker 通过容器化技术为开发和部署提供了巨大的灵活性和便利性。它使得应用程序能够在不同的环境中一致运行，并显著提高了资源利用率和部署速度。
docker 安装SQL Server2017使用navicat连接sqlserver
菜鸡的博客
05-11 636
docker 安装SQL Server2017使用navicat连接sqlserver
Docker部署SQL Server 2017 Always On集群
weixin_43053507的博客
03-26 1595
如果主要副本不可用且无法立即恢复，则需要强制执行向次要副本的故障转移（存在数据丢失）。但是，如果原始主要副本在故障转移后恢复，它将承担主要角色。若要避免每个副本处于不同的状态，在存在数据丢失的情况下进行强制故障转移后，从可用性组中删除原始主要副本。若要更改哪个副本为主要副本，可进行故障转移。在本文中，我们将在3个机器的Docker容器上安装SQL Server 2019，并创建AlwaysOn可用性组。对于使用群集类型为 NONE 或EXTERNAL 创建的可用性组，请对可用性组的所有副本执行该命令。
使用Docker安装sqlServer
qq_14919677的博客
11-18 2906
第二部 : 创建容器 这里映射的端口是1433 可自行修改 （必须是复杂密码否则无法启动自行设置）这里的密码为 1Qaz2ws1x.使用Docker安装sqlServer。第一步: 使用docker拉取镜像。第三部 启动客户端连接即可。
ASP.NET Core 实战：使用 Docker 容器化部署 ASP.NET Core + sqlserver + Nginx
qq_19900687的博客
01-16 1171
ASP.NET Core 实战：使用 Docker 容器化部署 ASP.NET Core + sqlserver + Nginx¶ 一、前言¶ 在之前的文章（ASP.NET Core 实战：Linux 小白的 .NET Core 部署之路）中，我介绍了如何在 Linux 环境中安装 .NET Co...
HADOOP部署之后无法WEB访问
云计算和大数据的部署和运维技术
12-05 9557
问题现象部署HADOOP后，无法通过http://ip:port访问服务页面问题1：hdfs-site.xml配置项 通过jps命令查看java进程的状态，HADOOP相关的进程运行正常。 jps是jdk提供的一个查看当前java进程的小工具， 可以看做是JavaVirtual Machine Process Status Tool的缩写。 [root@node4 ~]# jps 25059 Se
【Rethinking IT】如何应用数据图表了解家里的 Unifi 网络状况？
ryoma1836的博客
01-01 671
时序数据库 (Time Series Database，TSDB)。定义A什么意思呢？就是说时序数据库，它被优化成专门将一系列相关联的“时间”和“数值”，进行存储和提供服务的一套软件系统。在某些领域，时间序列可能被称为剖面、曲线、轨迹或者趋势。一些早期的时间序列数据库与工业应用相关联，这些应用可以有效地存储来自传感设备的测量值，但现在用于支持更广泛的应用。所以，时序数据其实就是随着时间不断产生的连续测量数值或者事件，时序数据库就是用来保存这些数据的手段之一。时序数据库的特点。
linux 环境 安装SQL-SERVER2017
胖虎儿的博客
07-04 7310
一、yum 安装 （1）设置下载源 直接执行命令 sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo （2）yum下载 SQL Server yum install -y mssql-server （3）命令安装与配置SQL-SERVER /opt/mssql/bin/mssql-conf setup 提示说明： （
linux docker 安装sql,CentOS7使用Docker安装SQL Server 2017
weixin_39805732的博客
05-18 172
先决条件适用于支持的任一 Linux 分发版的 Docker 引擎 1.8 以上版本，或适用于 Mac/Windows 的 Docker。有关详细信息，请参阅安装 Docker。至少 4 GB 的磁盘空间至少 4 GB 的 RAM重要Docker for Mac 和 Docker for Windows 的 Moby VM 默认大小为 2 GB，因此必须将其更改为 4 GB。如果你在 Mac 或...
Ubuntu16.04 上Docker 中安装SQL Server 2017
weixin_30622181的博客
07-23 452
一、镜像安装 1、从Docker库中拉取镜像 sudo docker pull microsoft/mssql-server-linux:2017-latest 2、拉取完之后，运行该镜像 sudo docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=1234qwer!' \ -p 1401:1433 --name...
linux上的sqlserver服务总断,sql-server – SQL Server Linux的Docker容器不断退出
weixin_39594296的博客
05-07 354
我希望通过在容器启动时添加一个包含一个表的简单数据库来修改容器的行为.我看到此问题的docker镜像版本是截至2017年5月20日的最新版本,即ctp2-1.我正在使用Docker for Windows,最新版本为17.05.0-ce.我将MobyLinuxVM的RAM增加到6144MB,因为建议使用4GB以上.重现问题的步骤准备文件(1) Create a local Windows fold...
win10系统 sqlserver 安装
mnotwo的博客
07-01 912
安装了好几个小时，服务终于启动了。嘤嘤嘤。。。 错误日志如下。 2017-07-01 20:51:38.07 Server Microsoft SQL Server 2016 (SP1) (KB3182545) - 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation D
【云原生】-Docker部署SQL Server及最佳应用
IT邦德
08-19 5451
SQL Server是由Microsoft开发和推广的关系数据库管理系统（DBMS）,本文总结了容器环境下的部署及实践应用
SQL SERVER 2008 login failed 一例处理
ctr29775的博客
05-14 814
【现象】 sql server登陆报错 查看ERRORLOG 2015-05-1311:46:53.74spid27sRecoveryiswritingacheck...
Automating Daily Checks with Powershell
Burgess_Liu的专栏
08-24 1569
Automating Daily Checks with Powershell By Warren Campbell, 2011/12/19 At my company, I am required to produce evidence that I have checked every database backup on every server to ensure that
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值