Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Can new install of SQL Server 2008 coexist with MS SQL Server Desktop Engine 8.00.761 (MSDE)

Avatar of youngslim
youngslim asked on
Microsoft SQL Server 2008
7 Comments1 Solution1953 ViewsLast Modified:
I'm hoping this is relatively straightforward. I'm getting ready to install SQL Server 2008 on a production server. Here's the short Q: Can it co-exist with an already installed vesion of MS SQL Server Desktop Engine 8.00.761 (MSDE) and a seperate instance of SQL Server 2000?

The whole story if you are interested: We are running Blackbaud's accounting server and they quit supporting SQL Server 2000 soon. I've read that you can install SQL Server 2008 side by side with SQL 2000, then using blackbaud's tools, backup your db, dismount your database from the SQL 2000 server,  then remount it to the 2008. That way you can go back to to your old 2000 setup if anything goes wrong. I've tested this on a test server I set up.

But in looking at the production server again, I see that MSDE 8.00.761 is also installed - used by some other small DB program. I know that sqlserver 2005 express can't co-exist with sql server 2008. does anybody know if that is true for this version of MSDE?

thanks


I've read that you can install a new version SQL Server 2008 on the same server with SQL Server 2000. The advantage here is
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
AneeshFlag of Canada imageDatabase Consultant
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers