Team Foundation Server 2010 Beta 2 + Office SharePoint Server 2007 Single Server Installation – Part 1

So, let’s say your boss only gave you one server for all your Team Foundation Server (TFS) components. Well, that should be enough if you have a small team (fewer than 50 users) and your server is kind of powerful. In this post I would like to show you how to perform a single server installation of TFS 2010 Beta 2. Keep in mind that I am setting up an example, not for production environment here, so don’t pay too much attention to my choices regarding user accounts and passwords.

Downloading the software

You can download the Team Foundation Server (TFS) 2010 Beta 2 ISO from here. Also, get the TFS 2010 Installation Guide from here, you will need it for installing and configuring the prerequisites.

Hardware Requirements

For a single server installation of TFS 2010, you should be fine with these specs:

  • 3.6 GHz CPU (one processor)
  • 230 GB Hard Disk
  • 2 GB RAM

Software Requirements

For a single server installation of TFS 2010 you will need the following software:

  • Windows Server 2003, Windows Server 2003 R2, Windows Server 2008 or Windows Server 2008 R2 with latest Service Pack
  • SQL Server 2008 Standard or Enterprise Edition with latest Service Pack
  • Windows SharePoint Services 3.0 or Office SharePoint Server 2007 with latest Service Pack

For my TFS 2010 installation, which is the one I’ll walkthrough in this post, I will be using the following:

  • Windows Server 2008 with SP2
  • SQL Server 2008 Enterprise Edition with SP1
  • Office SharePoint Server 2007 with SP 2

Required Accounts

You will require the following accounts for your TFS 2010 installation:

  • TFSREPORTS. A domain account with the Allow log on locally permission.
  • A Domain Group for dashboards and reports. All the people that would like to use TFS Dashboards and Reports must be in this domain group.
  • One or more accounts for MOSS 2007 configuration. Specifying the recommended accounts for SharePoint here is out of the scope of this post, so I will just use the domain administrator in all SharePoint related configurations.

Installing and Configuring Prerequisites

You will need to install and configure several prerequisites before starting the main TFS 2010 installation. For my installation I had to:

  • Configure Active Directory on my Windows Server 2008 machine
  • Install Internet Information Services (IIS) 7.0 adding the Web Server Role to my server with:
    • ASP.NET
    • Windows Authentication
    • IIS 6 Management compatibility
  • Install SQL Server 2008 with:
    • Database Engine Services
    • Full-Text Search
    • Analysis Services
    • Reporting Services
    • Client Tools Connectivity
    • Management Tools- Basic
  • Install and Configure Office SharePoint Server 2007 with:
    • A Complete installation
    • NTLM
    • Dashboard Compatibility

This post will not be about installing or configuring Windows Server, IIS or SQL Server (steps varies depending on the specific versions that you use) but you can find detailed instructions on that in the TFS 2010 Installation Guide. Look in the Scenario: Installing Team Foundation Server on a Single-Server –> Checklist: Single-Server Installation section.

Microsoft Office SharePoint Server (MOSS) 2007 configuration, on the other hand, can be a very easy or a very challenging task depending on how much you know on SharePoint. So that’s where this post will continue.

Configuring Microsoft Office SharePoint Server 2007 for TFS 2010

Using Microsoft Office SharePoint Server (MOSS) 2007 over Windows SharePoint Services (WSS) 3.0 gives you additional dashboards that you will find very useful when trying to figure out how well is your team doing on the project.

To install MOSS 2007 just start the installation, choose Complete for Server Type and then click Install Now. After installation finishes, make sure the Run the SharePoint Products and Technologies Configuration Wizard now checkbox is checked and click Close. The configuration wizard will start now.

Running the SharePoint Products and Technologies Configuration Wizard

Perform the following steps once the SharePoint Products and Technologies Configuration wizard starts:

1. On the welcome screen, click Next. If a warning appears, click Yes.

MOSS23

2. On the Connect to a server farm screen, select No, I want to create a new server farm and click Next.

MOSS24

3. On the Configuration Database Settings screen, enter the name of your database server, as well as the credentials (username/password) that SharePoint will use to connect to that database. Leave the default database name and click Next.

MOSS25

4. On the Configure SharePoint Central Administration Web Application screen, enter 17012 for port number (you can use another port, but 17012 is like a standard for TFS SharePoint sites) and choose NTLM for authentication provider. Then click Next.

MOSS26

5. On the summary screen click Next.

MOSS27

6. Wait until configuration finishes and click Finish.

MOSS28

At this point a browser window will open with your new Central Administration Site. Close the browser and proceed to apply the latest SharePoint service packs to your installation. After applying the service packs, proceed to the creation of your the Web Application and Site Collection for TFS.

Creating the Web Application and Site Collection

TFS 2010 requires a web application and a site collection. The following procedure will create a new Web application on port 80, so if you already have a Web application on port 80 you should stop it now in IIS and prevent it from starting automatically when Windows starts.

To create a new web application and site collection in MOSS 2007:

1. Open the SharePoint Central Administration site by going to Start Menu –> Microsoft Office Server –> SharePoint 3.0 Central Administration on your server.

2. Go to the Application Management tab and click on Create or extend Web application on the SharePoint Web Application Management section.

MOSS01

3. Click on Create a new Web application.

MOSS02

4. On the Create New Web Application page specify:

  • Port 80
  • A unique Description that includes the port number
  • NTLM for the authentication provider
  • A Configurable application pool with its credentials

You can leave the rest of the settings with the default values and click OK.

MOSS03

MOSS04

5. On the Application Created page click Create Site Collection.

MOSS05

6. On the Create Site Collection specify:

  • A unique Title
  • The Team Site template (my choice, you may want to try with another one)
  • A primary site collection administrator (used my local admin for this)

Leave the defaults for the rest and click OK.

MOSS06

7. Click OK in the last page, your new site is ready.

MOSS07

Configuring Services for SharePoint Server

TFS 2010 requires some services from SharePoint for dashboards to work correctly.

To configure required services in MOSS 2007:

1. Go to the Operations tab of the Central Administration site and click on Services on server under Topology and Services.

MOSS08

2. Select Single Server or Web Server for small server farms. You will need to start Excel Calculation Services, Office SharePoint Server Search and Windows SharePoint Services Search in the services table if any of them is in the Stopped state. Click on Start next to Excel Calculation Services.

MOSS09

3. Excel Calculation Services status should be Started now. Click on Start next to Office SharePoint Server Search.

4. On the Office SharePoint Server Search Service Settings page check Use this server for indexing content and Use this server for serving search queries. Enter an email address and the farm search service account credentials. Leave the defaults for the rest and click Start.

MOSS10

5. Back in the Services on Server page, click on Start next to Windows SharePoint Services Search.

6. Enter the credentials for a Service Account and a Content Access Account. Leave the defaults for the rest and click Start.

MOSS11

7. All the required services should be now in the Started state as shown below.

MOSS12

Creating a Shared Services Provider

TFS 2010 requires a SharePoint shared services provider and Web applications to support that provider.

To create a SharePoint Shared Services Provider:

1. From the SharePoint Central Administration home page, click Shared Services Administration on the left side.

MOSS13

2. In the Manage this Farm’s Shared Services page, click New SSP.

MOSS14

3. In the New Shared Services Provider page, in the SSP Name section, leave the default value for the SSP Name and click on Create a new Web application.

MOSS15

4. In the Create new Web Application page select Create a new IIS web site and specify:

  • The same SSP Name that you specified in last step plus port number for Description
  • A port (you can just use the default one)
  • NTLM for the Authentication provider
  • A Configurable application pool with its credentials (I just used my local admin for this)

You can leave the rest of the settings with the default values and click OK.

MOSS16

MOSS17

5. Back in the New Shared Services Provider page, in the My Site Location section, click on Create a new Web application.

MOSS17a

6. Follow the same instructions for creating this new Web application as in step 4, just changing the Description (My Site would be a good name for Description) and Port number this time. Then click OK.

MOSS18

7. Back in the New Shared Services Provider page, in the SSP Service Credentials section, specify the credentials for the shared services provider. Leave the rest with default values and click OK.

MOSS20

8. Your new Shared Services Provider is ready. Click OK to return to the Shared Services page.

MOSS22

Configuring Single Sign-On

You will need to enable the Single Sign-On feature of MOSS 2007 for a proper interaction with TFS 2010. You will need to perform this procedure logging on to your server.

To configure Single Sign-On:

1. In the Operations tab of the SharePoint Central Administration site click Service accounts under Security Configuration.

MOSS29

2. On the Service Accounts page select Single Sign-on Service under Windows service and enter credentials for a Configurable account.

MOSS30

3. Go to Windows Services administration by going to Start Menu –> Administrative Tools –> Services. Find the Microsoft Single Sign-on Service, right click and click Properties.

MOSS31

4. On the Properties page, select Automatic in Startup type and then click Start.

5. Back in the Operations tab of the SharePoint Central Administration site click on Manage settings for single sign-on under Security Configuration.

MOSS33

6. On the Manage Single Sign-On page, click Manage server settings.

MOSS34

7. On the Manage Server Settings for Single Sign-On page, specify credentials for the Single Sign-On Administrator Account and for the Enterprise Application Definition Administrator Account. Leave defaults for the rest and then click OK.

MOSS35

8. Back in the Manage Single Sign-On page, click on Manage encryption key.

MOSS36

9. On the Manage Encryption Key page, click Create Encryption Key.

MOSS37

10. On the Create Encryption Key page, click OK.

MOSS38

11. Back in the Manage Single Sign-On page, click on Manage settings for enterprise application definitions.

MOSS39

12. On the Manage Enterprise Application Definitions page, click New Item.

MOSS40

13. On the Create Enterprise Application Definition page, enter TFS for Display name and Application name, enter an email address, select the Group account type and check Windows authentication. Leave defaults for the rest and click OK.

MOSS41

14. Back in the Manage Single Sign-On page, click Manage account information for enterprise application definitions.

MOSS42

15. On the Manage account information for enterprise application definition page, select TFS on the drop down list and enter the name of a domain group that contains all the users that will use TFS dashboards and reports. Then click Set.

MOSS43

16. On the Provide TFS Account Information page, enter the credentials for your TFSREPORTS account and click OK.

MOSS44

17. Back on the Manage account information for enterprise application definition page, click Done.

Trusted File Location for Excel Services

You will need to configure a trusted file location for Excel Services for TFS reports to operate correctly.

To add a trusted file location for Excel Services:

1. On the home page of SharePoint Central Administration, click the name of the Shared Services that you created before.

MOSS45

2. On the Shared Services Administration page, click Trusted file locations under Excel Services Settings.

MOSS46

3. On the Excel Services Trusted File Locations page, click Add Trusted File Location.

MOSS47

4. On the Excel Services Add Trusted File Location page specify:

  • The address of the Web application you created in the Creating the Web Application and Site Collection section of this post
  • Windows SharePoint Services for Location Type
  • Check Children trusted for Trust Children
  • Trusted data connection libraries and embedded for Allow External Data
  • Uncheck Refresh warning enabled
  • 20 for Maximum Concurrent Queries Per Session

Leave the defaults for the rest and click OK.

MOSS48

MOSS49

Set the Access Model

The access model is required for single sign-on for delegation so that TFS and the TFS Web application can interoperate.

To set the access model:

1. Open a command prompt on your server, and go to this directory:

%programfiles%Common FilesMicrosoft SharedWeb Server Extensions12bin

2. Type the following command:

stsadm -o set-ecssecurity -ssp SharedServices1 -accessmodel delegation

You might need to change SharedServices1 for the name of the Shared Services provider you specified before.

3. Type iisreset to restart IIS.

MOSS50

Office SharePoint Server 2007 Configuration is Complete

And this is where we will finish the first part of this post. I really hope Microsoft can simply this a little bit when  TFS 2010 RTM comes, but for now your MOSS 2007 installation should be ready to interoperate with TFS. In the second part I will show you how to perform the actual TFS 2010 installation so that it will work with the SharePoint site we just setup.

Hope this helps,

Julio

43 thoughts on “Team Foundation Server 2010 Beta 2 + Office SharePoint Server 2007 Single Server Installation – Part 1

  1. @Julio: I have some problem when I config Manage Server Settings for Single Sign-On. This is an error : A Single Sign-on error has occurred. Please contact an administrator. Details: Unknown error (0x80040e14). How can I do ?

  2. Uminhhieu, for that error I would recommend you start again from the beginning for SSO. Some other people has had that problem. Try following this steps I found in MSDN Forums:

    1. Make sure the SSO is running under an account that meets the requirements outlined in the Central Administration Help. Start the service.

    2. In the Central Admin SSO area, Configure the settings under Manage Server Settings. Make sure these accounts match the requirements in Central Administration help too.

    3. In the Application definintion section, create an application definition using Windows Authentication. I used a group account. You should be able to leave the rest as is. You’ll choose which group account to use in the next step.

    4. Go to the Manage account information for enterprise application definition settings. Select your new definition and add the Group account you want users to authenticate to. This is the client-end account. The user trying to connect to the db must be in this group.

    5. Click Set. In the Logon Information, enter the Username and Password that SSO will use to connect to the DB. I don’t know if this gives you any feedback if you enter the information wrong. There is little feedback when you get it right, i know that. Enter the info carefully and click OK. That should be all you have to do.

    7. In SharePoint Designer, connect to a SQL datasource using SSO. In the SSO box, enter the SSO Application ID, “Username”, and “Password”.

    You can take a look at that MSDN forums post over here: http://social.msdn.microsoft.com/forums/en-US/sharepointcustomization/thread/433e7216-d483-4118-8924-4da60dc78023

    Hope it helps,

    Julio

  3. I have only one machine Windows Vista sp2.
    I used the solution for Running SharePoint on Windows Vista! at this site: http://www.wictorwilen.se/Post/Running-SharePoint-on-Windows-Vista.aspx
    I followed these steps and I could finish all but once related to SSO.

    Is there a way I can still add DOMAINgroup name or DOMAINUser name?

    If I install Windows Server 2008 Standard sp2 and promote it to a domain controller and select a domain name and join my Vista machine to that domain
    will I be able to still finish SSO steps?

    If I skip configuring SSO will I be able to use TFS 2010 beta 2 with VS Studio Ultimate Beta 2?

    Thanks,
    Rad

  4. julioc,
    thanks for your posts.. I’ve read both in relation to TFS 2010 setup and no matter what I do I keep getting this following error..

    [ System Checks ] TF255435: This computer is a member of an Active Directory domain, but the domain controllers are not accessible. Network problems might be preventing access to the domain. Verify that the network is operational, and then retry the readiness checks. Another options include joining the computer to a workgroup. For more options and information go to http://go.microsoft.com/fwlink/?LinkID=164053&clcid=0x409

    I’m logged into the machine, which is on a domain, as the domain administrator. All other test pass, and I don’t know why.

    Any ideas?

  5. Leo,

    Iti s not required. What TFS 2010 includes is Windows SharePoint Services (WSS) 3.0, not Microsoft Office SharePoint Server (MOSS) 2007. So you can go with WSS 3.0 if you like.

    But, if you do want to use MOSS 2007 you have to do it as a separate installation. Using MOSS adds some interesting capabilities not supported with WSS 3.0.

    Julio

  6. Can TFS 2010 beta 2 be installed with MOSS 2010 Beta using basically this same guide? or do you have to use MOSS 2007? Thanks.

  7. Very informative article Julio. Thanks for taking the time to post your findings.

    I’m trying to install TFS on a single server using WSS and from what I can tell the TFSREPORTS domain account would still be necessary, but, the TFS Dashboards and Reports domain group would not?

    Thanks again!

    Rick

  8. Hello Julio, thanks for the Good insight in Configuring the Website through the WSS website.
    I installed WSS3.0 and TFS 2008 .
    i am at apoint where i want to create user accounts so that where evryone can logon and we can use TFS for Source control.
    I saw your SSO configuration from pages 29-52 on this page.
    Do i have to still use SSO or it has its internal Login screen build.

    Just little confused.Can you please Clarify.Thanks.

  9. Hello Julio, thanks for the Good insight in Configuring the Website through the WSS website.
    I installed WSS3.0 and TFS 2008 .
    i am at apoint where i want to create user accounts so that where evryone can logon and we can use TFS for Source control.
    I saw your SSO configuration from pages 29-52 on this page.
    Do i have to still use SSO or it has its internal Login screen build.

    Just little confused.Can you please Clarify.Thanks.

  10. Hi,

    SSO doesn’t really have anything to do with the user accounts the users will use to connect to TFS, so you would probably not require it in your configuration.

    Julio

  11. Thanks Julio for your Response.
    I am able to get the Sharepoint and the TFS website up and runing on the sever.

    But only problem i have connecting through Clinet VS 2008 machine.I am getting this error.

    “TF32010: Team Foundation encountered an unexpected error while connecting to Team Foundation Server dss0vw701. Wait a few minutes and try again. If the problem persists, contact your Team Foundation Server administrator.”

    my server name : dss0vw701

    Any insight please ?

    Thank you.
    Santosh Pol

  12. Hi Santosh,

    I got 2 questions for you:

    1. Are you trying to connect to a TFS 2010 instance from VS 2008?

    2. Do you got any errors in your server’s Event Viewer you can share with me to better understand the issue?

    Julio

  13. Thanks Julio,

    1> i am using VS2008 to connect to Visual Studio Team System 2008
    2>I looked at the application event Viewer,i do not have any error in that.
    I have setup the TFS website at port 80

    So when i am connecting through VS2008 Team explorere ,i start adding server dss0vw701 and in port i enter 80
    and use default HTTP option. and Say OK

    I get this error

    “TF32010: Team Foundation encountered an unexpected error while connecting to Team Foundation Server dss0vw701. Wait a few minutes and try again. If the problem persists, contact your Team Foundation Server administrator.”

  14. Santosh:

    1. What happens if you try to connect to your TFS while opening Visual Studio in the same TFS server using the same account used for installation?

    2. Which account are you using to connect from your client computer?

  15. Thanks Julio,

    Julio i cannot install Visula studio, where our Server is.
    I am using the Current Logged in account of my windows to connect to the TFS website i created.

    I have made sure that I have access to the TFS website which i am connecting through my local PC.
    The website is http://dss0vw701/default.aspx at port 80
    and it comes up in the browser.

    But for sure i have not used this account for installation.Is there a way i can talk to you.

    Thanks always. Santosh.

  16. Make sure you are using an authorized account to connect to the TFS. Use the security features of TFS to authorize the account you use when logging in to your computer.

  17. Thanks julio,

    Yes i am authorize to connect,
    But i tried accessing the Webservices through Browser
    It gives me this error in Browser:

    The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.

    I am not sure if it is related.

  18. First off I’d like to thank you for putting this together. I can’t stress how much it helped me in getting setup. Just one thing I wanted to post here in case anyone else runs into the same issue. I was unable to find the “Excel Calculation Services” anywhere on my install and didn’t understand why. After extensive searching, I found the reason. You MUST use an Enterprise key to see the “Excel Calculation Services” option. Hope this helps someone else. Thanks again!

  19. Hello Julio,

    We have configured the MOSS 2007 on the app tier of our TFS Setup. We have follwed every step given.

    However, we are not able to see all the Dashboards. We can see only Task burndown and Burn Rate which was present before installation of MOSS2007 as well.

    Could you please help.

    Thanks

  20. Hi

    I am completely new to TFS and am just wondering can you have TFS as a centeralised server as we are wanting serveral areas to use it.

  21. Julio,
    Nice Article. We have to setup our TFS in such a way that we dont want to create any accounts on our domain, either for installation or for user access. We want to use the existing domain accounts as users (we are okay if we have to approve a user from doamin or similar process for user registration). Is there any way this can be achieved, either through ADFS or some other way? This is particularly for overcoming the hurdles we face in getting permissions from IT.

  22. Sudesh,

    I don’t see any issue in the setup you are trying to build. There is actually no need for domain accounts during TFS 2010 installation/configuration. The only moment when domain accounts would be used is when you want to add users to your team projects, and those would be the same accounts you and your team already use to loging to AD.

    Please take a look at the “Accounts Required for Installation of Team Foundation Components” section of the TFS 2010 installation guide so you can be sure about your setup.

    Julio.

  23. You missed one key point to the Sharepoint install. At the very beginning of the install you have two choices Basic and Advanced, you need to choose Advanced. If you choose Basic the install will go through the entire process including configuration without asking you anything including what database server to install on and will create a SQL 2005 Express DB for you.

  24. You need to tell people to USE THE ENTERPRISE KEY OR THEY WON’T SEE THE EXCEL SERVICES!!!! YOU ARE LEAVING OUT ALL SORTS OF CRITICAL INFO AND CAUSING PEOPLE TO RELOAD MOSS OVER AND OVER!!!!

  25. Hi Julio, I have a windows 7 Home edition, I have already installed SQL Server 2010 express eidtion, Visual Studio 2012 RC.
    Is my system configuration is suitable for TFS (without sharepoint) ?. One issue I am facing is I am unable to create a team project (Collections are created successfully), I have added users in admin group in through TFS Admin screen, but i am still getting “TF30172: You do not have permission to create a new team project.” message, Please advise.

    Thanks
    Sathya

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>