FOR DEVELOPERS - USING SQL SERVER 2000 AND 2005 SIDE BY SIDE

Ok everyone here are the HIGH LEVEL directions for using both versions of SQL SERVER on your development box.

As you all know you can install and use Visual Studio 2003 and 2005 on the same computer and they will play nice.

It can be that easy with SQL SERVER if you follow this basic over view.

What I'm going to describe is for those of you who have installed SQL SERVER 2000 several times in your developer lifetime.

For our purposes lets assume the computer your installing on has NOT had SQL SERVER installed on it yet.

We are going to install both in to their own NAMED INSTANCES called SQL2000 and SQL2005. (original huh?)

We will be installing ALL FEATURES.

For SQL SERVER 2000 you could likely do this with entirely with the default instance and rely only on the SQL SERVER 2005 to be the named instance.

You will install Analysis Server 2000 in it's default location since it does not do named instances.

First you install SQL SERVER 2000 with all patches in a named instance called SQL2000.
Then the Analysis Server 2000 and patches in the default instance.
Followed by the Reporting Services with patches in to the SQL2000 named instance.

Next you install the SQL SERVER 2005 selecting all features into a named instance callled SQL2005.

During the initial stages of the a setup be sure to select any option that say migrate and NOT UPGRADE.

For the reporting server select the option to "configure the report server later"
(READ THIS FIRST: http://msdn2.microsoft.com/en-us/library/ms143520.aspx)

When you are done your directory structure should basically be like this.

Microsoft Analysis Services 2000

C:\Program Files\Microsoft Analysis Services - SQL Server Analysis Server (SSAS) Only installs as default. No Named Instances

Microsoft SQL Server

Default Folders

C:\Program Files\Microsoft SQL Server\80 - Default Binaries and Tools Area

C:\Program Files\Microsoft SQL Server\90 - Default Binaries and Tools Area

SS 2000 Named Instance Folders (called SQL2000)

C:\Program Files\Microsoft SQL Server\MSSQL - SQL Server Reporting Services (SSRS) 2000

C:\Program Files\Microsoft SQL Server\MSSQL$SQL2000 - SS 2000

SS 2005 Named Instance Folders (called SQL2005)

C:\Program Files\Microsoft SQL Server\MSSQL.1 - SQL Server 2005

C:\Program Files\Microsoft SQL Server\MSSQL.2 - SQL Server Analysis Server (SSAS) 2005

C:\Program Files\Microsoft SQL Server\MSSQL.3 - SQL Server Reporting Services (SSRS) 2005

In this configuration I'm runing Two flavors each of Visual Studio, SQL Server, Analysis Server and Reporting Server.

This allows me to have all my older tools for production and development work. I can work in both .NET frameworks, upgrade cubes and migrate all kinds of things.

Life is grand.

So enjoy!

The Ron