SQL Service服务更换帐户后无法启动的情况（Security 4625 Type 5）

错误日志：Security 4625 Type 5

The user has not been granted the requested logon type at this machine.

 

需要将以下2种本地帐号添加到：Local Policy (secpol.msc)  - Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment

NT SERVICE\MSSQLSERVER

NT SERVICE\SQLSERVERAGENT

 

或者添加需要更换的帐号至 User Rights Assignment 亦可。