Managing SQL Server Services

  • Article

Team Foundation Server is built on three components of Microsoft SQL Server 2005. Team Foundation Server uses:

  • SQL Server databases to store operational information about individual components and the data warehouse.

  • SQL Server Analysis Services to aggregate and summarize the data in the warehouse.

  • SQL Server Reporting Services to generate and store reports about team projects.

As a Team Foundation administrator, there are no special duties or instructions you must follow to manage SQL Server services for Team Foundation Server. Make sure that the SQL Server services are available and operating correctly according to the online documentation for each component.

For more information about managing SQL Server databases, see Administration How-to Topics.

For more information about managing SQL Server Analysis Services, see Administering Analysis Services.

For more information about managing SQL Server Reporting Services, seeAdministering Reporting Services.

See Also

Tasks

Troubleshooting Team Foundation Reporting

Concepts

Troubleshooting the Data Warehouse
Team Foundation Server Security Concepts

Other Resources

Backing Up and Restoring Team Foundation Server Data
Managing Team Foundation Server