buy sql server software

[hyy1109]

I have a window XP home edition at home. How to buy sql server software on XP platform? I also need to get IIS as well. Thanks.

 

[SQLBill]

The only version you can get for XP Home is the MSDE (Desktop Engine) version.

http://www.microsoft.com/sql/evaluation/overview/default.asp

Here's the information on how to get MSDE 2000:

http://www.microsoft.com/sql/msde/howtobuy/default.asp

-SQLBill

 

[Krickles]

For IIS you will need to upgrade to XP Pro. Concerning SQL Server, you can purchase the developer edition if you are trying to learn SQL Server or are (obviously) developing. For production it's a different story requiring much more detail.

Krickles | 1.6180

 

[SQLBill]

Krickles,

Developer edition doesn't work on XP Home.

-SQLBill

 

[Krickles]

I goofed by assuming since IIS was needed, first would be the upgrade then the SQL Server install.



Krickles | 1.6180

 

[SQLBill]

hyy1109,

To put Krickles and my comments together....

If you really require IIS:
You need to upgrade to XP Pro (or another OS that will allow IIS)
Then purchase IIS
Then determine what you are going to use SQL Server for and purchase the appropriate version.

As Krickles pointed out...Developer Edition can not be used for a production database. However, it has the same capabilities as Enterprise Edition. So it can be used to design/develop/test a database that you will eventually put on an Enterprise Edition database.

But if you can only use XP Home and upgrade isn't an option, then you will have to use MSDE (Desktop Engine) version and give up IIS.

-SQLBill

 

[hyy1109]

I will get XP professional and sqlserver. Do I need to get IIS seperately or it comes with XP Pro? Where to get IIS if it doesn't come with XP Pro? Thanks.