I (think) i migrated a 2000 reporting service database over to 2008. I say i think because i'm getting some weird behavior. I have a folder where i place all the datasources. On most of them, if i click manage, and then test connection, i get an error of:
The permissions granted to user <my login> are insufficient for performing this operation. (rsAccessDenied)
I am listed as the system admin and system user under site settings, security. I tried changing it to just sys admin. That seems to have given me access to test at least some of the data sources.
I compared the security settings on the ones i can test vs the ones i cant, and they are the same. I have no problems running the reports attached to this datasource.
Is this a permission issue on the source database? Because i tried creating a new datasource to the same source db and got the same error. But wouldn't the test connection button use the credentials supplied if i have NOT selected the otion to use windows
credentials? Although one of the databases that i CAN use the test connection button on, i do not have permission to connect to using my windows login.
So i really have no clue why i seem to be unable to 'test connection' on some of the datasources. Any suggestions?
View Complete Post