ADFS 3.0 Cannot start service MSSQL$MICROSOFT##WID

Error:

Cannot start service MSSQL$MICROSOFT##WID on computer ‘.’.

Clicking on ‘Show more’ reveals no understandable error .

Go into the services, and look for the Windows Internal Database.

Tried starting the service manual

Then I received an error which showed the real problem.

I tried several settings for giving ‘logon as a service’ rights to several account, but nothing worked.
To work around the issue, use one of the following methods:

Solution 1:

Assign the Log on as a service user right to NT SERVICE\ALL SERVICES in the GPO that defines the user right.
Exclude the computer from the GPO that defines the user right.

Solution 2:

This flow did the trick for me, and can be used as a work around :

• Reboot the server
• Open the services (services.msc)
• Scroll down until you see services named Windows …
• Start the Post deployment process all over, in the Server manager dashboard.
• Switch over to services
• Continue hitting F5 until the Windows Internal Database service shows up.
• Double click the Windows Internal Database service
• Go to the Log On tab
• Select local system account
• Start the service
• Wait until the ADFS installation is finished.