I configured our Reporting Service Integration in Central Admin to use the Trusted authentication mode. From what I understand, this mode allows a data source to run using stored credentials. I also thought that while configured to use Trusted authentication, integrated security is not an option. Well in my case it is the opposite plus an additional problem. I am not only able to use integrated security, I must. If I try to store credentials in the data source I am shown the error: "The given key was not present in the dictionary".
At this point I assumed my understanding of Trusted authentication mode was backwards so I switched it to Windows Authentication but there was no change. Can someone help me understand what I get by choosing one of these authentication modes or the other?
