使用docker安装sql server linux版
参考官方文档的步骤。
拉取镜像
root@DESKTOP-59T6U68:/mnt/c/Users/lt# docker pull mcr.microsoft.com/mssql/server:2019-latest Trying to pull mcr.microsoft.com/mssql/server:2019-latest... Getting image source signatures Copying blob 8e76b0919436 done Copying blob 306fbe3b6736 done Copying blob e012aedd45a6 done Copying config efc85b51a9 done Writing manifest to image destination Storing signatures efc85b51a9647a89913ac5f2424b598c6b36f32de7c7aa83d2299aa5813ecd18运行容器
root@DESKTOP-59T6U68:/mnt/c/Users/lt# docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Pass_123" -p 1433:1433 --name sql1 -d mcr.microsoft.com/mssql/server:2019-latest 16bc503f9bdc9aa25f5ef609f5d99445fcea82da743a10aac74f2f9d58e4334d登录容器并连接数据库
root@DESKTOP-59T6U68:/mnt/c/Users/lt# docker exec -it sql1 bash mssql@16bc503f9bdc:/$ cd /opt/mssql-too* mssql@16bc503f9bdc:/opt/mssql-tools18$ /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa Password: Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate]. Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection. For solutions related to encryption errors, see https://go.microsoft.com/fwlink/?linkid=2226722. 用-No选项禁用安全连接 mssql@16bc503f9bdc:/opt/mssql-tools18$ /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -No Password: 输入刚才设置的Pass_123 1> select 1 a; 2> go a ----------- 1 (1 rows affected) 1>