配置tfs 2015报告时出现问题 [英] Problem configuring tfs 2015 reporting

问题描述

我正在尝试为TFS 2015配置报告。我有一个仅用于报告的服务器，它同时运行sql报告和分析服务。报表服务器是一个单独的服务器，而不是包含所有tfs数据库的sql server。
因此，报告配置向导，仓库，Analysis Services和报告中有3个选项卡。每个都有一个测试连接按钮，当我测试它时，它在Analysis Services和Reports上成功，但在Warehouse上失败。 
返回的错误是"您指定的SQL Server和实例未找到或无法访问。" 指定另一个服务器或实例。" 我为Warehouse和Analysis Services列出了完全相同的服务器名称，所以我很困惑
，为什么它找到一个服务器而不是另一个服务器。  ;我有数据库名称为TFS_Warehouse。

---

John Bruno

I'm trying to configure reporting for TFS 2015. I have a server set up just for reporting, which has both the sql reporting and analysis services running on it. The report server is a separate server than my sql server that houses all the tfs databases. So there are 3 tabs on the Reporting configuration wizard, Warehouse, Analysis Services, and Reports. There is a test connection button on each, and when I test it, it succeeds on Analysis Services and Reports, but fails on Warehouse.  The error that comes back is "The SQL Server and instance that you specified was not found or cannot be reached.  Specify another server or instance." I have the exact same server name listed for Warehouse and Analysis Services, so I'm confused as to why it finds the server for one, but not the other.  I have the database name as TFS_Warehouse.

---

John Bruno

推荐答案

John Bruno，

Hi John Bruno,

您的意思是指定相同的非默认 仓库和Analysis Services中的SQL Server实例名称   Warehouse中的测试连接出现此错误？

Did you mean you specify the same non-default  SQL Server Instance name in Warehouse and Analysis Services, the Test Connection in Warehouse got this error?

有  你添加了
Reporting Services和Analysis Services到SQL Server  ？ 

Have you added Reporting Services and Analysis Services to SQL Server?  

您可以按照本文向TFS添加报告功能：

You could follow this article to add reporting feature to TFS:

https://dzone.com/articles/integrate-reporting-and

最好的问候 

Best Regards 

这篇关于配置tfs 2015报告时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！