1 Reply Latest reply on Aug 2, 2016 5:57 PM by thebluenova

    Cannot execute as the database principal because the principal "ewreportuser" does not exist

    leratob

      Hi all

       

      Im trying to run Patch Manager reports and i keep getting the below error.

       

      Computer:  CENWSPM101

      Object:  report

      Source:  Data Grid Server (CENWSPM101)

      Message:

      Exception occurred at 2016/06/06 02:41:49 PM: Cannot execute as the database principal because the principal "ewreportuser" does not exist, this type of principal cannot be impersonated, or you do not have permission. Unable to retrieve the information from the database. Message: Cannot execute as the database principal because the principal "ewreportuser" does not exist, this type of principal cannot be impersonated, or you do not have permission. Stored Procedure: BEGIN WITH ResultPage AS ( SELECT *,ROW_NUMBER() OVER (ORDER BY [update title] asc) AS RowNumber FROM ( select distinct TOP 100 PERCENT dbo.computerupdatestatus.domainworkgroup as [domain or workgroup (update server)], dbo.computerupdatestatus.netbiosname as [name (update server)], dbo.computerupdatestatus.title as [update title], dbo.computerupdatestatus.fulldomainname as [computer name], (case when dbo.computerupdatestatus.updateapprovalaction is null then null else case dbo.computerupdatestatus.updateapprovalaction when 0 then 'install' when 1 then 'uninstall' when 3 then 'notapproved' when 2147483647 then 'all' else 'unknown' end end ) as [update approval action (friendly name)], (case when dbo.computerupdatestatus.updateinstallationstate is null then null else case dbo.computerupdatestatus.updateinstallationstate when 0 then 'unknown' when 1 then 'notapplicable' when 2 then 'notinstalled' when 3 then 'downloaded' when 4 then 'installed' when 5 then 'failed' when 6 then 'installed pending reboot' else 'unknown' end end ) as [update installation state (friendly name)] from dbo.computerupdatestatus ) AS InnerPage ) SELECT * FROM ResultPage WHERE RowNumber BETWEEN (@PageNum - 1) * @PageSize + 1 AND @PageNum * @PageSize ORDER BY RowNumber ASC; WITH ResultPage AS ( SELECT *,ROW_NUMBER() OVER (ORDER BY [update title] asc) AS RowNumber FROM ( select distinct TOP 100 PERCENT dbo.computerupdatestatus.domainworkgroup as [domain or workgroup (update server)], dbo.computerupdatestatus.netbiosname as [name (update server)], dbo.computerupdatestatus.title as [update title], dbo.computerupdatestatus.fulldomainname as [computer name], (case when dbo.computerupdatestatus.updateapprovalaction is null then null else case dbo.computerupdatestatus.updateapprovalaction when 0 then 'install' when 1 then 'uninstall' when 3 then 'notapproved' when 2147483647 then 'all' else 'unknown' end end ) as [update approval action (friendly name)], (case when dbo.computerupdatestatus.updateinstallationstate is null then null else case dbo.computerupdatestatus.updateinstallationstate when 0 then 'unknown' when 1 then 'notapplicable' when 2 then 'notinstalled' when 3 then 'downloaded' when 4 then 'installed' when 5 then 'failed' when 6 then 'installed pending reboot' else 'unknown' end end ) as [update installation...

       

      Please help!!!