Archive for August, 2011

August 25, 2011

Integrate SharePoint 2010 with Team Foundation Server 2010

At the time of configuring the Team Foundation Server sometimes you will come across an error as below :

TF218017: A SharePoint site could not be created for use as the team project portal. The following error occurred: TF249063: The following Web service is not available: http://sourcecontrol/_vti_bin/TeamFoundationIntegrationService.asmx. This Web service is used for the Team Foundation Server Extensions for SharePoint Products. The underlying error is: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.. Verify that the following URL points to a valid SharePoint Web application and that the application is available: http://sourcecontrol. If the URL is correct and the Web application is operating normally, verify that a firewall is not blocking access to the Web application. (type TeamFoundationServerException)

please refer following link to sort out the problem :

Configuring SharePoint Server 2010 for Dashboard Compatibility with TFS 2010

related references :

when you try to browse the burntdown, bugs, etc charts via the team foundation project port you will get the following error with the excel pivot charts.

Error: Unable to retrieve external data

Unable to refresh data for a data connection in the workbook. Try again or contact your system administrator. The following connections failed to refresh: PowerPivot Data

refer following link for more details :

August 25, 2011

Enabling logon as service policy in Windows Server 2008 R2

I was configuring the Team Foundation Server 2010, Microsoft Office SharePoint Server 2010 with SQL Server 2008. I was searching a way to enable the “logon as service” policy to apply TFS Users. Initially it was hard for me to find the way to enable the same and finally figured it out. 🙂

First add the users in your active directory.

after that please follow the steps.

1.    On the Windows Server 2008 domain controller, click Start, type gpmc.msc in the Start Search box, and press Enter to open the Group Policy Management console.

or else you can naviagate to console via administrative tool as below:

2.    In the Group Policy Management console, expand <You Domain>\Domain Controllers, right-click Default Domain Controller Policy, and click Edit.

3.    In the Group Policy Management Editor window, expand Computer Configuration\Windows Settings\Security Settings\Local Policies\User Right Assignment, and then you will see the security setting log on as a service in the right pane.

4.    Double-click the security setting log on as a service, click Add User or Group tab, click Browse, type domain users in the box, click Check Names, and click OK three times to apply the settings.

5.    On the Windows Server 2008 domain controller, run command gpupdate /force to apply the policy.

August 21, 2011

SQL Server 2008 Evaluation Edition Expired

Once you upgrade an existing SQL Server 2008 evaluation edition to any of registered version you will prompt with the following error when you tried to open the Management Studio.

There is a workaround to sort out this issue : its for your to hack registry keys.

Set CommonFiles registry value to 3 in HKLM\SOFTWARE\\Microsoft\Microsoft SQL Server\100\ConfigurationState Registry.

After that you have to reinstall (if the tools are not installed currently) or run edition Upgrade.

This is identified as a known issue where SQL Server Management Studio is not upgraded when you do any of  SQL Server 2008 edition upgrade.


version and edition upgrades.