Thursday, January 22, 2015

The EXECUTE permission was denied on the object 'sp_help', database 'mssqlsystemresource', schema 'sys'.

ERROR:

Msg 229, Level 14, State 5, Procedure sp_help, Line 1
The EXECUTE permission was denied on the object 'sp_help', database 'mssqlsystemresource', schema 'sys'.

Solution:
 
Use Master
Go
GRANT EXECUTE ON sp_help to Public

Tuesday, January 20, 2015

Encryption Key for the Reporting Services Fails

ERROR:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. 
---> System.Runtime.InteropServices.COMException (0XXXXXX): Password doesn't meet the requirements of the filter dll's 

Solution :

Remove the custom password filter on:
         HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\LSA - Notification Packages