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.

 <FuncName='Do_sqlFileSR'>

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. 

https://support.microsoft.com/en-us/kb/2216468

++ 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.