How to: Correct the Data-tier Name Configuration
If you have problems connecting to the data-tier server, you should verify that the name of the server appears the same way in the Services Web.config file on the application-tier server and in the tbl_database table of the TfsIntegration database. This situation can occur when the TFSAdminUtil RenameDT command did not run successfully.
To resolve this issue, perform the following steps:
Verify that you can connect to the data-tier server and that SQL Server services are running.
Determine the server name stored in the tbl_database table of the TfsIntegration database.
Change the data source name that is defined in the Services Web.config file to match.
If the name of the data-tier server has changed from that stored in the tbl_database table, run TFSAdminUtil RenameDT. For more information, see How to: Rename a Data-Tier Server.
To perform these procedures, you must be a member of the Administrators group for the data-tier server for Team Foundation and a member of the Administrators group for the application-tier server. For more information, see Team Foundation Server Permissions.
To verify the connection to the Team Foundation database and that SQL Server services are running
Log on to the data-tier server on which the Team Foundation database is defined.
If you cannot connect to the server, verify the firewall settings, and then try to connect again.
Open the Start menu, point to All Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
Click SQL Server 2005 Services or SQL Server 2008 Services, and verify that each service appears next to a green arrow, which indicates that the service is running.
To determine the server name that is stored in the tbl_database table of the TfsIntegration database
Log on to the data-tier server.
Open the Start menu, point to All Programs, point to Microsoft SQL Server 2005 or Microsoft SQL Server 2008, and then click SQL Server Management Studio.
In the Connect to Server dialog box, click Database Engine in Server type, type the name of the server to which you want to connect, and then click Connect.
If SQL Server is installed on a cluster, the server name is the name of the cluster and not the computer name.
SQL Server Management Studio opens.
Click New Query.
In the query pane, specify the following query, and click Execute:
SELECT dbname, servername FROM tbl_database
In the results pane, note the server name that appears for the TfsIntegration database.
To change the data source name defined in the Services Web.config file
Log on to the application-tier server.
Open Windows Explorer, and browse to the Services directory.
By default, the directory is located at Drive:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Web Services\Services.
Open the Web.config file in Notepad or any other text-based editor.
Even if you are logged on with administrative credentials, you must open Notepad as an administrator to perform this function on a server that is running Windows Server 2008. To open Notepad as an administrator, click Start, right-click Command Prompt, and click Run as administrator. For more information, see the Microsoft Web site.
Under the appSettings node, locate the ConnectionString key.
Change the value that is assigned to the Data Source to match the server name that is defined in the tbl_database table of the TfsIntegration database.
Save the file, and close the editor.