coecho
asked on
SQL Server Reporting Services Permission Issue
I'm trying to connect to SQL Server Reporting Services from a new Database Server. Administrators on the Dataabase server are fine... but other NT Users (I'm using NT Authentication) - are authenticating but then failing when the Report Server Web Service tries to retrieve the current catalogs on the Report Server DB. The user is a member of a group which does have rights on the DB:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 5/5/2009
Time: 11:34:01 AM
User: N/A
Computer: FCCAPP03
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/5/2009 11:34:01 AM
Event time (UTC): 5/5/2009 5:34:01 PM
Event ID: b77ad3591b4d4046bffd321eb4 fc30c1
Event sequence: 18
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/ReportCen ter-1-1288 6018411399 8652
Trust level: Full
Application Virtual Path: /ReportCenter
Application Path: c:\inetpub\wwwroot\ReportC enter\
Machine name: FCCAPP03
Process information:
Process ID: 5144
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SoapException
Exception message: The permissions granted to user 'FLATIRONCORP\draizen2' are insufficient for performing this operation. ---> The permissions granted to user 'FLATIRONCORP\draizen2' are insufficient for performing this operation.
Request information:
Request URL: http://fccapp03/ReportCenter/BatchReport.aspx?ScheduleID=693bed2a-8244-4eea-9fa8-113db035dc07&ScheduleReportID=6eb6032b-85bf-4571-962b-78cd9b355067
Request path: /ReportCenter/BatchReport. aspx
User host address: xxxxxxx
User: FLATIRONCORP\xxxxxxx
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Web.Services.Protoc ols.SoapHt tpClientPr otocol.Rea dResponse( SoapClient Message message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protoc ols.SoapHt tpClientPr otocol.Inv oke(String methodName, Object[] parameters)
at ReportService.ReportingSer vice2005.G etItemData Sources(St ring Item) in c:\WINDOWS\Microsoft.NET\F ramework\v 2.0.50727\ Temporary ASP.NET Files\reportcenter\f074aec f\6729dd78 \App_WebRe ferences.2 2jqym08.0. cs:line 2422
at BatchReport.LoadPageValues () in c:\Inetpub\wwwroot\ReportC enter\Batc hReport.as px.cs:line 58
at BatchReport.Page_Load(Obje ct sender, EventArgs e) in c:\Inetpub\wwwroot\ReportC enter\Batc hReport.as px.cs:line 28
at System.Web.Util.CalliHelpe r.EventArg FunctionCa ller(IntPt r fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEvent HandlerDel egateProxy .Callback( Object sender, EventArgs e)
at System.Web.UI.Control.OnLo ad(EventAr gs e)
at System.Web.UI.Control.Load Recursive( )
at System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt)
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Any ideas on what's going ton would be greatly appreciated! I've spent a lot of time on this and still cannot get it working.
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 5/5/2009
Time: 11:34:01 AM
User: N/A
Computer: FCCAPP03
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/5/2009 11:34:01 AM
Event time (UTC): 5/5/2009 5:34:01 PM
Event ID: b77ad3591b4d4046bffd321eb4
Event sequence: 18
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/ReportCen
Trust level: Full
Application Virtual Path: /ReportCenter
Application Path: c:\inetpub\wwwroot\ReportC
Machine name: FCCAPP03
Process information:
Process ID: 5144
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SoapException
Exception message: The permissions granted to user 'FLATIRONCORP\draizen2' are insufficient for performing this operation. ---> The permissions granted to user 'FLATIRONCORP\draizen2' are insufficient for performing this operation.
Request information:
Request URL: http://fccapp03/ReportCenter/BatchReport.aspx?ScheduleID=693bed2a-8244-4eea-9fa8-113db035dc07&ScheduleReportID=6eb6032b-85bf-4571-962b-78cd9b355067
Request path: /ReportCenter/BatchReport.
User host address: xxxxxxx
User: FLATIRONCORP\xxxxxxx
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Web.Services.Protoc
at System.Web.Services.Protoc
at ReportService.ReportingSer
at BatchReport.LoadPageValues
at BatchReport.Page_Load(Obje
at System.Web.Util.CalliHelpe
at System.Web.Util.CalliEvent
at System.Web.UI.Control.OnLo
at System.Web.UI.Control.Load
at System.Web.UI.Page.Process
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Any ideas on what's going ton would be greatly appreciated! I've spent a lot of time on this and still cannot get it working.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Meant to add a png to show the screen:
SSRS-New-Role-Assignment.png
SSRS-New-Role-Assignment.png
ASKER
thanks. I tried modifying the site wide settings (added as user and as AD Group) - but I'm still getting the error. BTW - I only saw "System Administrater" and "System User" roles. I didn't see a "Browser" role like you described.
rsr.doc
rsr.doc
ASKER
It turned out that some of the other permissions were set incorrectly on some of the reports as well. Once I fixed those, draizen2 was able to access the reports.
ASKER
thanks for your help. This was an extremely frustrating problem for me.
can this user access the repoting server directly? http://servername/reports