PENDING SCCM Custom security role for Report Administration

[zolabus]

I created a custom security role to manage reports in reporting services.
I gave the correct grant. If I try to create a new report ok but when I try to enter a query I have login error for user to the data source.
Do I need to add something to SQL database?

 

[Prajwal Desai]

What is the error that you see?

 

[zolabus]

in attach thanks

 

[Garth]

in attach thanks

The screenshot is telling you that you don't have access to the SQL db. you you are using unsupported views within your query. Try this https://www.recastsoftware.com/resources/how-to-start-editing-sccm-reports-with-report-builder/

 

[zolabus]

I only want to be sure that I must give access to DB manually
Thanks