Management

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 786 other subscribers

Social

  • LinkedIn
  • RSS Feed for Posts
  • Twitter
  • StumbleUpon

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

ADFS 3.0 Cannot start service MSSQL$MICROSOFT##WID

This week I had a problem installing Windows ADFS 3.0, on a Server 2012 R2 server.

This server was also a Domain controller. Unfortunately there was no possibility to install ADFS on an other server.

During the installation I received this error, over and over again;

 

Error:

ADFS 3.0 Cannot start service MSSQL$MICROSOFT##WID 1

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

ADFS 3.0 Cannot start service MSSQL$MICROSOFT##WID 2

Clicking on ‘Show more’ reveals no understandable error .

ADFS 3.0 Cannot start service MSSQL$MICROSOFT##WID 3

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

ADFS 3.0 Cannot start service MSSQL$MICROSOFT##WID 4

Tried starting the service manual

ADFS 3.0 Cannot start service MSSQL$MICROSOFT##WID 5

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.

 

More info about this:

https://support.microsoft.com/en-us/kb/2832204

 

It is not recommended to install the ADFS service role on a domain controller. The preferred method is to install this on a different server. Only install this service role on a domain controller, if you realy sure you don’t have another server available. This is stated on this Microsoft Technet page :

https://technet.microsoft.com/en-us/library/cc778681(WS.10).aspx 

ADFS-Domain-controller

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.