Proper Install Order For Visual Studio 2010 with SQL Server 2008 and Office 2007?

sql-server-2008 visual-studio-2010 windows-7 installation office-2007

15,786

Solution 1

I think that for the mentioned applications there is no correct and wrong order, but if I would install them, I would install with the following order: Office, SQL Server, Visual Studio.

Solution 2

The most logical order of installation would be:

Office 2007 Enterprise (with Visio 2007)
SQL Server 2008 (with SSIS and SSRS)
Visual Studio 2010 (Ultimate)

And from what you're describing this would take care of your worries as well.

Solution 3

I have done that several times over (finished doing another just yesterday) and i have never found it to make a difference. I do tend to do VS first though, simply because the machine is still clean and unpolluted, there is nothing worse than trying to clean out a failed VS install, especially once you have Office on the machine, they have so many similar registry keys that it is next to impossible to clean out VS without breaking Office in the process.

But i also do it that way simply because the OCD makes me :)

Note that technically, neither of those installs depends or even cares about the other.

15,786

Taptronic

Software development from late 1970s to current: Atari 800 using Atari BASIC and Atari Assembler late 1970s IBM-PC 5150 Microsoft BASICA and Microsoft MASM early 1980s R:Base, D:Base mid 1980s - 1990s Lotus 1-2-3/macros early 1980s - late 1980s COBOL, IMS, CICS, DB/2, VSAM, IBM 3090 Mainframe late 80s - late 90s Microsoft Office development early 1990s - current Microsoft Excel early 1990s - current Microsoft Visual BASIC early 1990s - current SQL Server / DBA work early 1990s - current Access, Visual Foxpro early 1990s - current HTML, CSS, PHP, ASP, VBA etc late 1990s - current Data cleansing, ETL, analytics, import/export, reporting late 70s - current

Updated on April 19, 2022

Comments

Taptronic about 2 years
I want to create a Windows 7 64-bit (Ultimate) virtual machine with:
- Visual Studio 2010 (Ultimate)
- Office 2007 Enterprise (with Visio 2007)
- SQL Server 2008 (with SSIS and SSRS)
but I am not sure if there is a correct order to install those items such that there will not be a loss of "awareness" of one application from another on that list?

For example, I want to make sure Visual Studio knows that Office exists but also that Visual Studio knows that SQL Server exists but if I install SQL Server before Office will that wipe out any data access drivers that are needed by VS 2010 if Office is installed after SQL Server?

There are a lot of components and I never gave it a thought that install order would matter but I have a feeling it does. Ultimately I want to create a VM that I can save and use a base development VM from which to create additional VMs from.
- Valamas over 12 years
  
  With Visual Studio, always remember to perform a custom install and to untick installing Sql Express.
Taptronic about 14 years

Myez, its the OCD that makes me ask the question. ;)
Valamas over 10 years

With Visual Studio. Perform custom install to prevent SQL2008 Express Service from being installed.
Hicsy almost 8 years

SQL 2008 fails without VS installed first
slugster almost 8 years

@Hicsy No it doesn't. I've installed SQL 2008 literally thousands of times. It is a standalone product that itself has no reliance on VS. There can be a bunch of reasons why it fails to install, but VS not being there isn't one of them.