“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.”
Why does it fail every time though server is
restarted as stated from above screen ?
Go to event viewer, windows logs-system, you see
below error message:
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.
How do i fix this ?
You need to Assign the Log on as a service user right to
NT SERVICE\ALL SERVICES.
This can be
implemented via GPO.
Go to your group policy management console,edit default domain policy
Computer
Configuration—>Policies—>Windows Settings—>Security Settings—>Local
Policies—>User Rights Assignment
Note: It is
not mandatory to edit the default domain Policy to enable this setting.You can
also create new GPO and ensure to have Enforced
(running on Server 2012) option is selected which can not be overwritten by
Default Domain Controller.
Go to properties of Logon as Service,
click on Add
user or Group,Enter NT SERVICE\ALL SERVICES ,click
ok.
Now move onto the server,open command prompt and
type gpupdate /Force to apply the GPO
settings.
To check if the settings are applied or not,you
can run rsop.msc from the run command and see the changes applied or not.
Once you confirmed the settings are applied,Start
the installation of WSUS role again,this time It should be okay.The source : http://eskonr.com/2013/06/wsus-role-failed-on-windows-server-2012-with-error-the-operation-cannot-be-completed-because-the-server-that-you-specified-requires-a-restart/
No comments:
Post a Comment