Hi, As I described above, I could not activate Agile Dashboards with Excel Reporting v5.0 in the site features in the sharepoint services admin page, and as I noticed it is because I should install moss 2007 before to could do this, but I have only installed sharepoint services 3.0 with update. Reporting (SSRS) package should be installed when sharepoint services is on one maskin and TFS is installed on another, but I have both on the same machine, hence there is no need to install it in this case. The problem with connecting to reporting services is solved and now reports works normaly. Regards meka38. Hi, As I described above, I could not activate Agile Dashboards with Excel Reporting v5.0 in the site features in the sharepoint services admin page, and as I noticed it is because I should install moss 2007 before to could do this, but I have only installed sharepoint services 3.0 with update. Reporting (SSRS) package should be installed when sharepoint services is on one maskin and TFS is installed on another, but I have both on the same machine, hence there is no need to install it in this case. The problem with connecting to reporting services is solved and now reports works normaly. Regards meka38. I installed TFS 2010 on a Windows 2008 Server R2 machine with Sharepoint 2010 and MSSQL 2008 R2. Everything works fine except the report dashboards on the TFS teamproject site. After refreshing a TfsOlapReport Error pops-up with no further information. Same behavior on all machines (including the server).But when I log-on with the Domain-Admin account it works fine (on every machine). I`ve added my testuser to the team-project (via Teamexplorer), to the Sharepoint and to the Reportserver (via browser [Server]/Reports). Jun 20, 2017. A question I often get is how to configure Jira Software's dashboards to show content that's relevant for agile teams. Select the agile board you want to pull data from for the Boardfield; Enable all three options underneath so assignees, sprint name, and board name are always visible; Use the Next Sprint. Creating multiple dashboards is especially useful if the user has different roles in one or many projects as each report page can be tailored to the particular use case's needs. Self-Service / Interoperability: Every filter can be consumed in different formats including MS World, PDF, Excel, JIRA API, RSS feeds. Jan 18, 2017. Create an Excel Dashboard inside of a SharePoint list or library view, using the Excel Viewer web part and an Excel sheet linked to your list or library. We need to Enable the connection. External Data Source. Now we can see all of the data that is pulling from the SharePoint list. Excel Pivot Table. Business KPI Dashboard Reporting Templates Free. Excel Dashboards And Reports For KPI Management. Agile Metrics Dashboards In Excel. Did I miss a permission or something? Thanks in advance. TFS 2010 Dashboards problem! @El_Capitan: I have to choose SSS i geuss but what do i have to fill in the field? I've installed on a single machine: Sql 2008 r2 MOSS2010 TFS 2010 addin/plugin that is needed for TFS with Sharepoint 2010 All is working well except (offcourse) the Burndown dashboard. If i go internally) to i get the following error: On top it states Excel Cannot open this workbook because it contains external data that could not be refreshed. You may not have permission to use the data connections, or the data connections may not be responding to the refresh operation. I have Refresh warning enabled turned off, and eventviewer is empty. At see 1, 2, 3 and 4 (excel web service) that give the error and stay empty. Following services are running: - SQL service - Analyis service - Report service. We've just set up TFS 2010 with Sharepoint 2010, and all the individual Project Collection Dashboards in Sharepoint 2010 look fine. Looks and works great. But if you go to it automatically takes you to all of the web parts there are broken and say that This site doesn't have a default Team Foundation Server instance. You can explicitly select a Team Foundation Server. How do I do that? I'd like to make the top level Dashboard show the user all of their tasks and some other reports across all project collectionsand projects, but I am not sure this is possible. Short of deleting all the web parts off this page and starting from scratch, is there an easy way to do this? Hi Joe, I found the solution two be a combination of items posted here. 1) First, follow the suggestions posted by Cathy and make sure the URL you are using to access the portal sites has been added to SharePoint as an Alternative Access Mapping. I replaced the default zone with my URL as we also plan on adding a second web front end. 2) Second, follow the steps posted here In my case we were migrating our databases to a new server and this included migrating the SharePoint Databases. As a result we had some reconfiguring to do between SharePoint and TFS 2010. Somewhere along the way we lost the portal configuration but step reset that. Note: Make sure the account you are running Team Explorer (User Account) has access to the SharePoint Portals. An easy cheat is to login to SharePoint Central Admin -- Application Management -- Policy for Web Applications and add your account with full controls. This has often been referred to as an Adminstrator Back Door. Thanks, Dennis Bottjer| Follow Me: @dbottjer| Blog: Dennis Bottjer.com. Hi dan, License experts can help you to answer your question. Since the question is a license issue, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. Worldwide customers can use the Guide to Worldwide Microsoft Licensing Sites to find contact information in their locations: regards, Ruiz MSDN Subscriber Support in Forum If you have any feedback on our support, please contact msdnmg @ microsoft.com. Hi Amir, Thanks for your post. Since the question is a license issue, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. (Pacific Time) to speak directly to a Microsoft licensing specialist, and you can get more detail information from there. Worldwide customers can use the Guide to Worldwide Microsoft Licensing Sites to find contact information in their locations: are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey. Our Portal Links webpart always displays it's portal links on the form of the internal URL ie. When we access our TFS-website from outside (though its tunnelled througn ISA Server 2006) we want it to use URLS like I'm not really confident with the AAM, but all the other Sharepoint-links seem to adapt correctly when accessing the tfs-server from outside the office, so maybe there is some TFS-setting that I have to configure differently. Hi David, Thanks for your reply. Because the Team Projects site like the web part(PortalLinksWebPart)s site base on the Team Projects site, of cause it can be accessed from outside. So we need to change the Team Projects site can be accessed from outside first, we should to create a new SharePoint Web Application with the URL which can be accessed from outside, then create the Team Project configured with this SharePoint Web Application so that we can access this Team Project site from outside, I think the web part also can be accessed. John Qiao [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. While attempting to setup our TFS/sharepoint server to use dashboards for tfs reporting I have ran into an impasse. I am unable to activate the Agile Dashboards with Excel Reporting, it just hangs and refreshes the page. In order to be able to activate excel reporting we need the enterprise license of sharepoint 2010 server, but I believe we do. In order to check what license is being used I should be able to go to Central Administration - Upgrade and Migration - Upgrade and Patch Management - Convert farm license type and from there I should be able to see information about the current license used. But there is no option for Convert farm license type as shown below. Hi blipka512_hps, According to your description, my understanding is that you want to use dashboards for TFS reporting in SharePoint 2010. What did you mean for “there is no option for Convert farm license type”? Maybe you forgot to upload the screenshot. Whether you could not enter product key in Convert License Type. If yes, please take a look at: Please make sure Excel services and Secure Store Service are runing. There are some links about configuring SharePoint 2010 for Dashboard with TFS, please take a look at: I hope this helps. Thanks, WendyWendy Li TechNet Community Support. Seems like you upgraded from TFS2008 to TFS2010 on old domain and then did an environment based move of TFS2010 from old domain to new domain. In that case, i would suggest two options 1. If you have bakups of the TFS2010 dbs before environment based move, restore dbs in old domain, do a hardware based move and then domain based move 2. If you can upgrade the dbs once again then perform upgrade to TFS2010 on old domainand then do a environment based move. Correct me if i misunderstood your scenario. Thanks, Chandra. I have an update, but still not a resolution: From the team project portal Site Settings Features Agile Dashboards is active Agile Dashboards with Basic Reporting is active Agile Dashboards with Excel reporting is NOT ACTIVE When I click the Activate button, nothing happens. I don't get any error message or any message at all, but the feature is still not active. What does this mean? Bob ** Hi, I am another who has travailed at various times over the past 6 months to get TFS 2010 integrated with SharePoint Server (SPS) 2010. With the help of recent guidance/postings and the Configure SPS for TFStool I thought I was finally there, but not quite! My objective: integrate TFS and SPS 2010, which are on two separate server machines. I have completed and verified: Account permissions Successfully run the tool and manually verified the excel service and secure store are properly configured Installed the TFS Extensions for SP on the SP server and manually verified that the solutions have been deployed Added the SPS site on the TFS server Configured my TFS collection to use the new SPS site Created a new team project that created a new team project site under the new SPS site collection Brought up the site in the browser YEA! But where are those additional dashboard web parts? I don't seee them anywhere! The site has the same web parts that my old WSS 2007 site had. I verified that I have SharePoint Server 2010 installed on the SP server machine. How do I get those additional web parts to show up? That's what all my effort was for! Still hopefull, but exhausted! Bob Bob Hardister. I downloaded: Microsoft Visual Studio 2010 and Team Foundation Server 2010 Beta 2 for Microsoft Virtual PC 2007 SP1 Image When I go into the default installation of TFS project site in Sharepoint()I get this error on the webparts. There are no accessible team projects in this Team Project Collection. Contact your Team Foundation Server administrator. In the Team Server Admin Console - Team ProjectCollection - Team Projects tab the projects are there. This is the default installation. Any suggestions??? Hi Team Foundation Server 2013 is set up and it is integrated with Sharepoint 2010 Enterprise Edition. When we access the Dashboard from Team Web Access, we get a popup of Excel asking to “connect to External Data source?” Excel This workbook contains one or more queries that refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions. If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook. Do you want to enable queries to external data in this workbook? When we select “Yes”, TFSOLAP Error is displayed. The data connection uses None as the external data authentication method and Unattended Service Account has not been configured. The following connections failed to refresh: TfsOlapReport Excel services is enabled on Sharepoint 2010 Enterprise Edition. Dashboard also connects to SQL Server Analysis Services Cube. Could you please help us to resolve the issue? Is there is any problem with permissions or do we need to do some other settings? Thanks Poonam. I just recently upgraded from TFS 2008 to TFS 2010 and as part of the process, my Reporting portion of the upgrade failed. Therefore, I unchecked the Reporting portion as part of the upgrade and restored the databases manually. I then went back through the TFS configuration wizard to hook those databases up to the Reporting configuration. However, after I did this, all of my default TFS 2008 Reports were broken in my production environment. I set up a similar environment in test with all of the same Team Project structure and was able to upgrade to TFS 2010 successfully without any issues. Since I just want to migrate my Reports and Report structure to my production environment, can I simply follow the outlined steps for migrating my ReportServer and ReportServerTempDB databases from my test environment to production to ensure that all of my default Reports will be working once again, or do I need to do something with the Tfs_Analysis and Tfs_Warehouse databases as well? Are there any other databases that I will need to consider? Please advise since I would like to get my Reports up and running once again so that our project managers can begin using them through the SharePoint Dashboards. Hi Niko, Thanks for your post. TFS Power Tools version need match the VS version. For example, if you installed VS 2010 on your client, you should install TFS 2010 Power Tools, if you installed VS 2013 on your client, you should install TFS 2013 Power Tools on your client, we use VS connect to TFS Server, TFS Power Tools integrate in VS. In your scenario, you should install VS 2013 on your client, then install the TFS 2013 Power Tools. After install them correctly, you can connect to TFS 2010 using your VS 2013 and use the TFS 2013 Power Tools features in your VS 2013. We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey. Hi, I just installed SQL 2008, TFS 2010, Sharepoint 2010 on a non-domain single server. After creating a collection and team project, I get the following errores in my dashbords: Project data is unavailable at this time. As a result, all reports on this dashboard have been hidden. After you have created data in your team project and the warehouse has been processed, reports will be available.Click here for help troubleshooting this problem. No data is available for this team project. Reports will not display until the warehouse completes processing the data. And if I open one of the Excel reports, lets say Remaining Work, the following error occurs: The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh: TfsOlapReport Opening the repot in Excel, I can see the following connection string: Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;User ID=;Initial Catalog=Tfs_Analysis;Data Source=server;Location=server;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error Looks like I have some permission problems to the analysis services data source? I'm accessing the site remotely through if it has anything to do with that. However, I'm gettting the same errors when accessing the site from the server. To change the Excel Reports from Windows Authentication to SSO you need to open the Team Foundation Administration Tool on your Application Tier and configure the reporting settings correctly. In the Team Foundation Administration Tool, select the Extensions for SharePoint Products node, then select Modify Access. Enter your SSO name in the Enterprise Application Definition field. Additional troubleshooting steps: http://blogs.msdn.com/b/granth/archive/2009/12/03/tfs2010-troubleshooting-sharepoint-dashboards-data-source-problems.aspx. Hello, I've read all the existing forums and so far no solutions have fixed my issues. I have TFS 2010 setup to create projects dashboards in SharePoint 2010. When opening a Dashboard this message appears at the bottom of the page: The following system error occurred: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. The following pop-up message also appears for each excel graph on the page: An error occurred during an attempt to estabolish a connection to the external data source. The following connections failed to refresh: TfsOlapReport When downloading these graphs into a local copy of Excel they open just fine with accurate data using an SSS ID. Once I click okay to the error in SharePoint, the graph will load with data since the last time it was refreshed using Excel. I can also add tasks to TFS from the SharePoint portal without issue and create new projects from TFS for Sharepoint without error. I have a Secure Store Service ID setupwith members from an AD group and individual users added directly as a test. I do not see a place in TFS 2010 to enter the Enterprise ID on the TFS server. I re-ran the installer for TFS to see if some SharePoint components were missing, but did not find anything. I am using Team Foundation Server - Standard Edition, version: 10.0.40219.339 (SP1 KB2580221). I have enetered the Enterprise ID on the SP 2010 servers. I have confirmed my TFS reporting user has permissions to the SP database, is an admin user listed on the Secure Store, and has admin rights to the TFS analysis services database. The Claims to Windows Token Service isstartedusing Local System Account on my SP App server running Secure Store and Excel Services. Ialso adjusted the timeout settings using the TFS Warehouse Web Interface. I have checked the server Event Logs, and ULS Logs, and TFS logs, and no more information is provided than what is seen in the GUI. As a test, I changed the Enterprise ID in the TFS admin console on one of my SP servers, and When saving, this error appears: SharePoint activation warning: TF205021: A feature could not be activated in the following Web application: sitename. The feature is Tswa. This feature is part of the following solution: TswaWebPartCollection.wsp. Without this feature, project dashboards will not function correctly. Verify that the solution has been deployed to the SharePoint farm, and that the feature has been activated in SharePoint Central Administration. The server returned the following error: TF250035: A feature for SharePoint Products could not be found with the following ID: 60e22958-ba2a-47be-b995-820c756324b6. Verify that the feature is installed on every server in the SharePoint farm for the following Web application: sitename In CA, the TswaWebPartCollection.wsp solution shows as deployed successfully, but I retracted it and re-deployed as a test, but that did not resolve the issue either. The other microsoft.teamfoundation.sharepoint.dashboards.wsp microsoft.teamfoundation.sharepoint.wsp are also present and say deployed successfully. Is TFS/ Sharepoint integration dependent on any other SP features being activated?? Or other SharePoint services being turned on?? I have check a the Web App level and I see Team Foundation Server Dashboad Update Job is Active. Visual Studio Team Foundation Server Web Part is active at the Site Collection Level, and I see that when I'm within a TFS project site The Agile Dashboards are all active (Agile Dashboards, Agile Dashboards with Basic Reporting, and Agile Dashboards with Excel Reporting). I have deactivated all but the Excel reporting on a specific project but the errors persists. Any help is appeciated. I've installed on a single machine: Sql 2008 r2 MOSS2010 TFS 2010 addin/plugin that is needed for TFS with Sharepoint 2010 All is working well except (offcourse) the Burndown dashboard. If i go internally) to get the following error: On top it states Excel Cannot open this workbook because it contains external data that could not be refreshed. You may not have permission to use the data connections, or the data connections may not be responding to the refresh operation. I have Refresh warning enabled turned off, and eventviewer is empty. At 1, 2, 3 and 4 (excel web service) that give the error and stay empty. Following services are running: - SQL service - Analyis service - Report service. Although dikkehaaj answer is correct I had the same problem. I thought there must be a better way than having to go into every excel spreadsheet! And there is! First you need to setup a SSID on your SP 2010 which stores the credentials for your one of your TFS accounts. The TFS account the excel spreadsheet use when you open can be found in the event viewer of the SP 2010 server. Usually you will find a security error. My account following the guidelines for installing SP 2010 was the spfarm account. Once you have set up this SSID you can now use this account for TFS. In the Team Foundation Server Admin Console on the SP 2010 server. Click on the TFS Web app that integrates with SP 2010. Click modify Access. In the Enterprise Application Directory Definition (optional) field enter in the name of the SSID you setup previously. This worked like a treat for me and I now longer receive errors when opening TFS Excel documents and all the graphs display correctly for TFS websites in SP 2010. Oh and besides the user having access to the SP 2010 TFS website, also make sure they have rights to the TFS project otherwise you will still experience the problems mentioned. I've successfully installed the process template for VS2010 Scrum on our TFS 2010. And I installed the dashboard on the server. Now, I want to create a new Site Collection in Sharepoint before we do our next project using Scrum. But when I go to create a whole new Site Collection, the only choices for Template Selection in Team Project Portals tab are the Agile and CMMI Dashboards. There is one more under Custom tab but that is VSTS_MSF_CMMI. Should I be able to create a new Site Collection that identifies Scrum under the Template Selection? If not, should I create the new Site Collection with the TFS2010 Agile Dashboard? Hi there, I have the exact same problem here and I have invested so many hours on this, it is ridiculous. There is no way I can see the dashboards on my setup which, of course, makes all my managers and my colleagues pretty disapointed and angry, after we did take the time to do the full setup and follow up the Scrum process on TFS 2010 by the book! I executed the same commands suggested by YiYun Chen on the server (I did the IISRESET at the end as well). None of these commands gave any errors, and I see the Microsoft.TeamFoundation.SharePoint.Scrum.wsp listed when specifying enumsolutions but thereare no dashboard anywhere! I even tried to create another site collection in sharepoint (I verified in Central Administration that Sharepoint.Scrum feature appears as Active) to take advantage of the SCRUM 1.0 template. In the list of available site templates I do not seeany Scrum listed on it, so I basicallycannotcreate a brand new site with all the webparts ready for it. I even deleted the Sharepoint site that I created first from my tfs site, and recreated it after doing the procedure listed above, but I get the exact same thing: no Scrum dashboards anywhere. This is all so frustrating, and I have spent so many hours trying to make this work, it just does not make any sense since I have a single server where everything is in there (TFS 2010, SQL 2008 with reporting services, etc.).I even installed all the service packs and nothing changes.I used the standard installation (use the provided Sharepoint site, not even a different installation). Is there anything else that I have to check? Any permissions somewhere? I wish the dashboards were a separate app. Plain simple, NO Sharepoint. Just a simpleMVC application in order to reduce all these layers trying to make all this to work. Please let me know what else I could check. Thanks in advance Javier. We are still using VSS for source code management of our Microsoft BI code. We like the recursive searching capability of VSS. We would like to move to a tool which will work well with SS2008 R2 code and permit good source code control, recursive searching, metadata management, automated deployments to production, and audit reporting. Was hoping TFS would provide the platform for Microsoft BI but have been challenged trying this so far. Has anyone successfully used TFS for BI Development Deployment of SSRS, SSIS, SSAS, PPS Dashboards into a SharePoint 2010 platform? Hello Rob, I couldnt find an exact case study at that can show the similar solution deployed. However breaking up the requirement into parts and analysing individually shows that SharePoint 2010 can suite your requirement as below: 1.For SQL Server integration services: SharePoint 2010 integrates with SSRS as can be found at 2.For PPS and Dashboards: PPS has been integrated with SharePoint 2010 and the complete feature list can be found at: This includes dashboards and scorecards. 3.Source Control: We have whitepaper that documents customization management including ways to manage source code, source control system and standards for documenting code. 4.Recursive search Search capability in SharePoint 2010 goes beyond scope of just SharePoint; it's integration with FAST and FAST products for SharePoint. There is a whole lot of information about this in the Enterprise Search section: us/product/capabilities/search/Pages/Search-Server.aspx. 5.Metadata Management We have and that demonstrate SharePoint capabilities in metadata management space. 6.Automated Deployment SharePoint has content deployment feature with option of automating the deployment of content, more details on which can be found at 7.Audit Reporting We have extensive auditing capabilities in SharePoint with many enhancements in 2010 version, more can be found at and many more ECM related links on the web site. There may be need of integration with other products and customizations within SharePoint to achieve exactly what you need; however the capabilities of SharePoint 2010 can give you a good start.Please remember to click 'Mark as Answer' on the post that helps you or click 'Unmark as Answer' if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Nishant Shah Microsoft Online Community Support. We are getting ready to move to VS 2010. Last year, we used TFS but soley for source control and absolutely nothing else due to our small team and time constraints. We want to install TFS 2010 but you can integrate it with sharepoint server. What does doing that gain us from a features standpiont? From googling, I keep seeing the term dashboards and graphsbutis that all it really gives you? This time around, we are willing to explore what TFS can really do for us but we can't figure out what sharepoint server will do for us. Hi Corrinthians, Thanks for the post. The features available within Agile and CMMI process templates differ. This link has details on features available on SharePoint postal while using the Agile 5.0 template: The CMMI features are in here: Appart from the Dashboard and Reports feature, you also get a Document store for each project. The Portal also gives an interface forWorkitem tracking. You could also use the projet portal as basic collaboration portal. Let us know if this helped! Mark the post answered.ArunRama, TFS Installation and Setup team. Seguinte, temos um servidor com TFS 2010, SQL 2008 R2 e Office 2010. Ele aparentemente funciona normal (Estamos comeando a usar agora). S que eu reparei que os grficos do dashboard s aparecem pra mim, pro meu usuario, pros outros usuarios ele d o seguinte erro. An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: TfsOlapReport Procurando na internet, encontrei um artigo encinando a configurar e usar o SSS, mas mesmo assim foi sem sucesso. Alguem tem alguma outra ideia? Obrigado a todos pela ateno!! I have TFS2012 with MSSQL on my single non-domain server. I log in to sharepoint site of the project. Click excel reports, open it on my Excel 2010. I have localhostname on connection string. It looks like Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;User ID=;Initial Catalog=Tfs_Analysis;Data Source=WIN-CC6KB443ERC;Location=WIN-CC6KB443ERC;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error Everytime i need manually change Data Source and Location to my FQDN name and everything works fine. So, where is connection string parameters are saved on my TFS 2012 server? I want to download reports with FQDN name in my connection string. Bitte brauche noch einmal Hilfe Ich habe jetzt alles wieder komplett fertig eingerichtet. Server ist ein Windows 2008 R2, auf dem luft der SQL-Server 2008 R2 und Team Foundation Server 2010 mit Share Point Services 3. In der TFS-Administrator Console ist der Zugriff zwischen TFS und SharePoint eingerichtet. Ich kann die Adresse aufrufen und ich bekommen die Seite fr meine Collections angezeigt. Ich kann die Adresse aufrufen und bekomme die Team Seite angezeigt. In der SharePoint Zentraladministration habe ich die Benutzerrechte gesetzt. Wenn ich jetzt eine neue WebPart Seite erffne mit dem Link auf ein Projekt in der DefaultCollection, werden die Dashboards mit einem roten Kreutz versehen mit der Meldung: Fehler: Ausfhrliche Informationen erhalten Sie, indem Sie den Mauszeiger auf das Element bewegen. Im Header kommt noch einmal die Meldung: TF262600: Die SharePoint-Website wurde mit einer Websitedefinition erstellt, die Daten von Team Foundation Server erfordert. Allerdings ist die Website derzeit keinen Daten fr ein Teamprojekt zugeordnet. Zur Sicherstellung der ordnungsgemen Funktion der Website muss ein Teamprojekt so konfiguriert werden, dass Daten fr das Projekt auf die Website verwiesen werden. Weitere Informationen finden Sie in diesem Thema auf der Microsoft-Website: Gewusst wie: Hinzufgen eines Teamprojektportals. Wenn ich jetzt so vorgehe wie in dem Link beschrieben und die SharePoint Seite im Team Explorer anlegen will erscheint diese Fehlermeldung: TF249004: Der Verweis auf Berichte und Dashboards fr diese Webseite konnte nicht gendert werden. Fehler beim Abrufen von Informationen von der folgenden SharePoint-Webseite: Deaktiviere Ich jetzt den Haken Berichte und Dashboards verweisen auf Daten fr das Teamprojekt. Und versuche es wieder kommt diese Fehlermeldung. TF229003: Von der folgenden SharePoint-Webseite wurde keine Antwort empfangen Ich habe jetzt keine Ahnung mehr wo ich noch irgend welche Rechte vergeben muss. Team Foundation Administrator- Console ist alles korrekt. Ich wre sehr dankbar fr den rettenden Tip. Hallo Martin Nach 7 Stunden Arbeit (Server neu aufgesetzt, SharePoint Installiert, SQL-Server eingerichtet und TFS2010 installiert und ein Projekt hochgeladen) funktioniert es jetzt. Ich habe diesmal alle Dienste so gelassen wie die Install-Routinen es vorgeschlagen haben. Jetzt funktioniert die Verbindung zum Berichtsserver und SharePoint, Und ich kannProjekte auf der Team Seite anlegen und verknpfen. Ich dankeDir nochmal fr die Hilfe und den Link zu dem AdminTool welches mir noch gute Dienste leisten wird. Gru Thomas PS: Empfohlen wird bei SQL und TFS in der Doku TFSSERVICE fr alles zu nehmen. Beim Sharepoint wird allerdings normal installiert. Ja hatte ich auch in etwa so geplant und versucht umzusetzen, aber Sharepoint wollte Partu nicht mit TFS kommunizieren. Jetzt wo ich SharePoint vor dem SQL und vor TFS installiert habe bekomme ich auch eine komplett andere URL zugewiesen und der TFS konfiguriert SharePoint auch komplett anders und selbststndig. Vorher: Jetzt: http://meinServer/DefaultCollection. In order to use the Test Manager, the TFS is a requirement. It is because the Test Manager heavily depends on the TFS Work Item. Installing TFS 2010 is very easy. You can download a trial version, and you can install it on a desktop. You can configure it in a basic configuration. It does not add reporting and sharepoint and uses SQL Express as the database backend. - Please remember to mark the replies as answers if they help. Blog: www.ewaldhofman.nl. Hello friends I have recently inherited the responsibilities of a TFS2010/SharePoint 2010 instances, which unfortunately, has come with an issue I have not yet been able to fully identify. New team projects, with project portals, have been experiencing the errors below when in view of Burndowns. An error occurred while accessing application id tfs from Secure Store Service. The following connections failed to refresh: TfsOlapReport I have checked ULS/SharePoint logs and have come across this transaction below numerous times (along with the USER NAME): Job: CreateUserWorkbook Entering monitored scope (ExecuteWcfServerOperation)ValidateCredentialClaims - Access Denied: Claims stored in the credentials did not match with the group claim for a group app.The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Access is denied.' For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK).GetCredentials failed with the following exception: System.ServiceModel.FaultException`1[Microsoft.Office.SecureStoreService.Server.SecureStoreServiceFault]: Access is denied. (Fault Detail is equal to Microsoft.Office.SecureStoreService.Server.SecureStoreServiceFault).Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=4.6113 In addition the Application Event log is stacking up with: EVENT ID: 7493 The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Access is denied.' For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK). Obviously there is a problem with the configuration of Secure Store Service, and perhaps the role in reporting database(warehouse). I'm hoping someone will guide me through this one- to resolve. If more information is required I will be happy to provide it. Kind Regards Clint. We are using TFS 2012 RC with SCRUM process template. I've seen SharePoint project sites based on the agile template include several dashboards as shown here:I assume these are out-of-the-box dashboards whereas the SCRUM template only provides a single Release dashboard showing a single chart. Am I missing something as to why the SCRUM template does not provide the same dashboards as the agile template? We like the SCRUM methodology best but the associated release dashboard is useless compared to the dashboards provided by the agile template. Is there something I need to do in order to get the same agile-template based charts using the SCRUM template? I have setup TFS Server 2010 on a separate server. And have SharePoint server 2010 on a separate server. I have successfully integrated the two. And on the creation of new project i have a new sharepoint site created. Initially i had the problem that TfsOlapReport error and connection timeout something, i resolved it by adding the Secure Store Service application. With the help of link Setup SSS for VSTS 2010 Dashboards Now the excel Burn Down and other reports show Unable to process the request. Wait a few minutes and try performing this operation again. Help me on this please. Hi Dave, There is no TFS2010 Beta2 VPC image now. But TFS 2010 Beta2 is very convenient to install, you will find installing it on vpc is very easy. You can download the installation guide for TFS2010 Beta2 here Best Regards. Ruiz YiPlease remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi. I'm trying to fix the failed to refresh: TfsOlapReport error on the TFS project portal dashboards in SharePoint 2010. I've followed the instructions hereto make sure the Secure Store Service and the TFS Reports are configured correctly. The only error log I can see is the following stack trace in the SharePoint 2010 server ULS logs when Excel Services attempt to connect to the data source. The Application ID is TFS, which links to an account in SSS DOMAIN TFSReports. You can see that this lookup succeeds. It looks to me like there is some strange error when opening the OLEDBConnection - PF_CHECK_ERROR. (This is paraphrased from another machine without internet access) StoredCredentialProvider.GetCredentials: Credentials added to stored cache for Secure Store Application Id: TFS ConnectionManager.GetConnection: ConnectionKey=[[3344175, TFSReports], [Oledb, Stored, TFS, False], 1033, ] ConnectionManager.GetConnection: Didn't find the connection without the workbook version. Hi Santosh, My understanding is that you want to use SharePoint to share the announcements. Please clarify if I'm wrong. For the requirement, you can use team project portal to achieve this goal. See this page for more information about team project portal. Best regards,We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey. I am following the steps on: This blog Part I but am getting the following error message: The path of the item '/TfsReports/collection/project/Dashboards/Remaining WorkIterationParam=[Iteration].[Parent_ID].[46]' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath) Any help is much appreciated. Update: I should also note that there is no TfsWarehouse.dbo.Iteration table in the TFS 2010 database. Instead I looked at dbo.DimIteration and instead of __ID field, I got the value from IterationSK field. Hello p_shah, Thanks for your post. I did a research on my PC, and I can successfully use the parameters in the URL to have one appropriate iteration selected. Please follow these steps I have tried: 1). Go to the and select the Remaining Work page for the appropriate team project. On my side, the URL is like: 2). Create the SSRS project in the VS2008 to find the value of IterationParam parameter. Create one data source under the Shared Data Sources folder which connected to the Analysis Services. Create a new report, and select the Shared Data Sources you just created above. And on the Design the Query page, click the Query Builder button. On the Query Designer, select the Work Item Cube. You then select the Work Item Dimension, and Work Item.Iteration Hierarchy as Hierarchy, Operator as Equal and Select the appropriate Iteration from the Filter Expression. And then you unselect the Design Code Button, and copy the statement in the WHERE block: On my side is: WHERE ( [Work Item].[Iteration Hierarchy].[Iteration1].[637788227][-270113094] ). And the bold statement above is useful. Use the URL Encoder to encode the bolded statement ([Work Item].[Iteration Hierarchy].[Iteration1].[637788227][-270113094]). On my side is:%5BWork%20Item%5D.%5BIteration%20Hierarchy%5D.%5BIteration1%5D.%26%5B637788227%5D%26%5B-270113094%5D 3). Add the encoded bolded statement to the URL you got in the Step1. I hope it can help you. If you still have anything unclear, welcome back. 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. I've used it a lot for development. It does a great job with things like source code control, resolving conflicts, etc. I also use it with Visual Studio Database Projects, and SQL Server Managment Studio Solutions. It was a little tricky to setup though, I wound up doing a blog post just so I could remember. There's no TFSsupport built into the PPS dashboard designer, but there's nothing that stops you from just checking in the file to TFS as part of the rest of your project. I suspect the rationale was thatthe PPS dasboards are stored in SharePoint, SharePoint should be backed up, so it'll act like the (sort of)source control system itself. It's not great for deployment however, so I tend to stick with either the tools built in or third party tools. I do highy recommend it though for the development aspects. Robert C Cain, MVP MCTS Convert DTS to SSIS| Document SSIS| 30 SSIS Tasks| Real-time SSIS Monitoring| Quick Starts| BI Blitz. Hi, As far as I know, certain kinds of reports that are available in PerformancePoint Server 2007 are not available in PerformancePoint Services. This article contains information about how to prepare to import PerformancePoint Server 2007 dashboard content. This includes which report types are not available in PerformancePoint Services. In addition, to facilitate and simplify the process importing dashboard content from Microsoft Office PerformancePoint Server 2007 into PerformancePoint Services in Microsoft SharePoint Server 2010, an import wizard has been provided. After the IT department has migrated dashboard content from PerformancePoint Server 2007 to PerformancePoint Services, you must perform several tasks to complete the upgrade. For the detailed info, see Thanks, Rock WangRegards, Rock Wang Microsoft Online Community Support. Hi m_bond, As Ewald mentioned, you can refer to upgrade guidence documents available for this: Migrating TFS2008 TFS 2010RTM or you can refer to the installation guild, it's also very useful. For more information about Migrating TFS2010 Beta2to TFS 2010RTM, you can refer to: Hope it helps! If you have any question, please feel free to post here! Best Regards, Cathy Kong. Hello, I'm running into some problems with the TFS dashboard reports within my MOSS 2007 integration. All my dashboard reports (Burndown, Quality, Bugs, etc) are displaying the error: Data Refresh Failed Unable to retrieve external data from the following connections: TfsOlapReport The data sources may be unreachable, may not e responding, or may have denied you access. Verify that data refresh is enabled for the trusted file location and that the workbook data authentication is correctly set. I followed along with the TFS Configuration Settings for Dashboard Compatibility documentation and I also went the extra step and modified the data connections for all excel reports via excel by changing the authentication settings to use SSO and resaved the reports in SharePoint. The only step I had to retract on is the setting of theaccess model to delegation. For some reason when Iset the access model to delegationand reset IIS all my dashboards now have an error of: Excel Web Access Access denied. You do not have permissions to perform this action or access this resource. If I change the access model back to TrustedSubsystm i'm again presented with the Unable to retrieve external data from the following connections error. If I click ok in the dashboard the reports show, but if I do a refresh on the page the error message comes right back. Has anyone else experience this, and if you have how were you able to fix the problem. Any assistance on this would be of great help. Thank you for your time. V/r JShidellv/r JShidell. Hello Barkingdog, Thanks for your post. Do these TFS2008 databases you backed up and restored contain the STS_Content_TFS or WSS_Content database? As the SharePoint content database contains the content for the team project portal, so please make sure you have restored it to the target server. You can also refer to this link for a better understanding of TFS upgrade: 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. To get the additional features of dashboard in TFS 2010, we installed SharePoint Server 2007 with Service Pack 2 on the apptier of our TFS setup. After configuring it, we are not able to see the additional dashboards. What needs to be done to enable additional dashboard. Site Action-Site Setting-Site Features-Agile Dashboards with Excel Reporting-Activate does not give any result and do not throw any error. Thanks Upfront. PS-I have performed every step given in TFS installation guide and verified it again. I am not able to find any problem. I can see only Task Burndown, Burn Rate no other item Dashboard. Progress, Bugs, Build, Quality and Test dashboard are not available. Hello, I have created site using TFS Template, however on dashboard, I am unable to view the report as its throwing following error while query and refresh the data: External Data Refresh Failed The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh: TfsOlapReport Notes: Claim service is running in windows and sharepoint as well.Also Excel Calculation service is started. Can anyone please help me to resolve this issue? Thanks and Regards, Dipti Chhatrapati. We have TFS 2010 and using WSS 3.0 (which comes with TFS 2010) for Sharepoint integration on the same box. I have successfully configured 21 Team Projects to use SharePoint Project Portal but for some reason, I cannot do the same for this 1 Team Project where the SharePoint Site shows TF262600 error. I verified that the problem does not lie in the Sharepoint site because I can configure a different Team Project's Project Portal to point it and then the SharePoint site works fine. I even created a new Team Project and configured it to a different SharePoint Site successfully and then I tried configuring the problematic Team Project to use this same SharePoint Site unsuccessfully. So this narrows down the problem to the Team Project. I even tried unchecking the checkbox for Reports and dashboards refer to data for this team project, push OK to Project Portal Settings dialog, then re-open the dialog and check Reports and dashboards refer to data for this team project but that didn't work. I even tried repairing the SharePoint Web Applications without any errors via TFS Admin Console. Has anyone had this type of problem before? Any help would be appreciated. Thanks in advanced. Hi Wayne639, Thanks for your post. Im glad to hear that you got it to work and thank you for sharing your experience here. It will be very beneficial for other community members having the similar questions. All your participation and support are very important to build such harmonious/ pleasant / learning environment for MSDN community. Have a nice day!John Qiao [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. Moved to TFS forum - Team Foundation Server - Setup and AdministrationBalmukund Lakhani| Please mark solved if Ive answered your question, vote for it as helpful to help other users find a solution quicker -------------------------------------------------------------------------------- This posting is provided AS IS with no warranties, and confers no rights. -------------------------------------------------------------------------------- My Blog| Team Blog| @Twitter Author: SQL Server 2012 AlwaysOn - Paperback, Kindle. Ihave migrated TFS 2010 over to new servers. In the process I'm importing TFS project portals into separate content databases. One content database for each of our TFS collections. In each content database I created a collection and this is what I assign to the TFS Collection in the TFS console. Im exporting sites from the old server and importing to the new using stsadm o export and import. After the import the site looks fine except for the TF25008 error where the Work Remaining report is located. My next step was to assign the portal to the TFS project but even after doing so I still get the TF25008 error. TF250008: This SharePoint site is not currently associated with a team project in Team Foundation Server. To ensure that this site functions correctly, you must configure a team project to refer data for that project to this site. For more information, see this topic on the Microsoft Web site: How to: Add a Team Project Portal. You can use the following querystring argument to specify a specific project: tf:ProjectId. I did check Reports and dashboards refer to data for this team project but it doesnt seem to have an effect. I also used Team Foundation Server Console to repair the connections. Is there something else I can try? I am running sharepoint 2010 with TFS 2010. I went through and configured my dashboards following an online walkthrough I chose to setup a secure store service account as well. I followed the TFS installation guide meticulously. When I loadup the burndown page (or any page with dashboards for that matter) I get error. The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh: TfsOlapReport I tried both service accounts that I created for TFS/SharePoint/SQL that use the recommendations of Microsoft installation guidelines for TFS. No go.BrianMackey.NET. Hello Brian, Please follow the instructions at Please let me know if it still doesn't work for you. Thanks.Looking for TFS Hot Issues? Follow us at Twitter. Hongye Sun [MSFT] MSDN Subscriber Support in Forum If you have any feedback on our support, please contact msdnmg @ microsoft.com Please remember to mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us. I am trying to find a comparsion of what TFS dashboards we would get when integrating with SP 2010 Standard vs SP 2010 Enterprise. I have found the following but it does not tell which specific dashboards are inlcuded in each version. Does anyoneknow where i might be able to find this information? Team Foundation Server2010 contains dashboards that use SharePoint Products features to display team data, which are defined for MSF process templates. The dashboards that are available to you depend on the version of SharePoint Products that you install. If you install the Enterprise editions of either Microsoft Office SharePointServer 2007 or SharePointServer2010, you can use five dashboards that are configured with reports that are based on Microsoft Excel. If you install Microsoft Office SharePointServer 2007 Standard, SharePointServer2010 Standard or Windows SharePoint Services 3.0, you can use two dashboards that are configured with reports that are based on SQL Server Reporting Services. Dean MCTS-SQL 2005 Business Intelligence, SharePoint 2010, Configuration. Hi Cross, Thanks for your reply. No, we still have the xlsx files when we configured with SharePoint Standard version. I think you can get the detailed information from here: For Agile process template: For CMMI process template: John Qiao [MSFT] MSDN Community Support| Feedback to us. We have Team Foundation Server 2010 installed and connected to SharePoint Server 2007 and SQL Server 2008 R2. Reporting Services is configured on the TFS App Tier. I finally got SSO configured to I'm no longer getting those errors. But when we point to the TFS Dashboards I get an error message indicating the refresh failed. When I look at the logs, all it tells me is that the refresh failed.nothing more. Here's the interesting thing. The reports that are on the dashboard work fine if you view them in Visual Studio or if you open the spreadsheet. Any ideas on what I should be looking for to correct this issue? Hello friends I have recently inherited the responsibilities of a TFS2010/SharePoint 2010 instances, which unfortunately, has come with an issue I have not yet been able to fully identify. New team projects, with project portals, have been experiencing the errors below when in view of Burndowns. An error occurred while accessing application id tfs from Secure Store Service. The following connections failed to refresh: TfsOlapReport I have checked ULS/SharePoint logs and have come across this transaction below numerous times (along with the USER NAME): Job: CreateUserWorkbook Entering monitored scope (ExecuteWcfServerOperation)ValidateCredentialClaims - Access Denied: Claims stored in the credentials did not match with the group claim for a group app.The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Access is denied.' For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK).GetCredentials failed with the following exception: System.ServiceModel.FaultException`1[Microsoft.Office.SecureStoreService.Server.SecureStoreServiceFault]: Access is denied. (Fault Detail is equal to Microsoft.Office.SecureStoreService.Server.SecureStoreServiceFault).Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=4.6113 In addition the Application Event log is stacking up with: EVENT ID: 7493 The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Access is denied.' For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK). Obviously there is a problem with the configuration of Secure Store Service, and perhaps the role in reporting database(warehouse). I'm hoping someone will guide me through this one- to resolve. If more information is required I will be happy to provide it. Kind Regards Clint. Hi Ravi please read page 21 of the above white paper - there you found the answer: Additionally, if the contractor is using the client’s Team Foundation Server then the client must supply a Team Foundation Server CAL for the contractor’s use. This could be a CAL purchased separately or a CAL that is included with the MSDN subscription that the client assigns to the contractor temporarily. Team Foundation Server CALs are only valid for accessing a Team Foundation Server acquired by the same organization Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful. Hi Ewald thanks for your help, but i get this Error Message with the Upgrade Assistent: Exception Message: TF250023: A SharePoint site cannot be created under the following location: Either the path is not valid, or Team Foundation Server does not support the creation of a site in this path. I did the following. 1) Install Sharepoint with this hints / URL 2) restore Database from old 2008 TFS 3) Start TFS-Upgrade Assistent (and i get this Error-Message) Possibly an idea? Hi, Thanks for your feedback. If you want to use TFS 2013 build service after upgrading TFS to TFS 2013, you need to installa new build service. As I mentioned above, You can connect a TFS 2010 build server to your on-premises -tier server, but you cannot run both the TFS 2010 and TFS 2013 build service on the same computer. In conclusion, if you want to have TFS 2013 build service, please install a new one, or uninstall TFS 2010 build service and install TFS 2013 build service. If you want to use your original TFS 2010 build service to TFS 2013, you need to configure build service in your TFS 2013 Administration Console. The build data is stored in your DB, if your original project can't build in TFS 2013 build service, please try to rebuild it and create a new build definition.We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place. Click HERE to participate the survey. Hi All, My case: 1. Gota new machine (Windows 2008 R2 for TFS 2010 upgrade, i.e. Our newApp server): Installed TFS 2010 on it (with upgrade mode). Got TFS Database restored in a new SQL 2008 R2 cluster (from SQL 2005). Installation/Upgrade/WSS3.0SP2 etc things all looks good. Hello world standalone application is successful (as I installed (temporarily) TFS Build service on App server as well). Now, While opening Team Explorer I'm seeing that things looks good but the following: - An Existing Project name called: Giga. In the current live environment, sharepoint site link for this project is: it works fine. But, after the upgrade, this link on the upgraded machine is: this link doesn't exist. Getting: the following error: The Webpage cannot be found. -On the new upgraded machine (App server), when i visit: - This page (with both links)comes up fine. -I created a new project: Giga_scm_tools in TFS 2010upgradedmachine. Sharepoint link for this newly created project (on upgraded machine) is: Issue 1: 1.Why the sharepoint site link for an exisitng project giga (which/whose database got migrated from TFS 2008/SQL 2005 ---to--- TFS 2010/SQL 2008 is still the same: (I mean, I know the server in the above path changed,BUT why DefaultCollection which is showing up in the sharepoint site path for a newly created project is NOT coming/showing up for an existing/old project). Do I need to make any changes to tell sharepoint site central administration page/settings that insert DefaultCollection in the sharepoint site path for all the projects which got upgraded from TFS2008/SQL 2005 ---to--- TFS2010/SQL2008?? Reports Server site's main page pathon existing/live TFS server is: its working fine. The same on the new machine (TFS2010) is same and running fine too. BUT, in Team Explorer, under project giga, I'm seeing some new reports names which are different than the reports that show up in Team Explorer (if I use tfs.current.server as my TFS App server). In current tfs server, I used Scrum v2.2.x.x for giga project creation. Does this mean that I need to install Scrum on the new tfs server as well? To get or see the same reports names in Team explorer (whose TFS app server is tfs.new.server)???? Why the reports didn't get upgraded/carried to this project when TFS got upgraded to TFS 2010 / SQL 2008 (from TFS 2008/SQL 2005). Kindly advise. Thanks Arun Sangal. Per my finding, I had to disable them (as a last resort) as the data behind those web parts (reports/dashboards etc), uses settings/queries which are not compatible with TFS 2010. To solve it, you have to create a new project (which will get you a new projejct's sharepoint site) or just disable the web parts and those items can be seen at report site directly or change the link behind the web part. Post by Cathy Kong (2nd), worked in one of my case.Arun Sangal Software Configuration Management Denver USA. We performed an upgrade from TFS 2008 to 2010 using the Migration Upgrade Path. One of our Team Projects uses the CMMI template and now that it has been migrated from TFS 2008 to our new hardware running TFS 2010, we do not have the dashboard functionality that is described in this MSDN blog post: This is a known issue that is mentionedhere: We saw the following post as well which provides scripts to solve this kind of problem if your project is using Agile 4.2 process template: Curiously, no scripts seem to be provided to perform this kind ofupgrade for CMMI process templates. We did run scripts to upgrade to the new TFS 2010 CMMI reports which were successful. We do have WSS 3.0 up and running and we do have the project portal working for this Team Project that allows access to reports, etc (earlier version, I presume) but no dashboards. WSS was installed before the migration. Could you please advise what our next steps should be to enable the dashboards on the portal? Hi Tim, Thanks for your feedback! After you migrate your portal to new hardware, have you redirected sharepoint products to use a new content database? For more information, you can refer to In addition, you can refer to the section: Scenario: Upgrading Team Foundation Server in TFS 2010 installation guideand Kong [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. I've installed on a single machine: Sql 2008 r2 MOSS2010 TFS 2010 addin/plugin that is needed for TFS with Sharepoint 2010 All is working well except (offcourse) the Burndown dashboard. If i go internally) to get the following error: On top it states Excel Cannot open this workbook because it contains external data that could not be refreshed. You may not have permission to use the data connections, or the data connections may not be responding to the refresh operation. I have Refresh warning enabled turned off, and eventviewer is empty. At 1, 2, 3 and 4 (excel web service) that give the error and stay empty. Following services are running: - SQL service - Analyis service - Report service. Hi Dastani, Thank you for your post. You’ll find step-by-step guidance here that covers the most popular upgrade tasks, including in-place upgrades and upgrades that involve moving to new hardware. For detail information, you can refer to. You can first read through the article, choose the upgrade scenario, then do the the upgrade steps. Related articles for you to refer: Regards,Lily Wu [MSFT] MSDN Community Support| Feedback to us. I'm getting this error for reports that come up (excel) on the main progress.aspx page for a given TFS 2010 sharepoint portal site. To aid in this, here is my setup: Sharepoint 2010: on vsintranet02 Sql 2008 r2: on Vssqlprod01 TFS2010: on Vstfs02 Sharepoint portal site, lives off of vsintranet02 at etc I've installed the dashboard software update on the sharepoint site i believe as well. I've verified the settings used for the excel reports, that they are set as windows authentication. Id rather not use SSS and have to change every report for every new TFS site. I believe the issue is something similar to a double hop authentication issue, thinking maybe a component needs installed on the sql box perhaps, or some other change is needed, one that could be globally set. Any thoughts here? New Sharepoint Portal from TFS - Excel windows show popup box. I want to know how to make this just work, because clicking OK, refreshes the data so the authenication message must be wrong as no user has changed. MSF for Agile Software Development v5.0 was the template used. The help which goes to Learn more about data refresh doesn't help me, i don't want to manaully have to refresh things, i want it to just work! = Can you please explain the significance of the TFsOlapReport reference? In this context TfsReports TfsOlapReportsDS TfsReportsDS tfs2010OlapReportDS tfs2010ReportDS TfsOlapReportDS shows NO dependencies, while tfs2010OlapReportDS shows stacks Similarly tfsReportDS shows no dep. While tfs2010reportDS shows stacks. = So why does the popup reference TfsOlapReport which does seem to be the correct reference? Note: This is from Sharepoint - From Dashboard and you get the same from Excel Reports Many thanks nb: Rollup VS10SP1-KB2643415.exe installed on tfs server side. Thanks to people who contributed, there has been an outcome, after weeks / months. I raised a support ticket with Microsoft, after going through 4 lots of MS people at the other end, the solution was the following: - In Excel Calculation services, set allow external data to trusted data collection and libraries from none (change made, but no goodresult on bad server, but may have helped after the next step.) - On the TFS side, add Port 2383 to the Firewall SQL Inbound Rules with port 1433 and 1434 Then it worked. Now before we say, well thats obvious, note this: - the sandbox tfs server which was talked to by the same sharepoint worked, it thus had the same none setting for allow external data, andhad the same 1433, 1434 inbound exception for SQL i.e. On paper and visibly, it had the same config as the production TFS server (broken excel) So while making the bad server work maybeexplained, why the good worked can't. Anyway, if this helps someone the pain and trouble we went through, then good. A search on 2383 showed these, not sure if i need to open more ports. SQL Server Service Broker port 4022 SSAS Default Instance port 2383 SQL Server Browser Service port 2382 Cheers Greg Roberts Note to MS - For complex things like Sharepoint / TFS, it would be good if there wasa comprehensive and cohesive guide on how to manually test that each part is working, preferably outside the actual program itself (e.g. Try some manual connection to SQL, etc). Although you do well generally in the setups steps, you fall down in the checks of systems front. Normally this needs to be found in web articles, not the setup guide itself. Hi, We have a burndown URL in which excel dashboards loading with the following error The data connection uses windows AUthentcation and user credentials could not be delegated. The Following connection failed to refresh TFSOlapReport.Total 4 SP servers in Farm with TFS installed on the same server. C2WTS service is running on Service Account on all the servers. Below are Excel Service Exception: Co-relation id: ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.2 w3wp.exe (0x23CC) 0x1DC8 SharePoint Foundation Topology e5mb Medium WcfReceiveRequest: LocalAddress: 'Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'MessageId: 'urn:uuid:b2bca6be-f8bf-403a-8e19-1c26635a90e8' ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services 3sl0 Verbose BaseWorkbook.QueryJob: SingleQuery operation Called. Async object id: 81715 ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services cos6 Verbose ExternalSource.GetExternalKeyAndStateAndMarkUsed: Called. Scenario=OpenWorkbook ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services 6k5r Verbose CredentialsProvider.GetCredentials: Getting credentials for external source: TfsOlapReport, with CredentialsMethod Integrated ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services d51i Verbose MossHost.TryGetWindowsIdentity: Current identity is ClaimsIdentity. We need to get a WindowsIdentity. Ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services g196 Verbose CredentialsDelegation.Init: Hash=22356430 UserName=CORAD SVC-SPFARM SID=S-1-5-5378-1159 ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services g197 Medium ExternalSource.GetExternalKeyAndStateAndMarkUsed: Populating the session's credentials for external data. Index=0, Credentials=[22356430, CORAD SVC-SPFARM] ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services cos7 Verbose ExternalSource.GetExternalKeyAndStateAndMarkUsed: Trying to get user roles from the data provider. Connection=TfsOlapReport ce39022c-2ba4-4b48-9fb0-70645aa8ba4f 40:33.3 w3wp.exe (0x23CC) 0x1078 Excel Services Application Excel Calculation Services eq3r Medium ConnectionRequest.ConnectionRequest: New connection request. Hi Mat_one, The navigation links on the left hand side. Is it a typo - the navigation links on the right hand side.? The navigation links may be presented by customized web part. If we create a web part page directly, it may not be shown. The solution to create such page you mentioned is: 1. In SharePoint designer, copy the Dashboards page, and paste it. Modify the copied page, remove the blue option. Another possible way is hiding the blue option by JavaScript or CSS. Thanks, Jinchun ChenJinchun Chen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff AT microsoft.com(Please replace AT with @).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2018
Categories |