Cannot build SQL database project on 64-bit installation of TFS 2010 RC Build Controller. Receive an error indicating that the .targets file cannot be found.

Question

Symptom: Cannot build SQL database project on 64-bit installation of TFS 2010 RC Build Controller. Receive an error indicating that the .targets file cannot be found.

 

Solution:

1.       Log onto the host machine which is running your TFS Build service

2.       Create a .reg file containing the following text. Note that you must change the file path information in the ProductDir key to reflect the location on your TFS Build system.

 

Windows Registry Editor Version 5.00

 

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\VisualStudio\10.0\Setup\VS]

"ProductDir"="C:\\Program Files (x86)\\Microsoft Visual Studio 10.0\\"

 

 

3.       Run regedit.exe and import the .reg file

4.       Create the folder

 

%ProgramFiles(x86)%\MSBuild\Microsoft\VisualStudio\v10.0\TeamData

 

5.       Copy the contents of the folder

 

“%ProgramFiles%\MSBuild\Microsoft\VisualStudio\v10.0\TeamData

 

To the folder

 

%ProgramFiles(x86)%\MSBuild\Microsoft\VisualStudio\v10.0\TeamData

 

---

Duke Kamstra - Program Manager - VSTS Database Edition (Data Dude, DBPro)

Answer 1

Finally find the solution to this problem. Thanks for sharing. It seems it is the program installation location of X86 and X64?