SQL reporting Services not working and we get access denied error”0x80070005″

Many a times we have seen that when we try to install SQL reporting services to integrate with the Configuration Manager we get an access denied error message on the wbemtest like the one in the following screenshot and the reason for the same is wmi namespace could not be connected remotely from SCCM server to SQL server if the SQL server is a remote installation :

Now to fix the following error message we need to follow the following action plan :

1. Run ‘Dcomcnfg’ -> Console Root -> Component Services -> Computers -> My Computer .Right click ‘My Computer’ -> Click ‘Properties’.  And then GO to ‘COM Security’ tab.In ‘Access Permissions’ area, click ‘Edit Limits’.Add ‘Everyone’, and allow it all the permissions.In ‘Launch and Activation Permissions’ area, click ‘Edit Limits’.

   Add ‘Everyone’, and allow it all the permissions.

2. Run ‘Dcomcnfg’ -> Console Root -> Component Services -> Computers -> My Computer -> DCOM Config -> Windows Management and Instrumentation. Right click ‘Windows Management and Instrumentation’ -> Click ‘Properties’.Go to ‘Security’ tab.In ‘Launch and Activation Permissions’ area -> select ‘Customize’ -> Edit.

   Add ‘Everyone’, and allow it all the permissions.

   In ‘Access Permissions’ area -> select ‘Customize’ -> Edit.

   Add ‘Everyone’, and allow it all the permissions.

3. Run ‘wmimgmt.msc’ -> WMI control (local).Right ‘WMI control (local)’ -> Click ‘Properties’.Go to ‘Security’ tab – Select Root -> Click ‘Security’ button.Add ‘Everyone’, and allow it all the permissions.
4. Please separate the WMI service, we may need further troubleshooting.Open CMD and run:Sc config winmgmt type= own
5. Then go to service control manager, restart the ‘Windows Management Instrumentation’ service.
6. Reboot the both nodes, then do the same test using ‘wbemtest’ as before.