Wednesday, February 20, 2013 7:20 AM
I am trying to run sql server assessment and it shows huge number of failures for WMI, Registry and SQL. e.g.,
Collection Status | Success | Failure | Not applicable
WMI 89 718 65
Registry 41 620 211
SQL 3 64 805
I am using domain admin account (<domain>\administrator) and using AD DS to search for all computers. is the above normal, and if not, how can it be prevented?
Wednesday, February 20, 2013 10:36 PMModerator
After the inventory finishes, click on the Environment scenario group and click on the Inventory Results tile and generate the report. It will list the specific failure types for each machine. A description of some of those failure types can be found in this TechNet Wiki article:
The 2 most common reasons that I've seen for failures are caused by a dirty AD or a firewall. When the AD contains computer objects that no longer exist, MAP discovers them, tries to look them up in DNS and, since they no longer exist, gets an error message that the machine cannot be found.
As far as firewalls are concerned, I've heard many people swear that they don't have firewalls turned on, but then run WMIDiag and discover that Windows Firewall is still enabled or their anti-virus is aggressive and blocks the remote connection. I would try WMIDiag on a couple of the Access Denied machines and see what it says. Keep in mind that it can take several minutes for it to complete, so be patient.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.