Click here to Skip to main content
15,867,568 members
Articles / Programming Languages / SQL

Fixed ~ Error Installing SQL 2008 Business Intelligence Studio and Related Features

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
27 Jul 2011CPOL 13.4K  
Fixed ~ Error Installing SQL 2008 Business Intelligence Studio and Related Features

If you try to install/add feature SQL 2008 Business Intelligence Studio to a machine with VS2008 having installed to a different location than the default, you will most probably get the following error:

img_screen_01

In order to install BI Studio 2008 properly, please do the following:

Find the folder which contains 'devenv.exe' (I have installed Visual Studio in 'D:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE'):

Copy and paste the 'devenv.exe.config' file to the following location:

  • 64-BitC:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE
  • 32-BitC:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE

And now you proceed with the installation without any issue.

After installation, copy everything from 'C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE' (where you copied the 'devenv.exe.config') and paste it to the directory where you have VS2008 (In my machine, it's 'D:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE'.)

And if you run Visual Studio 2008, you can see that the Business Intelligence Projects are now available.

img_screen_02_a

Sometimes, you will be prompted to locate the 'devenv.exe' when opening the Business Intelligence Development Studio. Please adjust the shortcut or you can use the 'Visual Studio 2008' IDE.

img_screen_03

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Technical Lead Air Liquide Industrial Services (Singapore)
Singapore Singapore
My passion lies in building business intelligence and data-based solutions, writing about things I work with and talking about it. New technologies relevant to my line of work interest me and I am often seen playing with early releases of such technologies.

My current role involves architecting and building a variety of data solutions, providing database maintenance and administration support, building the organization’s data practice, and training and mentoring peers.

My aspiration over the next several years is to achieve higher competency and recognition in the field of Data Analytics and move into a career of data science.


Specialities: SQL Server, T-SQL Development, SQL Server Administration, SSRS, SSIS, C#, ASP.Net, Crystal Reports

Comments and Discussions

 
-- There are no messages in this forum --