Failed to open file C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssembliesdevenv.exe.config.tmp
We were trying to install SP3 on SQL server 2008 R2 and got the error like below.
Failed to open file C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp
Error Code: 1603
MSI (s) (D0!88) [02:38:57:769]: Product: SQL Server 2008 R2 SP2 BI Development Studio -- Error 29528. The setup has encountered an unexpected error while Updating Installed Files
++ We searched for the file in this location and it was not there " C:\Program Files (x86) \Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies"
++ according to below KB article it was suggested to copy from the "Program files" location.
++ But customer did not have "Microsoft Visual Studio 9.0" folder under "C:\Program Files"
++ So what we did is we went to different server and checked this file and compared between few servers to see if the content in that file is same or not
++ Content is same , SO we copied from the server which had this file and placed in the server where we had problem, under C:\ProgramFiles (x86)\Microsoft Visual Studio9.0\Common7\IDE\PrivateAssemblies
++ later SP3 completed successfully.
So if you do not have "Microsoft Visual Studio 9.0" under C:\Program Files, Don't worry , just find another server where you have this file "devenv.exe.config.tmp" and place it in the location to fix this issue
Disclaimer :- This is workaround , not a fix or root cause analysis.