Rick Sternquist  

SQL Server Business Intelligence Development Studio - Missing DEVENV.EXE

Posted by Rick Sternquist
Wednesday, April 15, 2009

As part of a recent project, I've been working with Microsoft SQL Server 2005's Business Intelligence tools such as SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), and SQL Server Business Intelligence Development Studio.

Just a few days before the project started, I had uninstalled Visual Studio 2005 to make a little room on my harddrive for Visual Studio 2008 SP1 and Silverlight 2. Forgetting that I had uninstalled Visual Studio 2005, I launched SQL Server Business Intelligence Development Studio and received the following message: "devenv.exe is missing". Of course it is! I just uninstalled it! I spent some time googling the problem and here's what worked for me:

  1. Using the SQL Server 2005 installation disc, run the following command: \Tools\Setup\vs_setup.exe. This will reinstall the Visual Studio 2005 IDE.
  2. Run the following command from \Tools directory: start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS.

This combination worked perfectly. My SQL Server 2005 Business Intelligence Development Studio was back up and running.

Labels: ,

2 Comments:

At July 27, 2009 at 1:53 PM , Anonymous Steve J. Laye said...

Great! Thanks for the syntax. Symtex Business Intelligence is delivered through a trusted and familiar environment that solves the business needs of organizations of all sizes. Powered by the flexibility and horsepower of Microsoft SQL Server and delivered through the trusted and familiar 2007 Microsoft Office system, our business intelligence solutions work together to provide value to all users across your organization.

 
At July 17, 2012 at 9:23 AM , Anonymous Anonymous said...

Thanks, worked great. I ran the vs_setup.msi from Tools\setup. Thanks again.

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home