Why do I get prompted for "Data Source Credentials" when editing a SSRS report for SCCM?
The solution was two-fold:
- I exported the certificate from the primary site sever under "Personal\Certificates" the friendly name is "ConfigMgr SQL Server Identification Certificate." I then imported the certificate to my local workstation under "Trusted Root Certificate Authorities\Certificates." This allowed me to connect to SQL server when I choose "Use the current Windows user." Before I made this change I would get a certificate error when choosing this option.
- I had the DBA enable db_datareader access explicitly for my user in SQL Server.
When creating a dataset I still was prompted for credentials but I can now select current user and create queries.