• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

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
0
Larry Schroeder
Asked:
Larry Schroeder
  • 4
  • 3
1 Solution
 
PFrogCommented:
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
 
Larry SchroederAuthor Commented:
Yep, only Windows Authentication is ticked under Autnentication Methods? What else could I be missing?
0
 
PFrogCommented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Larry SchroederAuthor Commented:
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
 
PFrogCommented:
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
 
Larry SchroederAuthor Commented:
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
 
PFrogCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now