Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Insufficient permissions?

Author  Topic 

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2013-11-26 : 16:15:09
In Report Manager, I tried to modify a data source to use specific credentials (mine). However, when I hit the test connection button it told me I had insufficient permissions.

So, I configured the source as Prompt User for credentials and ran the report fine.

It seems like a contradiction to me but then I'm usually wrong about such things.

Any ideas/explanations?
   

- Advertisement -