Can I install SQL Server 2000 on Windows 2000 Professional, I have tried but message was "this platform is not supported" and only client components will be installed after installing, I was unable to create any database.
It has an evaluation version for SQL Server 2000 and it also shows Microsoft Windows 2000 Professional as one of the supporting platforms. You can download that and try again. Its validity is 120 days.
If installing a database server, you need either SQL Server 2000 Enterprise Edition or SQL Server 2000 Standard Edition. If installing a personal database on your workstation, u need SQL Server 2000 Personal Edition. These installations typically include the database engine, the client database management tools, and the client connectivity components.
Operating System Enterprise Edition Standard Edition Personal Edition Developer Edition Desktop Engine SQL Server CE Enterprise Evaluation Edition
Windows 2000 Pro N/A N/A Supported Supported Supported N/A Supported
If its going to be just a single user database system then you can go for Personal Edition. or if you want to develop solutions using all the features but don't want to use it in a production Environment then you can go for Developer Edition or if you want to just have a evaluation of SQL Server then you can go for the trial (Evaluation) edition or if you just want a server which is free without any client tools then you can go for MSDE (Desktop Edition)
Out of the four that will work in Window 2000 Professional, MSDE is totally free and Evaluation Edition can be used for 120 days without a lisence. and the other two can be used only after getting a lisence.
If you could tell me more about your requirements then i could suggest the correct edition.