Portal access to data and reports broken

Question

I am in the process of migrating from TFS2008/WSS 3.0 App Tier to TFS2010/SP 2010.

Everything was going smoothly.  I had moved the databases and created new projects as I had to migrate our Scrum for Team System Version 2 projects to Scrum for Team System 3.

All the new projects were connected to new portals. All reports burn down and flowchart graphs were up and running and Recent Builds, Recent Workitems and Workitems lists were populated.

Then something broke this.  The portal pages come up ok but the graphs and reporting lists are no longer populated and display the error "TF250016: No access rights have been granted for the following site" in the graphs and "This site doesn't have a default Team Foundation Server instance. You can explicitly select a Team Foundation Server"

I can't say I didn't break it because:

1. I reattached a renamed copy of the original collection after I finished removing the old projects. I had split the original into 2 collections, one for legacy code history and the new one for the migrated projects. I reattached the collection after removing all duplicates from the new collection.
2. I changed and reregistered the server id as recommended because the TFS008 server is still running and this was a backup>>restore type of migration.
3. I changed the SharePoint Farm Service account to the TFS Service account as recommended. It had been running as the Local System account.

Sooo I've gone back over the entire SharePoint to TFS connection.

From the Team foundation Server Administration Console:

Team Project Collections >> SharePoint Site: Current Default Site Location is correct

SharePoint Web Applications: Name and URL are correct.  I have run Repair Connection more than a few times since I have been trying to correct this. Each time completes successfully.

SharePoint Web Applications:  Service Accounts include the TFSReports and TFSService accounts, I have not changed this from when it was working before.

Extensions for SharePoint Products: The Sharepoint Web Application URL, Integration Target URL show Access Grant.  I have removed and re-granted access.

SharePoint Central Administration >> Service Accounts:

Farm Account: TFSService    <- this was changed from the Local System account
Web Application Pool - SharePoint - 80 >> Account : TFSService

I can get to the project portal page from Team Explorer. It just doesn't show any data.  I can edit each of the workitem listing web parts to connect it with a specific project and that works. However the graphs just don't render and display the TF250016 error.

Richard

Answer 1

Richard,

Basically this error happens when SharePoint is NOT linked/connected with TFS. You can reconfigure this for each Team projects where the portal is supposed to be connected.

Here is the blog for more detail

http://my2centsontfs.blogspot.com/2012/04/tfs-portal-error-this-site-doesn-have.html

---

Regards,
Adhi
My TFS Blog
Please remember to mark as answered, if this reply helps

Answer 2

Adhi,

The thing is, this was all connected. In fact, if I open http://server:8080/sites/collection/My_Project, it opens the portal page just fine.

In addition if I examine the portal settings in Team Explorer as you have identified them in your blog the URL is correct.

I've reviewed all the documentation that I can find on adding a SharePoint portal site until my head is swimming.

One recent clue:

If I open the Portal Page and select the link to configure the web part it tells me that "This site does not have a Default Team project".

If I click on the connect link I get a dialog that opens a "Connect - Team Web Access -- Webpage Dialog"

The option "Connect to Default project" is ticked  and below it is a warning "This site doesn't have a default Team Foundation Server instance. You can explicitly select a Team Foundation Server."

The "Connect to a different Project" option contains "@default" for the Team Foundation Server.

I ticked that option and entered http://server:8080/tfs then clicked Connect. When the collections appear I select the collection I want and the project. When I click apply the web part refreshes with the expected data.

I have been searching Team Foundation Administration Console and SharePoint Central Administration trying to figure out where the default site gets set so I don't have to go through this for all of the project portals

Richard

PostScript:

I would add that if I click on the Properties link on the Portal page I get redirected to a page "http://server/tfs/collection/My_Project/_layouts/tfsredirect.aspx?tf%3aType=ReportList" where it says: "TF250016: No access rights have been granted for the following site: http://server/sites/collection/My_Project. You must grant access rights between the SharePoint Web application and Team Foundation Server. You must also associate this site with reports and dashboards for a specific project in Team Foundation Server. For more information, see the Microsoft Web site (http://go.microsoft.com/fwlink/?LinkId=147580). "

I have already tried removing and then re-Granting access using teh Extensions for SharePoint Products tab on the Team Foundation Server Administration Console. That did not help

Answer 3

Richard,

I have updated the blog to include the Collection level setting for configuring the Default SharePoint site. Hope this helps

http://my2centsontfs.blogspot.com/2012/04/tfs-portal-error-this-site-doesn-have.html

---

Regards,
Adhi
My TFS Blog
Please remember to mark as answered, if this reply helps

Answer 4

Adhi,

My hat is off to you!  You are a genius. 

Despite the fact that I was pretty sure that I had already gone through the steps you outlined I went through them once again and voila!  It reconnected.

Many thanks!

Richard

PostScript:

I will mention that in some cases I had to remove the portal connection and then add it back more than once in order for the portal to reconnect to the Reports and Dashboards.  My guess is that this might have been because of some  periodic servicing. Eventually all project portals were re-established with patience.

Answer 5

You are welcome Richard. Thanks for the update

---

Regards,
Adhi
My TFS Blog
Please remember to mark as answered, if this reply helps

Answer 6

It also worked for me. Thanks

---

http://www.codinghorror.com/blog/2007/03/the-works-on-my-machine-certification-program.html