I was attempting to install WSUS role and I faced to below issue during the installation.
The request to add or remove features on the specified server failed.
The operation cannot be completed because the server that you specified requires a restart.
The MSSQL$MICROSOFT##WID service was unable to log on as NT SERVICE\MSSQL$MICROSOFT##WID with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.
Service: MSSQL$MICROSOFT##WID
Domain and account: NT SERVICE\MSSQL$MICROSOFT##WID
This service account does not have the required user right "Log on as a service."
User Action
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.
If you have already assigned this user right to the service account, and the user right appears to be removed, check with your domain administrator to find out if a Group Policy object associated with this node might be removing the right.
To fix this first restart the server, open Group Policy Management Editor (in my scenario it was Default Domain Controller Policy) Expand Computer Configuration -> Policies -> Windows Settings -> Security Settings -> Local Policies -> User Rights Assignment.
Double click on Log on as a service and add NT SERVICE\MSSQL$MICROSOFT##WID
Do a gpupdate /force
Add the role again.
Leave a Reply