Im not sure if this is an SSRS issue or SQL server security issue but Ive created domain level groups, added my specific users to the groups and created a new user from that group on my SQL server. I want to allow these users to run my SSRS reports so am I correct in thinking I need to add these users to the db_datareader group? Im missing something as when I get the users to log into the server they aren't asked for credentials (which is correct as its using the windows credentials) and they can see the report but when they run the report they get
"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source '###'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors"
On the data source of the report I've set it to "Use current Windows user. Kerberos delegation might be required"
Any ideas please?