Insufficient permissions for ReportService2005.asmx

Topics: For TFSAdmin Users
Jan 27, 2011 at 6:38 AM

Hi,

Wanted to try out your tool, but when trying to make a connection from both outside or office or even from within with my account, I always get the following error and don't have a clue for the moment where exactly to look :-( :-( 

27/01/2011 8:23:07: TFS Administration Tool (2.1.31204.0) has started
27/01/2011 8:23:08: Button clicked: Server Explorer CONNECT
TFS::Authenticate : Caught exception : Microsoft.TeamFoundation.TeamFoundationServerUnauthorizedException: TF30063: You are not authorized to access XXX.com. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized.
   at System.Net.HttpWebRequest.GetResponse()
   at Microsoft.TeamFoundation.Client.TeamFoundationClientProxyBase.AsyncWebRequest.ExecRequest(Object obj)
   --- End of inner exception stack trace ---
   at Microsoft.TeamFoundation.Client.TeamFoundationClientProxyBase.ProcessHttpResponse(HttpWebResponse response, Stream responseStream, WebException webException, XmlReader& xmlResponseReader)
   at Microsoft.TeamFoundation.Client.TeamFoundationClientProxyBase.ExecWebServiceRequest(HttpWebRequest request, XmlWriter requestXml, String methodName, HttpWebResponse& response)
   at Microsoft.TeamFoundation.Framework.Client.LocationWebService.Connect(Int32 connectOptions, ServiceTypeFilter[] serviceTypeFilters, Int32 lastChangeId)
   at Microsoft.TeamFoundation.Framework.Client.FrameworkServerDataProvider.Connect(ConnectOptions connectOptions)
   at Microsoft.TeamFoundation.Framework.Client.FrameworkServerDataProvider.EnsureConnected(ConnectOptions optionsNeeded)
   at Microsoft.TeamFoundation.Framework.Client.FrameworkServerDataProvider.EnsureAuthenticated()
   at Microsoft.TeamFoundation.Client.TfsConnection.<EnsureAuthenticated>b__0()
   at Microsoft.TeamFoundation.Client.TfsConnection.UseCredentialsProviderOnFailure(Action action)
27/01/2011 8:23:45: Connecting to Team Project Collection: xxx.com\xxxCollection
27/01/2011 8:23:47: Successfully connected to Team Project Collection: xxx.com\xxxCollection (Tfs2010)
27/01/2011 8:23:49: Selecting Team Project: xxx
27/01/2011 8:23:49: Getting list of users for Team Foundation Server: xxx.com\xxxCollection, Team Project: xxx
27/01/2011 8:23:53: UserGroup.Url: http://xxx.com:10080/sites/xxxCollection/xxx/_vti_bin/usergroup.asmx
27/01/2011 8:23:53: SharePoint site status: Available
27/01/2011 8:23:53: SharePoint version: WSS4
27/01/2011 8:23:53: PortalType: WssSite
27/01/2011 8:23:53: Exception occurred
                       Type: System.Web.Services.Protocols.SoapException
                       Message: The permissions granted to user 'xxx\kris' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'xxx\kris' are insufficient for performing this operation.
                       InnerException: -
                       Source: System.Web.Services
                       Target: System.Object[] ReadResponse(System.Web.Services.Protocols.SoapClientMessage, System.Net.WebResponse, System.IO.Stream, Boolean)
                       Stacktrace:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at TFSAdministrationTool.Proxy.ReportServer.ReportingService2005.GetPolicies(String Item, Boolean& InheritParent) in D:\Work\TFSAdmin\Main\src\TFSAdministrationTool.Proxy\Web References\ReportServer\Reference.cs:line 3358
   at TFSAdministrationTool.Proxy.ReportServiceProxy.GetSecuritySettings(String name) in D:\Work\TFSAdmin\Main\src\TFSAdministrationTool.Proxy\ReportServiceProxy.cs:line 177
27/01/2011 8:23:53: ReportingService.Url: http://xxxx.com:10280/ReportServer_xxx/ReportService2005.asmx
27/01/2011 8:23:53: Reporting Services site status: Unauthorized
27/01/2011 8:23:53: ReportWebServiceUrl: http://xxx.com:10280/ReportServer_xxxx/ReportService2005.asmx
27/01/2011 8:23:53: Initializing roles
27/01/2011 8:23:53: Initializing roles mapping

Can you help me out on figgering out which 'rights' exactly I might be missing and where to configure this?

Tia.

Wkr,

Kris.

 

Coordinator
Feb 13, 2011 at 11:12 AM

Could you please make sure that you all the permissions described in this MSDN article: http://msdn.microsoft.com/en-us/library/dd547204.aspx. Let me know how it goes.

Thanks, Ladislau

Feb 14, 2011 at 4:31 PM

Hi Ladislau,

Thx for the link! I was missing only 1 'right'. After following the instructions in this section now have no problem in connecting the TFS Administration Tool to our TFS environment.

To grant administrative permissions for a team project collection in Reporting Services

Thx for the help8

Wkr,

Kris.

Mar 14, 2011 at 10:54 PM

I have all the permissions but the Reporting Services comes dissable.

This is what the log says.

 

3/14/2011 3:51:08 PM: ReportingService.Url: http://<mycoolectionurlhere>//DummyReportServiceUrl.asmx
3/14/2011 3:51:08 PM: Reporting Services site status: Unavailable

 

How is this "//DummyReportServerUrl.asmx" getting appended here?

 

 

Coordinator
Mar 20, 2011 at 1:17 PM

@Eduardo: The DummyReportServiceUrl.asmx gets appended in case Reporting Services is not configured for the team project collection (you can use the Administration Console to check that) or if the server returns and empty URL for the Reporting Services web service. Could you please install Team Foundation Server 2010 Service Pack 1 on your server and let me know if the issue still occurs.

Thanks, Ladislau