SQLServer Express can be installed on and will run on any machine. Many business applications for Windows (Point of Sale, Scheduling, etc) use it in the background and install it silently during installation. It will only use the resources allowed, so if it is 1GB RAM and 1 CPU and you have more memory and CPU, it will still run; it will just only use the max memory and max CPU it is specified to use.
Dave On Nov 6, 2016, at 4:47 PM, Ken Hohhof <af...@kwisp.com<mailto:af...@kwisp.com>> wrote: Does anybody understand the licensing model for this? I have a Windows based legacy mailserver running on Windows Server 2003 web edition that needs to be updated to a newer version of the OS and to new hardware. So I don’t believe any CALs are required, but even so, the price for SQL Server Standard will be a showstopper at something like $3000 I think? The limitations seem to be 1GB memory, 10GB database size (per database), and 1 physical CPU. I see where the server can have more than 1GB memory, but SQL will be restricted to not using more than 1GB of it. Thankfully, because who would have that little memory in a server. But what about the 1 physical CPU. I am wanting to put this on a used DL380 G7 with dual 6-core CPUs. I can’t find how the single CPU is enforced. Is it a) Will refuse to run on a dual CPU machine b) Similar to the memory limitation, will run but SQL will only use 1 CPU c) Not enforced until Microsoft does an audit and forces me to pay $3000 plus fines Oh, and don’t get me going on licensing for Windows Server 2016, that looks feasless, I assume I need to go with 2012 R2.
