Solved

Error running sql 2005 report builder from any user except Administrator

Posted on 2007-11-19
7
533 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
  • 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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 500 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 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