Managing SQL Server Services

Visual Studio Team System Team Foundation Server is built on three components of SQL Server. 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, you must perform no special duties or follow special instructions to manage SQL Server services for Team Foundation Server. You must make sure that the SQL Server services are available and operating correctly according to the online documentation for each component.

Important Note:

Even if you are logged on with administrative credentials, you might not be able to access Web sites and tools for SQL Server on a computer that is running Windows Server 2008 or Windows Vista unless you add those sites as Trusted Sites in Internet Explorer or start Internet Explorer as an administrator. To start Internet Explorer as an administrator, click Start, click All Programs, right-click Internet Explorer, and then click Run as administrator. For more information, see the Microsoft Web site.

In This Section

• Understanding SQL Server and SQL Server Reporting Services
  Describes the interactions among SQL Server, Reporting Services, and Team Foundation Server.

• SQL Server Reporting Services Roles
  Describes the three predefined roles suggested for use with Team Foundation Server.

• How to: Redirect Reporting Services to Connect to a Different Data-Tier Server
  Explains how to change the data source connection for Reporting Services, which you must do whenever the data-tier server for Team Foundation is moved, renamed, or failed over.

Reference

For more information about how to manage SQL Server databases, see the following resources on the Microsoft Web site:

• For SQL Server 2005:

  • Administration How-to Topics

  • Administering Analysis Services

  • Administering Reporting Services

• For SQL Server 2008:

  • Administration: How-to Topics (Database Engine)

  • Administration (Analysis Services - Multidimensional Data)

  • Administration (Reporting Services)

Related Sections

Managing Data-Tier Servers for Team Foundation Server

Troubleshooting Team Foundation Reporting

Troubleshooting the Data Warehouse

Team Foundation Server Security Concepts

Backing Up the Team Foundation Server

Managing Team Foundation Server