When trying to install a Role which require to install WID (Windows Internal Database), you could face an issue where it won’t install and throw this error message:
The operation could not be completed, because the server that you specified requires a restart
If we look at the Event viewer, we can find the following error:
MSSQL$MICROSOFT##WID service was unable to log on as NT SERVICE\MSSQL$MICROSOFT##WID
The solution is to add “NT SERVICE\MSSQL$MICROSOFT##WID” the permission to “log on as a service”.
It can be done by editing the “Default Domain Controller” GPO:
Computer Configuration –> Policies –> Windows Settings –> Security Settings –> Local Policies –> User Rights Assignment branch and then double click the ‘Log on as a service’ setting.
Finally, run a “gpupdate /force”, restart and the Role installation should now work!
Note: In my case when the Role installation failed, it created the WID user. I was then able to add it my GPO. But after a restart, it has been removed and therefor showing as an missing SID. But anyway, it solved the problem too. Maybe the SID is kept as it is.
Hope this help!