Management

Subscribe to Blog via Email

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

Join 788 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

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

  • Brian Valentine

    Only thing that I got to work on a Windows 2016 server connected to a domain. This was installing WSUS which also uses the windows internal database which has the same permissions problem. Everything else would not work. Have been grappling with this for several days. Could you be kind enough to get this page or create a new one with the same solutions to show up with the WSUS keywords. It would help out your fellows as well as increase page views! Thank you.

  • TheKm

    Bingo. Thanks for the write-up. Probably saved me a whole lot of time and frustration there.

Leave a Reply

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