Comments (3)

  1. Juan Zamudio says:

    Hi, one question, in the installation guide in the section “Data-Tier Prerequisites” mentions this:

    “On the data-tier server, add the account for installing Team Foundation Server (for example, TFSSETUP) to the local Administrators group.”

    Is that really necessary? My  DBA is having issues with that point (my Data tier is going to be a cluster).

    Another thing the guide mentions in the section “Data Tier Prerequisites for Cluster Deployment” is this:

    “Use the Team Foundation Server service account (for example, DomainTFSSERVICE) as the SQL service account.”

    Again, is that really necessary for a cluster?

    Thanks and good luck with the blog, i was searching for this information for a very long time.

    Juan Zamudio

     

    Hi Juan,

    Thanks for the post.

    The TFSSetup account needs SA role on the SQL databases to be able to create the TFS databases and the required roles/permissions for the TFSservice account. Also the TFSSetup account will be responsible for the TFS jobs be created on the Data tier. So it is recommended that the TFSsetup account be a built-in administrator on the SQL server, by default built-in administrators are granted with SA rights in SQL.  If keeping TFSSetup account as an Admin is an issue, you could remove the local admin privileges after the TFS installation is done. Further, When you do any kind of servicing to TFS (ie,.. Repair the installation, SP installation or Hotfix installation) the TFSSetup account should be added to the admin group on the server.

    With respect to your question on TFSService account, SQL cluster installation requires a domain account to run the clustered services, built-in system account is not an option, Refer: http://msdn.microsoft.com/en-us/library/ms143763(SQL.90).aspx.

    Thanks,

    Arunrama

     

  2. Jim says:

    Any chance of the same info for TFS2010?

     

    Hello Jim,

    Thanks for the post. Will get the info posted in few days.

    Thanks,

    Arunrama.

    Edit (08/28/2010)

    HI Jim,

    Here are the two blog links that can help you understand the permission requirements:

    http://blogs.msdn.com/b/bharry/archive/2010/08/20/database-permissions-required-to-configure-tfs.aspx

    http://blogs.msdn.com/b/tfssetup/archive/2010/08/13/minimum-permissions-required-for-the-tfs-setup-account-on-the-sql-server-during-tfs-upgrade.aspx

  3. Michael_T says:

    Hi Arunrama,

    I'm asked by DBAs why TFSService needs db_owner access to its content database in TFS 2010. I'd really appreciate if you could provide information on this.

    Thanks,

    Michael.