Share via

SQL Server Integration

  • Article

In many respects, SQL Server is integral to Team Foundation Server. The Team Foundation data tier is mostly comprised of SQL Server databases. In addition, Team Foundation Server incorporates SQL Reporting Services for report generation and report storage.

Team Foundation Server and SQL Server

Team Foundation Server uses Microsoft SQL Server 2005 functionality in the following ways:

  • Component information and project data are stored in SQL Server databases.

  • Warehouse information and data are summarized and managed by SQL Server Analysis Services.

  • Project reports are generated and stored by SQL Server Reporting Services.

Most Team Foundation administrator SQL-related tasks are automatically handled through Team Foundation Server. The largest exception to this is the backup and restoration of Team Foundation Server, which requires direct interaction with SQL Server backup software.

See Also

Tasks

How to: Set Administrator Permissions for Reporting Services
How to: Set Project Lead Permissions for Reporting Services
How to: Set Contributor Permissions for Reporting Services

Concepts

Team Foundation Server Security Architecture
Scheduling Synchronization with the Data Warehouse
Team Foundation Server Security Concepts

Other Resources

Backing Up and Restoring Team Foundation Server Data
Administration How-to Topics