Hello

We have sccm r2 environment, i tried to create custom report but report builder require to enter data source credentials to continue but an error message popup " unable to connect to data source- The certificate chain was issued by an authority that is not trusted ".

I checked test connection and its working fine. I have created many reports before but i changed administrator password after that.

Regards,

• Edited by hiico 21 hours 42 minutes ago

Hi,

you must issue a certificate from a trusting Certificate authority for the SQL reporting service, and all clients which access the reporting services must trust the Certificate authority.

Another way is to publish the self signed certificate from SQL reporting services with Active Directory Group policies