youngslim
asked on
Can new install of SQL Server 2008 coexist with MS SQL Server Desktop Engine 8.00.761 (MSDE)
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
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
Aneesh
you can install 2008 as another Instance
ASKER
Thanks for the quick response:
Just a sanity check (and not to be insulting): Do you have any documentation or personal experience installing 2008 with this version of MSDE?
I know that sqlserver 2008 works with 2005 but that 2005 express can't co-exist with sql server 2008.
Just a sanity check (and not to be insulting): Do you have any documentation or personal experience installing 2008 with this version of MSDE?
I know that sqlserver 2008 works with 2005 but that 2005 express can't co-exist with sql server 2008.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually, this was the problem I had recently with 2008 and 2005 express:
"The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools."
I understand that is potentially not the same thing.
"The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools."
I understand that is potentially not the same thing.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Guys, I'll probably split the point with more going to the first answer for timeliness. That particular version of MSDE is probably rarer and rarer.
I think I'm going to be able to actually test it this weekend; so I will post a response and close the question Monday night.
Hope all that is Kosher - thanks guys for weighing in.
I think I'm going to be able to actually test it this weekend; so I will post a response and close the question Monday night.
Hope all that is Kosher - thanks guys for weighing in.
ASKER
Sorry for the delay. I'm going to split it between the two of you, giving the first to weigh in slightly bigger portion.