Friday, March 23, 2012

MSDE 2000 and SQL2005

I have to install MSDE 2000 with a backup application (CommVault Express
6.1) that does not yet support SQL 2005. I also need to install 2005 for
apps that will utilize this version. Are there any known problems with
running both of these versions of SQL on the same server?
Thanks,
Mark B.
I have installed 2000 & 2005 on the same server before and they both work.
The 2000 install is the default instance and the 2005 is the named instance.
The only issue might be whether your server has enough resources to handle
both. Memory in particular. I don't think that both instaces share the same
memory space so you would have to make sure there is enough for both.
"Mark Bohlsen" wrote:

> I have to install MSDE 2000 with a backup application (CommVault Express
> 6.1) that does not yet support SQL 2005. I also need to install 2005 for
> apps that will utilize this version. Are there any known problems with
> running both of these versions of SQL on the same server?
> Thanks,
> Mark B.
>
>
|||Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
with SQL Server 2005 instances on the same computer. Considering SQL Server
performance, your computer may need much more memory and disk space for the
coexistance.
Please feel free to let us know if you need further assistance. Have a good
day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||What about MSDE 2000 and SQL 2000 on the same server? Almost every website I
read on this topic says something different.
I have a server that currently runs two named instances of MSDE 2000 SP3a.
I want to install SQL2000 (as the default instance) on the server (the server
is light duty, but has 3GB of RAM). I'd imagine I could upgrade the MSDE
databases to SQL 2000 first, but I rather not since the MSDE instances are
working fine.
- Kevin
"Charles Wang[MSFT]" wrote:

> Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
> with SQL Server 2005 instances on the same computer. Considering SQL Server
> performance, your computer may need much more memory and disk space for the
> coexistance.
> Please feel free to let us know if you need further assistance. Have a good
> day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
sql

No comments:

Post a Comment