Unable to create report from ms excel
-
19 марта 2012 г. 5:45
Hi all,Whenever i try to generate report its throwing an error tf208056:An error occured while the command was accessing Analysis Services database on theserver.Server is in X location and i am in Y location.
What i did
1. Open excel
2. Go to Team tab
3. Click New Report
4. Select the team project
5. Select a query
As i am part of below groups1)[project name]\Contributers2)[Project name]\Project Administrators.
- Изменено Santosh Kotagi 19 марта 2012 г. 5:48
Все ответы
-
20 марта 2012 г. 5:22Модератор
Hi Santosh,
Thanks for your post.
On the Y location, open VS, connect to your TFS Server using current account, can connect to TFS Server and everything work fine? If Documents and Reports working correctly under Team Projects. Please try the workaround in this feedback: http://connect.microsoft.com/VisualStudio/feedback/details/507777/team-explorer-create-report-in-microsoft-excel-unable-to-create-report. Check the firewall and your account’s permission in SQL Server Analysis Service.
If you turn off the firewall and the account as the administrator in Analysis Service, but you still occurred the same error, I suggest you try to reinstall the Office on Y location. Please refer the solution in this similar post: http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/8f792227-6d78-41f4-aa89-9a2468773b66/.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
- Изменено John QiaoMicrosoft Contingent Staff, Moderator 20 марта 2012 г. 5:22
- Помечено в качестве ответа John QiaoMicrosoft Contingent Staff, Moderator 23 марта 2012 г. 6:01
-
22 марта 2012 г. 7:24Модератор
Hi Santosh,
If misunderstood anything, please describe your question in more detail and we will be able to provide the better responses.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
