在Excel中创建TFS报告时出错 [英] Error creating TFS report in Excel
问题描述
尝试在"团队"下创建新报告时出现以下错误： Excel中的选项卡：
TF208098：Office Excel无法访问服务器SERVERNAME \INSTANCENAME上的Analysis Services数据库Tfs_Analysis。稍后再次尝试操作。如果问题仍然存在，请与数据库管理员联系以确保处理Analysis
服务数据库。
我以域管理员身份登录并且TFS服务器已加入同一个域名。我在服务器上的SQL Server实例中具有sysadmin角色。为了确保我也将自己添加到分析服务数据库中的TfsWarehouseDataReader角色。
我在这里缺少什么？
你好BHenson001，
感谢您在此发帖。
< p style ="line-height：150％">根据这个
page ，如果要创建Excel报表，则应该在Analysis Services中属于
到TfsWarehouseDataReaders安全角色。既然你已经加入了它，我认为这个问题与权限无关。所以我建议你可以尝试删除当前的Tfs_Analysis
数据库，然后使用TFS管理控制台重新创建它，然后手动处理多维数据集：
要删除Tfs_Analysis数据库，您可以使用 Microsoft SQL Server Management Studio 连接到
Analysis Service ，展开"数据库"节点，然后删除Tfs_Analysis数据库。并使用相同的方法从SQL Server中删除Tfs_Warehouse数据库。要重新创建Tfs_Warehouse
和Tfs_Analysis数据库，请参考以下步骤：
1.Launch TFS管理控制台>>应用程序层>>报告，在右侧面板中，单击
编辑以打开报告窗口。
2.在
仓库标签下，在数据库文本框。
3.在
Analysis Services下标签，在数据库文本框下输入Tfs_Analysis，并在
帐户下重新提供所需帐户以访问数据源。
4.单击
Ok 在SQL Server中生成新的Tfs_Warehouse和Tfs_Analysis数据库&NBSP;
5.点击
启动工作， 开始重建以重建仓库和Analysis Services数据库。
创建TFS仓库和分析数据库之后成功，请手动处理仓库数据和分析数据，以立即完成重建。有关详细步骤，请参阅以下
链接：
这个问题仍然存在碰巧，你可以从角色中删除自己并重新添加。
最好的问候
Limitxiao Gao
I am getting the following error when attempting to create a new report under the "Team" tab in Excel:
TF208098: Office Excel is unable to access the Analysis Services database Tfs_Analysis on server SERVERNAME\INSTANCENAME. Try the operation again at a later time. If the problem persists, contact the database administrator to make sure that the Analysis Services database is processed.
I am logged in as a domain admin and the TFS server is joined to the same domain. I have the sysadmin role in the SQL Server instance on the server. Just to be sure I also added myself to the TfsWarehouseDataReader role in the analysis services database.
What am I missing here?
Hi BHenson001,
Thank you for posting here.
According to this page, you should belong to TfsWarehouseDataReaders security role in Analysis Services if you want to create Excel report. Since you have added yourself to it, I think this issue has nothing to do with the permission. So I suggest that you could try to delete the current Tfs_Analysis database, and recreate it using TFS Admin Console, then manually process the cube:
To delete the Tfs_Analysis database, you can connect to Analysis Service using Microsoft SQL Server Management Studio, expand the Databases node, then delete the Tfs_Analysis database. And use the same way to delete Tfs_Warehouse database from SQL Server. To recreate the Tfs_Warehouse and Tfs_Analysis database, please refer to the following steps:
1.Launch TFS Admin Console>>Application Tier>>Reporting, in the right panel, click Edit to open the Reporting windows.
2.Under Warehouse tab, type Tfs_Warehouse under Database textbox.
3.Under the Analysis Services tab, input the Tfs_Analysis under Database textbox, and re-provide the required account under Account for accessing data source.
4.Click Ok to generate the new Tfs_Warehouse and Tfs_Analysis database in SQL Server.
5.Click Start Jobs and Start Rebuild to rebuild warehouse and the Analysis Services database.
After created TFS warehouse and analysis databases successfully, please manually processing the Warehouse data and Analysis data to complete the rebuild immediately. For detailed steps, please refer to the following link:
https://msdn.microsoft.com/en-us/library/ff400237%28v=vs.120%29.aspx?f=255&MSPPError=-2147217396
It this issue still happens, you could remove yourself from the role and re-add.
Best Regards
Limitxiao Gao
这篇关于在Excel中创建TFS报告时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
