We have SCCM 2012 using a separate SQL server on the back end. I can edit reports, create new datasets using only the "SCCM Administrator" user locally and remote.
I had an issue editing the query for the datasets remotely until importing the SQL server's certificate to the local desktop's certificate store. But that much is resolved now.
I have (domain) users who have been assigned a "Report Administrator" rule. They can create and edit reports remotely. But they cannot edit queries b/c the SQL server Report Builder prompts for credentials to the Data Source when opening the dialog box to edit the query.
The error is "unable to connect to data source", with details showing that the login failed for the domain user.
I've tried adding a SQL login for one of the domain users but it did not work in my initial tests. Maybe I did something wrong?
I'm new to SQL Report Builder. Can someone walk me through what's missing for these domain users to be able to access the Data Source so they can edit queries?