Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Error running sql 2005 report builder from any user except Administrator

Posted on 2007-11-19
7
Medium Priority
?
541 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:lschroeder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 18

Expert Comment

by:PFrog
ID: 20318514
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.
0
 

Author Comment

by:lschroeder
ID: 20320250
Yep, only Windows Authentication is ticked under Autnentication Methods? What else could I be missing?
0
 
LVL 18

Expert Comment

by:PFrog
ID: 20320327
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.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

Author Comment

by:lschroeder
ID: 20320421
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.
0
 
LVL 18

Expert Comment

by:PFrog
ID: 20320514
Have you tried explicitly setting authentication for your users on this reportserver\reportbuilder folder? (You'll need to disable anonymous authentication to test this)

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 
0
 

Author Comment

by:lschroeder
ID: 20321374
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?
0
 
LVL 18

Accepted Solution

by:
PFrog earned 2000 total points
ID: 20326986
I'll talk you through the permissions I've got set on one of my servers. It's not part of a domain so I have granted permissions to the MyServer\MyUser account. This user has access to Report Server, Report Manager and Report Builder. I can connect from another PC/domain using MyServer\MyUser windows auth.

Folder Permissions
   c:\program files\Microsot SQL Server\MSSQL.3\Reporting Services\ReportManager
         MyServer\Users - Read & Execute, List Folder Contents, Read
   c:\program files\Microsot SQL Server\MSSQL.3\Reporting Services\ReportServer
         MyServer\Users - Read & Execute, List Folder Contents, Read

IIS Permissions
    Reports
         Read
         Execute permissions: Scripts Only
         Directory Security: Integrated Windows Authentication
    ReportServer
         Read
         Execute permissions: Scripts Only
         Directory Security: Integrated Windows Authentication
    ReportServer\ReportBuilder
         Read
         Execute permissions: Scripts Only
         Directory Security: Integrated Windows Authentication

SSRS System Role Assignments    (via Site Settings, Site-Wide Security in Report Manager)
    BUILTIN\Administrators     - System Administrator
    MyServer\MyUser   - System User

SSRS Role Assignments  (via properties tab on home page of Report Manager)
    BUILTIN\Administrator\     - Content Manager
    MyServer\MyUser   - Browser, Publisher, Report Builder

All SSRS folders inherit the security settings from the home folder.


   
   
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question