[dba-SQLServer] Installing SQL 2000 on a server that already has SQL 2003

Hi All:

Thanks Francisco and Steve:

Thanks for the information. Actually it is a 2003 Server with MSSQL 2003
installed. It appears that I got a little ahead of myself when I rebuilt the
server not first installing SQL 2000 as I figured clients would be migrating
to MS SQL 2003. This was not the case and one client would like a bit of
development work done on the SQL 2000.

All the objects from the MS SQL 2000 had exported and imported into the MS
SQL 2003 without issues but the DTS package information did not come across.
Fortunately, the information was also exported as SQL but I still can not
get it imported and it will be very time consuming to re-write it all again.

Am I missing something simple and obvious or do the DTS packages have to be
all re-keyed??? So far I have been unable to find any information on the
subject....

On the other hand having a MS SQL 2000 on the system would resolve these
issues but that could cause more problems than it would solve. After a bout
with a Beta SQL Express which required the complete re-install of our
production server caution is the key-word. (NO DOWNTIME!!)

If you have any information on the subject or location where I could look
for information I would be greatly appreciative.

Jim   

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
Tapia
Sent: Thursday, July 13, 2006 1:21 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Installing SQL 2000 on a server that already
has SQL 2003

generally you do not install 2000 on a 2005 server, it just isn't done (in
general).  I've seen servers work well w/ as an example 7.0 and 2000
instances.  but when you upgrade you loose the old EM and are now forced to
use the new EM for 2000 in that situation, for 2005 I beleive it's similar,
the install will remove EM and put in Visual Studio manager (or whatever
it's called).

--
Francisco

On 7/12/06, Jim Lawrence <accessd at shaw.ca> wrote:
>
> Hi All:
>
> Installing MSSQL 2003 on a server already hosting MSSQL 2000 is a simple
> task. The installation routines asks how you wish to name the new SQL 2003
> install so it does not conflict with the present MSSQL.
>
> I have not tried to install MSSQL 2000 on a box already hosting MSSQL 2003
> and was wondering if anyone has done this process and if there are any
> issues to manage.
>
> MTIA
> Jim
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com