Can I install and run SQL Server locally to develop legally for free?

I'm developing a databas开发者_如何学Ce-driven web application. I'm not always connected to the network so I'd like to setup a development environment on my laptop with a SQL Server database. The database won't be hit hard or anything, I just mainly need it so I can make sure my queries are setup correctly for my web pages.

I'm running Windows 7 locally. The actual database production environment is running SQL Server 2000. The web application is being built on Coldfusion8.

---

Visit SQL Server Downloads and download the Express edition

---

Yes, you can use Microsoft SQL Server 2008 R2 RTM - Express with Management Tools.

If you want to run SQL Server 2000, find an old copy of SQL Server 2000 Developer Edition.

---

You cannot install the full version of MSSQL Server on your computer for development purposes, but you can install MSSQL Server Express for this purpose.

---

Also, the developer edition for about $50 - this has all the features of the enterprise edition and is well worth the money.

Note that it should only be used for development and is not to be used in a production environment.

---

Yep, just pay £46 for a Developer's version (from the Microsoftstore) and you can enjoy all the features included in the enterprise version but you are limited to Dev and Test; you may not create for production servers using the Dev license.

I bought it a couple of days ago and have already created reports using Reporting Services.

NOTE: I've discovered that the report Builder is not compatible with Chrome (works fine with IE).