The name of the data-tier server is not set correctly
The information in this article applies to:
Visual Studio 2005 Team Foundation Server
Visual Studio Team System 2008 Team Foundation Server
Application-tier server
Data-tier server
Health check
The Best Practices Analyzer tool for Team Foundation Server checks the value that is assigned to the name of the database instance for Team Foundation. This property, VSTF_DB_SERVER, is defined in the MsiProperty.ini files. MsiProperty.ini files configure Team Foundation Server when you install it and when you perform servicing operations. These operations include repairing or upgrading Team Foundation Server, in addition to installing service packs.
One of the following error messages appears if the VSTF_DB_SERVER property is not configured correctly:
The name of the data tier server is not set correctly
For a dual-server deployment, this error indicates that the value of VSTF_DB_SERVER does not match the connection string value that is defined in the Services Web.config file.
Data-tier server name set in MsiProperty.ini file is incorrect
For a single-server deployment of Visual Studio 2005 Team Foundation Server, this error indicates that the value that is assigned to VSTF_DB_SERVER is not set to [ComputerName].
Note
These errors will not interfere with typical operations of Team Foundation Server. They will interfere only with servicing operations.
To resolve these issues, you must change the value of the VSTF_DB_SERVER property in the msiproperty.ini file.
Required Permissions
To perform these procedures, you must be a member of the Administrators security group on the data-tier or application-tier server for Team Foundation.
To change the server name that is defined in the MsiProperty.ini file
Perform one of the following steps:
For a dual-server deployment of Visual Studio 2005 Team Foundation Server, log on to the data-tier server.
For a dual-server deployment of Visual Studio Team System 2008 Team Foundation Server, log on to the application-tier server.
For a single-server deployment, log on to the server that is running Team Foundation Server.
Open Windows Explorer, and locate the directory that contains the MsiProperty.ini file that you want to correct.
For a dual-server deployment of Visual Studio 2005 Team Foundation Server, the file is located in the following directory by default:
Drive:\Program Files\ Microsoft Visual Studio 2005 Team Foundation Server\Microsoft Visual Studio 2005 Team Foundation Server (databases).
For a single-server deployment of Visual Studio 2005 Team Foundation Server, the file is located in the following directory by default:
Drive:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Microsoft Visual Studio 2005 Team Foundation Server - LOC.
For Visual Studio Team System 2008 Team Foundation Server, the file is located in the following directory by default:
Drive:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Microsoft Visual Studio 2008 Team Foundation Server - LOC
Open the MsiProperty.ini file in Notepad or any other text-based editor.
Note
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.
In the file, change the value of the VSTF_DB_SERVER property.
For a single-server deployment, you must change the value to the following string:
VSTF_DB_SERVER=[ComputerName]
For a dual-server deployment, the value must match the name that is defined in the ConnectionStringData Source attribute of the Services Web.config file. For your convenience, the error provides this value.
Save the file, and close the text-based editor.
See Also
Tasks
The connection to the data-tier server failed
Other Resources
Issues That Relate to the Application Tier for Team Foundation