locked
This operation is not supported on a report server that is configured to run in Sharepoint integrated mode

    Question

  • I have a tfs 2010 and SP 2010, sql report server in Sharepoint integrated mode setup correctly and can access http://tfs2010:8080/tfs without any problem. However, whenever I try to create a new project it fails and get the message :

    TF218027 This operation is not supported on a report server that is configured to run in Sharepoint integrated mode

    or

    The following reporting folder could not bne created on the server that is runing SQL server Reporting services : /TfsReports/DefaultCollection

    I doubted permissions and Even I even added The account running TFS services in Domain admins but it didn't help.

     

    Is it true that if tfs uses SP 2010 with RS in integrated mode is not compatible?

     

    Thanks for your help

    Thursday, October 13, 2011 8:00 PM

Answers

  • Dear Vicky,

     

    I cleared the configuration for reports folder and unchecked "Use reprots" in the Reports menu, rebooted the machine, opened VS on my laptop,

    - tried to create a test TFS new project, with the option "do not configure a Sharepoint....", it worked:

    - tried to create a test1 TFS new project with Sharepoint project portal to be configured, I get the following error  

    TF218017: A SharePoint site could not be created for use as the team project portal. The following error
    occurred: TF249064: The following Web service returned an response that is not
    valid: http://moss:8080/_vti_bin/TeamFoundationIntegrationService.asmx.
    This Web service is used for the Team Foundation Server Extensions for SharePoint Products. Either
    the extensions are not installed, the request resulted in HTML being returned, or there is a problem with
    the URL. Verify that the following URL points to a valid SharePoint Web application and that the application
    is available: http://moss:8080. If the URL is correct and the Web application is operating normally, verify
    that a firewall is not blocking access to the Web app
    lication. (type TeamFoundationServerException)

    So what else should be dropped?

     

    • Marked as answer by eliassal Monday, October 17, 2011 6:07 PM
    Friday, October 14, 2011 3:52 PM

All replies

  • The Sharepoint Integrated mode is not supported. You can see that in that in the install guide of TFS 2010: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24337

    In the topic "How to: Manually Install SQL Server 2008 for Team Foundation Server" you find information how to setup the Reporting Services.

     

    It says "You should not click Install the SharePoint integrated mode default configuration. Team Foundation Server does not support this configuration mode."


    Please remember to mark the replies as answers if they help.
    Thursday, October 13, 2011 11:47 PM
  • Ok Thanks. But why I can not create any new TFS project even when I chose "don't configure portal site at this time"....I get the smae error.

     

    2nd, can you please let me know if I can point it to another Report server

    Regards

    Friday, October 14, 2011 5:58 AM
  • Thanks Ewald for your kindly help.

    Hello eliassal,

    Thanks for your post.

    Ewald is correct that you can only set your Reporting Service to be Native mode if you want to integrate it with your TFS server, and the SharePoint Integrated mode is not supported.

    1). But why I can not create any new TFS project even when I chose "don't configure portal site at this time"....I get the smae error.

    I want to say that portal relates to SharePoint product not the Reporting Service. If you do not want to configure your team project integrated with Reporting Service, please clear the configuration for the team project collection in the TFS Administration Console.

    On the Team Project Collections page of the TFS Administration Console, click the appropriate team project collection. On the Reports Folder tab, please click the Clear Configuration link to unconfigure the reporting service for you. Please see the following screenshot:

    2). 2nd, can you please let me know if I can point it to another Report server

    Yes, it is possible for you to change the Report Service Mode of your reporting service. Please refer to this article for further information:

    http://msdn.microsoft.com/en-us/library/bb326407.aspx

    Thanks.


    Vicky Song [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, October 14, 2011 6:56 AM
    Moderator
  • So many thanks Vicky. When I have setup TFS initially, my report server was in native mode. I was able to create a couple of projects in VS. It was 3 months back when I needed to switch to integrated mode for internal reasons and forgot completely this point.

     

    This week I had to create a new TFS project and discovered this issue. My 2nd question is about a procedure to point my TFS to a 2nd sql reporting service (I have anoher sql which 2005, not 2008 R2 as the one I use with SP) and using the one that is in integrated mode as I it is not possible to switch for business reasons.

     

    Thanks again

    Friday, October 14, 2011 8:23 AM
  • Dear Vicky,

     

    I cleared the configuration for reports folder and unchecked "Use reprots" in the Reports menu, rebooted the machine, opened VS on my laptop,

    - tried to create a test TFS new project, with the option "do not configure a Sharepoint....", it worked:

    - tried to create a test1 TFS new project with Sharepoint project portal to be configured, I get the following error  

    TF218017: A SharePoint site could not be created for use as the team project portal. The following error
    occurred: TF249064: The following Web service returned an response that is not
    valid: http://moss:8080/_vti_bin/TeamFoundationIntegrationService.asmx.
    This Web service is used for the Team Foundation Server Extensions for SharePoint Products. Either
    the extensions are not installed, the request resulted in HTML being returned, or there is a problem with
    the URL. Verify that the following URL points to a valid SharePoint Web application and that the application
    is available: http://moss:8080. If the URL is correct and the Web application is operating normally, verify
    that a firewall is not blocking access to the Web app
    lication. (type TeamFoundationServerException)

    So what else should be dropped?

     

    • Marked as answer by eliassal Monday, October 17, 2011 6:07 PM
    Friday, October 14, 2011 3:52 PM