What does the Team Foundation Server (databases) installation do?

hi

I’m using dual-sever deployment.
After installing SQL Server on the data-tier, you should install TFS (databases). What does this installation do Does it create the necessary tables

I want to install SQL Server and TFS (databases) on server X, and then backup the TFS database and restore it on another server Y which already has SQL Server 2005 installed.

Thanks


Answer this question

What does the Team Foundation Server (databases) installation do?

  • Arunagiri

    As a reminder this is a dual-server deployment and I am asking about the TFS component that needs to be installed on the data-tier after sql server 2005 has been installed.

    Will the installation of TFS (databases) only setup a database for TFS or will it also install additional software, like .NET stuff

    In a dual-server deployment, assuming that the app-tier accesses the SQL database directly, all you need is a corretly configured database, so my conclusion is that the TFS (databases) installation only prepares the database.

     


  • quantumkev

    The reason why I’m asking this question, is that we dont want to install any beta products on our server X. That’s why I dont want to run the TFS (databases) installation.

    Instead, I ran the TFS (databases) on another server, which sets up the sql server correctly. Then I backed up the databases and restored them into X. I also added the SQL user tfsservice.

    As I try to install TFS (services) on the app-tier I get the following error msg during installation when inserting X as the database server name:
    "Setup did not find the Visual Studio 2005 Team Foundation Databases on the specified database server..."
     
    What else needs to be done in X besides restoring the tables and adding "tfsservice" as an sql user

    Anyone form MS who knows exactly what is done during the TFS (databases) installation

    Thanks

  • davidpapirov

    The server X that I restored the databases to has all the prerequisites needed by TFS (databases), e.g. IIS.

    I just need info on how to emulate the installation of TFS (databases). What has changed when installation is complete Tables are created, the tfsservice is added... what more any registry entries
    If the installation merely creates databases and a user, the error Im getting must be due to something else.


    As for the next version, I assume there will be data migration instructions.


  • AlanJensen

    Hi,

    The TFS installation creates the databases and also configures and creates WSS sites. The TFS installation also includes installation of Windows Services.

    So, its not just the database tables.

    Regards,
    Vikram

  • jp2mail

    In beta 3 and beta 3 refresh, the report server runs on the data tier.  Because of that, you would need IIS on the data tier, and thus you would need more than just a few databases.

    For RTM, the report server will run on the app tier (these changes have been made and will be in the next drop).

    SQL Server 2005 installs a .NET framework as part of its normal installation, but it doesn't install VS.

    Buck

  • sd_dolphins

    Hi,

    Yes, what you say appears to be correct. However you would also need to have IIS installed and ASP.NET enabled on the data tier as well.

    Regards,
    Vikram

  • What does the Team Foundation Server (databases) installation do?