I have some problems with permissions in ssrs 2005.
1) I have created report in BIDS. Report consist of some fields, some of them have subreports. I can open project with no problems(local admin) but other user, which i give permission to view it, cant view parent report, but can view subreport.
I noticed, that users can open simple reports and cant open reports with subreports. Its shows next error:
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
In event viewer on server i can see Failure Audit event with "login failed "username"".
2)Second problem is that i cant publish reports from BIDS to report server(im developing it on server) when all other users of server can.
Will be gratefull for any help.
View Complete Post