Solved

Error running sql 2005 report builder from any user except Administrator

Posted on 2007-11-19
7
530 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
Comment Utility
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
Comment Utility
Yep, only Windows Authentication is ticked under Autnentication Methods? What else could I be missing?
0
 
LVL 18

Expert Comment

by:PFrog
Comment Utility
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:lschroeder
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
index  - last use and update 8 50
SQL help 5 46
SQL Select - Finding chars in a column 2 47
Set the max value for a column 7 32
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.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now