Error running sql 2005 report builder from any user except Administrator
I have been testing SQL reporting services and I am about ready for some report writers to have at it. The last thing I need to do is all them to access the report builder with their user name. I have already added them to the SQL reporting groups on the server. I have also added then in site wide security. I stil receiv the following error when they try to start the Report Builder. "cannot retreive application. Authentication error"
Thanks for the help!
Larry
Thanks for the help!
Larry
PFrog
Check the security on your IIS virtual directories (Reports and ReportServer) and make sure you don't have basic authentication selected. You should only have Windows Authentication ticked.
ASKER
Yep, only Windows Authentication is ticked under Autnentication Methods? What else could I be missing?
Still within IIS admin, what permissions have you got on the following folder?
ReportServer\ReportBuilder
Set this to anonymous access (just this sub folder, NOT the whole ReportServer folder) and see if this works.
ReportServer\ReportBuilder
Set this to anonymous access (just this sub folder, NOT the whole ReportServer folder) and see if this works.
ASKER
That did work but it is sort of cumbersome. I have to log into reporting services home page and then I need to log in again once report builder starts. Is there a better weay to get this to work?
At least is should be able to be tested now.
At least is should be able to be tested now.
Have you tried explicitly setting authentication for your users on this reportserver\reportbuilder
Have a read through this article, it describes the same problem with a number of options
http://www.codeprof.com/dev-archive/96/19-82-964726.shtm
Have a read through this article, it describes the same problem with a number of options
http://www.codeprof.com/dev-archive/96/19-82-964726.shtm
ASKER
I think I need to start over with permissions. Everything works well from the server. I can create reports, etc. From a desktop, I have gotten as far as trying to create a report. When i run a report I get an error that I cannot connect to the database. It seems i am making it more complicated than it really should be.
Could you help by starting over as to what I need for permissions for users to create reports?
Could you help by starting over as to what I need for permissions for users to create reports?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.