none
Cannot Connect to Reporting Server

    Question

  • When trying to configure "Reporting" in Team Foundation Server 2010 I get the following error: "The specified configuration is invalid. Update the fields as indicated for each tab." And in the dialog box the following error displays "The server that you specified was not found or cannot be reached. Specify another server."

    However when i put in the name of my SQL Server 2008 R2 server and click "Populate URLs" it finds my Reporting Server. Warehouse and Analysis Services succeed when i test the connection.

    Configuration: I have two servers (both Windows 2008 R2) one running SQL Server 2008 R2 with Reporting Service and Analysis Services configured. The other with SharePoint 2010 and  TFS 2010 installed and configured. On the TFS/SharePoint server i have the SQL Client Connectivity tools installed also. The SQL server has Reporting Service is configured with SharePoint Integration and i have firewall ports 1433 (TCP) and 1434 (UDP) ports open.

    Any Ideas why it cannot configure TFS 2010 Reporting?

    Friday, January 21, 2011 7:58 PM

Answers

All replies

  • Hello GT Hardy,

    When you configure Reporting in the TFS Administration Console, what is the Server name are you using? Is it the one which has TFS2010 installed? Are the setting is the same as that in the Reporting Services Configuration Manager?

    Please go to Start->All Programs->Microsoft SQL Server 2008->Configuration Tools->Reporting Services Configuration Manager.

    Check the settings of the Web Service URL, and Report Manager URL and Database are the same as these on the TFS Administration Console.

    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.

    Monday, January 24, 2011 5:34 AM
  • SQL Server and Reporting Service Configuration:

    Web Service Url: http://dv02:80/ReportServer

    Report Manager Url: http://dv02:80/Reports

    SQL Server Instance: DV02

    Service Account: Domain\SPReports

    Report Server Mode: SharePoint Integrated

    SharePoint/TFS 2010 Configuration:

    Server Name: INT01

    Warehouse:

    Server: DV02

    Database: Tfs_Warehouse

    Test Connection: (Green Checkmark Image)The database that you specified does not exist. A new database will be created and populated for use with team foundataion server.

    Analysis Services

    Server: DV02

    Database: Tfs_AnalysisServices

    Account: Domain\SPReport (Account used to configure Reporting Services)

    Test Connection: (Green Checkmark Image)The database that you specified does not exist. A new database will be created and populated for use with team foundataion server.

    Reports

    Server: DV02 > Populate URLs (resolves the below urls)

    Web Service: http://dv02:80/ReportServer

    Report Manager: http://dv02:80/Reports

    Account: Domain\SPReport (Account used to configure Reporting Services)

    Default Path: /TfsReports

    Click > OK

    ------------------------------------

    These are the Errors i get.

    "Error: The specified configuration is invalid. Update the fields as indicated for each tab."

    Warning: The server that you specified was not found or cannot be reached. Specify another server.

    Troubleshooting

    from server INT01 i can "telnet dv02 80" and it goes through. Any Ideas?

    Monday, January 24, 2011 1:29 PM
  • Hi GT Hardy,

    Instead of installing Report Service with SharePoint Integrated mode, you should have Native mode.

    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.

    • Marked as answer by GT Hardy Tuesday, January 25, 2011 3:04 PM
    Tuesday, January 25, 2011 11:00 AM
  • Yes that was it; needs to be in native mode. Also use the Network Service account for SQL Reporting Services or configure your Domain\ServiceAccount with kerberos authentication. Otherwise you get a prompt for credentials. Both were my issues. Below describes why it happens.

    http://blogs.msdn.com/b/lukaszp/archive/2008/03/26/solving-the-reporting-services-login-issue-in-the-february-ctp-of-sql-server-2008.aspx

    Tuesday, January 25, 2011 3:09 PM
  • I have a similar configuration as GT Hardy above, but the above recommended operations (install SSRS in Native Mode, run SSRS as the Network Service) do not resolve the issue. 

    My only difference is I am running SSRS 2012 on a non-standard port, and using TFS 2013. I can connect to the SSRS URLs in IE so I know it's not a firewalling/password/SSRS invalid configuration issue. 

    Any thoughts?

    Ed


    Monday, February 03, 2014 9:35 AM