I was getting a critical error in my SCCM 2007 R3 Component Status log as follows:
SMS_MP_CONTROL_MANAGER 5447 MP has rejected a policy request from GUID:XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX because it was not approved. The operating system reported error 2147942405: Access is denied.
I copied all the GUID information and created a report to search the database for a specific GUID as follows:
select * from v_R_System where v_R_System.SMS_Unique_Identifier0=@GUID
this SQL query includes a prompt for you to enter a single GUID, prompt info is as follows:
Prompt text: Enter GUID
Default value: GUID: (this must be added as the query searches for the full value GUID:xxxxxxx-xxxx-xxxx-xxx-xxxxxxxx)
The report will provide the client hostname, after locating the client I attempted to delete the client from SCCM and let rediscovery find the client. After the client was rediscovered the issue resolved. Short and sweet!