When i try to run SCCM Reporting Services Report,I get error always saying ‘Cannot create a connection to data source 'AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_'.
I verified if the user has sufficient permissions to access the database (datasource) or not,User has enough permissions.
If you look at the above Screen shot,it says “You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server”
I check the properties of Reporting server from SCCM Console under Data Source authentication Tab. I see below Settings.
With this change,I ran the report again.It worked.