Hi,

Simply, when I log onto my server with a local or domain admin and open report Builder, I right click

on Data Sources and choose add. I choose the one (only one) in the list and test (successfully) the connection.

However, no other users see the Data source and trying to create one fails. They are local administrators. They have been added as admins in SQL and the DBs. I have rechecked all the permissions and the user has full admin rights to the server, SQL and DBs. ????

Hi Analog-Kid,

According to your description, when users click Edit in Report Builder on report server to launch click-once report builder, if users want to add a shared data source, they cant see the shared data source list which resides on the report server, right?

In your scenario, please check if those users could access the Data Sources folder on the report server. If not, please grant users permission to access this folder with Content Manager role on Security page. Also please connect to report server instance from SSMS, then check if Manage data sources has been selected.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu