SCCM Configmgr 2007 Reporting services Error ‘Cannot create a connection to data source’

 

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.

Error Message:

image

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.

image I changed the settings from Credentials stored securely by the report server to Windows Integrated Security.

With this change,I ran the report again.It worked.

Leave a Reply