Heard back from my MVP buddies. The concern is re uninstall issues. Here
is what MVP Hilary Cotter had to say:

"That is correct. SQL Server 2005 replaces the SQL 2000 connect libraries
with the SNAC. The SNAC includes the SQL 2000 connect libraries (MDAC), but
the SQL 2000 connect libraries do not include the SNAC. If you install SQL
2000 after SQL 2005 it which whack the SNAC.

So order is important.

Refer to http://support.microsoft.com/?id=905618 for a work around.

Here is how I remember it SNAC=Yummy. MDAC=Not Yummy."



--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Hmm. That's news to me. I'll check in the private MVP group and get back.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Will Jackson" <WillJackson (AT) discussions (DOT) microsoft.com> wrote

I was just able to perfom this in our test environment (I didn't realize we
had a cluster set up this way so I could test).

It installed perfectly. Are there things I don't know about that might
happen?

"Tom Moreau" wrote: