Linux sqlserver错误:Active: failed (Result: start-limit)Access was denied setting up the persistent re

广告：阿里云新人专场

检查mssql-server服务是否正在运行：

systemctl status mssql-server

Active: failed (Result: start-limit)

Process: 5735 ExecStart=/opt/mssql/bin/sqlservr (code=exited, status=1/FAILURE)

Failed to start Microsoft SQL Server Database Engine.

检查sqlserver日志：/var/opt/mssql/log/errorlog

日志*.txt提示：

This program has encountered a fatal error and cannot continue running at Fri Nov 25 15:32:42 2022
The following diagnostic information is available:

Reason: 0x00000007
Status: 0xc0000022
Message: Access was denied setting up the persistent registry: \SystemRoot\security.hiv.
Stack Trace:
file://package4/windows/system32/sqlpal.dll+0x000000000000E16F
file://package4/windows/system32/sqlpal.dll+0x000000000000CDCF
file://package4/windows/system32/sqlpal.dll+0x000000000000A47B
file://package4/windows/system32/sqlpal.dll+0x000000000000A61F
file://package4/windows/system32/sqlpal.dll+0x0000000000008BDD
file://package4/windows/system32/sqlpal.dll+0x0000000000007085
file://package4/windows/system32/sqlpal.dll+0x0000000000202641
Modules:
file://package4/windows/system32/sqlpal.dll=E59EEA3917F70A1E2DB0DFD3370D69501
Process: 100144 - sqlservr
Thread: 100149 (application thread 0x8)
Instance Id: 2d857919-4bd4-40ab-9ab9-e173535fe1ce
Crash Id: c9f69bfe-881f-4b67-b01a-323058c80eb6
Build stamp: f16f9a0c0de9e451372b68d715395767a0605312e847c4dccce5b2784118cab9
Distribution: CentOS Linux 7 (Core)
Processors: 4
Total Memory: 16637198336 bytes
Timestamp: Fri Nov 25 15:32:42 2022
Last errno: 13
Last errno text: Permission denied

原因：权限被更改

解决办法：

sudo chown -R mssql:mssql /var/opt/mssql/* /var/opt/mssql/.system/

广告：阿里云采购优惠专区