mssql-server并不支持macOX,通常需要安装一个虚拟机,但现在有了Docker之后,一切都变得简单了。
首先,你需要安装Docker,这个很简单。推荐使用最新版docker。
安装Docker之后,需要配置国内的阿里云镜像(参考我上一篇博客),速度非常快。
由于微软sqlserver已经出了linux版本了,安装mssql-server-linux(点我)。
官方的文档和说明已经很详细了,这里需要注意一点,SA的密码一定要设置成强密码,不然回报如下的错误:
Microsoft(R) SQL Server(R) setup failed with error code 1.
Please check the setup log in /var/opt/mssql/log for more information.
- A strong system administrator (SA) password: At least 8 characters including uppercase, lowercase letters, base-10 digits and/or non-alphanumeric symbols.
- SA管理员强密码:至少8歌字符,包含大小写字母,数字或者特殊符号。
注意,Mac下不支持目录映射。
如何你用-v参数映射了磁盘目录,会报以下错误:
2017-01-04 03:36:27.37 Server Error: 17113, Severity: 16, State: 1.
2017-01-04 03:36:27.37 Server Error 2(The system cannot find the file specified.)
occurred while opening file 'C:\var\opt\mssql\data\master.mdf' to obtain configuration information
at startup. An invalid startup option might have caused the error.
Verify your startup options, and correct or remove them if necessary.
2017-01-04 03:36:27.37 Server SQL Server shutdown has been initiated