SQL Licensing Query

[driller41]

Hi, I cant find this out so I hope someone can advise.

Can I run SQLServer Express Edition - the free version on a webserver - I mean on the internet?

[LifeinAsia]

Yes.

At least, I haven't ever seen anything specifically saying you can NOT use it on a web server. Knowing MS, if they didn't want people to use it that way, they would be pretty vocal about prohibiting it.

[edited by: LifeinAsia at 3:30 pm (utc) on Sep. 4, 2008]

[driller41]

Does it throttle connections like the old MSDE used to do, are there any other reasons not to use it on a 1000 hit per day site on a dedicated box using only 1 CPU?

[mattur]

Here you go driller41:

SQL Server Express 2005 Overview [msdn.microsoft.com] - always worth checking MSDN for this sort of information.

No Throttle
Database size limit: 4GB
1GB memory, 1 CPU

The 1GB memory limit means the max memory SSE will use, not the max amount that can be installed on the server. So should be ok for your requirements.