Hi, I'm trying to create a report based on the view vSMS_DistributionDPStatus. When i run the Query in the builder it works correctly but when trying to launch it from the reporting server i get an error indicating permission issues:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> System.Data.SqlClient. SqlException: The SELECT permission was denied on the object 'vSMS_DistributionDPStatus', database 'CM_XXX', schema 'dbo'. Can this view not be used in SCCM 2012 R2? I tried to find a fn_rbac equivalent but there seems to be none? Regards Mattias Benninge
