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
Solved

Error running sql 2005 report builder from any user except Administrator

Posted on 2007-11-19
7
534 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

791 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