Installation order for Visual Studio and SQL Server

Here is my preferred installation order of Visual Studio 2005/2008 and SQL Server 2005/2008:

·         Fully patched OS (Vista or XP)

·         Visual Studio 2005 (without SQL Express)

·         Service Packs and Patches for Visual Studio 2005

·         SQL Server 2005

·         Service Packs and Patches for SQL 2005

·         Visual Studio 2008

·         Service Packs and Patches for Visual Studio 2008 (without SQL Express)

·         SQL Server 2008

·         Service Packs and Patches for SQL Server 2008

You are free to start with Visual Studio 2008 if you do not need one of the older products. You can install the Express editions too if you really need them.

Another tip to tune the performance of your machine is to set all SQL Server related services to start up manually (not auto) and start them at your needs. That saves CPU at system startup and much memory on runtime.


Posted Aug 15 2008, 02:18 PM by alehmann

Comments

Manjinder wrote re: Installation order for Visual Studio and SQL Server
on 02-05-2010 6:59

I am in the process of upgrading to a vista x64 os & want to know if you had any issues with installing sql server 2005 and sql server 2008? Some people are saying you have to uninstall the sql server 2005 workstation components before installing sql server 2008. Did you have any issues with that?

alehmann wrote re: Installation order for Visual Studio and SQL Server
on 02-05-2010 11:17

@Manjinder:

No, on my machine it works fine to run both SQL-Server versions. But keep in mind that there can only be one default instance of SQL Server, the other one will be a named instance.

Manjinder wrote re: Installation order for Visual Studio and SQL Server
on 02-05-2010 18:24

It worked fine as you stated to install a new Named Instance. Thx! Still going through the updates, can't wait to check out some of the features in 2008.

Cheers

developers.de is a .Net Community Blog powered by daenet GmbH.