Is server downgrade possible?

Hello,
my question is simple, i guess, if anyone can help me solve this problem:
I just installed Windows 2003 SBS Premium R2 but i have a software using SQL Server 2000 and not the one included in this version, 2005 wich is not compatible with. How can i downgrade, where cand i get the older server if the downgrade is possible and what else can i do before i shoot myself? Is there any license issue that will not allow me the downgrade?
Thank You!!!
SBS Premium R2 comes with 2005, but prior releases came with 2000. So, I would try to uninstall 2005 and reinstall 2000 with your install disks for the prior release.

Alternatively, you can install an MSDE instance on the same server and have it host your SQL 2000 database.

As I understand, however, if the install process for R2 upgraded the database itself, then you can't downgrade the database. Rather, you'd have to restore the most recent backup of the 2000 database.
|||Well, i don't have an older SQL 2000 database backup (also don't have a prior SBS 2003 server release) because we never used SQL before, version 2005 is uninstalled already but i don't know where from to download/get the SQL 2000 server as long as "Microsoft's ways" are a big mistery to me... if someone can drop a link for the SQL 2000 server would be great, just any version of the SQL 2000 that will work/install fine on our version of Windows, our software can't use the SQL 2005 included in SBS Premium 2003 R2, that's why i'm in trouble, nobody told me that before buying this license...
Many Thanks
|||

Don't you love it when they omit the details!

Here's a link to MSDE 2000 download...

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

MSDE is the equivalent of SQL Server 2000 Engine, but other features are limited or not supported in the free version. For instance, performance is "throttled" after a certain number of users (about 16?) connect. If you don't know if those features are required by your database / application, I guess it's worth a try anyway. You can manage a SQL 2000 instance with SSMS that comes with SQL 2005.

Good luck...

Del