文章目录一、需求背景二、安装Python/Pip三、安装SQL Server四、连接测试一、需求背景某服务器需要使用docker-compose但是采用二进制方式无法正常进行安装故需要使用pip方式进行安装。查看当前服务器版本信息[rootics ~]# cat /etc/os-releaseNAMEAnolis OSVERSION8.8IDanolisID_LIKErhel fedora centosVERSION_ID8.8PLATFORM_IDplatform:an8PRETTY_NAMEAnolis OS 8.8ANSI_COLOR0;31HOME_URLhttps://openanolis.cn/二、安装Python/Pipyum-yinstallepel-release yum-yinstallpython3 yum-yinstallpython3-pip将pip切换到国内镜像源vim~/.bashrc添加一行exportPIP_INDEX_URLhttps://pypi.tuna.tsinghua.edu.cn/simplesource~/.bashrc[rootics ~]# pip3 --versionpip21.3.1 from /usr/local/lib/python3.6/site-packages/pip(python3.6)如果版本是低版本则可能无法安装使用下面的命令进行在线升级pip3install--upgradepip-ihttps://pypi.tuna.tsinghua.edu.cn/simplepip3安装完成后使用以下命令安装docker-composepip3install-vdocker-compose或者 pip3install-vdocker-compose-ihttps://pypi.tuna.tsinghua.edu.cn/simple安装完毕后查看版本信息[rootics ~]# docker-compose -v/usr/local/lib/python3.6/site-packages/paramiko/transport.py:32: CryptographyDeprecationWarning: Python3.6is no longer supported by the Python core team. Therefore, supportforit is deprecatedincryptography. The next release of cryptography will remove supportforPython3.6. from cryptography.hazmat.backendsimportdefault_backenddocker-composeversion1.29.2, build unknown三、安装SQL Servervimdocker-compose.yml###编辑启动文件services:sqlserver-2019:restart:alwayscontainer_name:sqlserverimage:mcr.microsoft.com/mssql/server:2019-latestuser:root#端口映射ports:-1433:1433volumes:-/ics/Yinling/docker_data/mssql:/var/opt/mssql#环境变量environment:-ACCEPT_EULAY-MSSQL_SA_PASSWORDYinling_2025启动docker-compose up -d停止docker-compose down查看日志docker-compose logs -f四、连接测试查询版本信息SELECTSERVERPROPERTY(ProductVersion)AS版本号,SERVERPROPERTY(ProductLevel)AS补丁级别,SERVERPROPERTY(Edition)AS版本类型;或SELECTVERSION;或EXECsp_server_info;