Installation order for Visual Studio and SQL Server

alehmann — Fri, 15 Aug 2008 12:18:00 GMT

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.

Andreas Lehmann : SQL Server

Installation order for Visual Studio and SQL Server