Forum Moderators: open

Message Too Old, No Replies

SQL Licensing Query

         

driller41

9:34 am on Sep 4, 2008 (gmt 0)

10+ Year Member



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

3:29 pm on Sep 4, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



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

10:54 am on Sep 5, 2008 (gmt 0)

10+ Year Member



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

3:19 pm on Sep 5, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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.