The operation could not be completed, because the server that you specified requires a restart

Hi,

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!

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s