Windows class error when updating
I went into the COMPUTERS OU in Active directory, right-clicked on the server,enabled it, then did a gpupdate /force from the SQL server. In my case, in the host file, the machine name is hard coded with older IP.
I replace the older IP with the new one, the issue is resolved.
For more information about troubleshooting problems with WMI scripts and the WMI service, see WMI Isn't Working! If WMI returns error messages, be aware that they may not indicate problems in the WMI service or in WMI providers.
I got a better error message from ODBC too and also by checking the failed login messages on sql server: Can't take credit for this because I asked one of our Enterprise Systems Administrators for help and he diagnosed it in about 5 minutes of looking at a few screen shots I sent him.
Problem was that the Domain Controller’s clock was set incorrectly! The servers are setup for Host Only networking so don't have internet to sync the clock with.
I can login using SQL Authentication without problem. I guess that you have possibly 2 simultaneous conditions for this failure to happen: I had this issue for a server instance on my local machine and found that it was because I was pointing to 127.0.0.1 with something other than "localhost" in my hosts file.
It is not "of course - because if AD is not available then Kerberos authentication falls back to NTLM (domain account credentials are cached locally, one can login with it even if AD/Kerberos is not available).