Processor model

I have a server with 4 dual core processors.
If I install SQL Server 2005 Express edition on it (which is free), I do not
have to disable other 3 processors because by default express edition will
use at most 1 processor?
But if I use SQL Server 2005 Workgroup (or Standard) edition with one
processor license, I would have to disable other 3 processors at the bios
level to be legal? If I don't disable it, will it use all 4 processors even
though I only bought license for one processor?
Help would be appreciated.JJ,
I could be wrong, but I believe you cannot get around licensing by
restricting the number of processers. I believe if you buy a license for one
processor, then you cannot use it on any server with more than one physical
processor.
-- Bill
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal?
Yes.

> If I don't disable it, will it use all 4 processors even though I only
> bought license for one processor?
SQL Server will use the lesser of either the number of supported or
installed processors. Workgroup supports up to 2 CPUs and Standard up to 4.
However you will be violating the license agreement unless you have
processor licenses for each processor socket available to the OS. See
http://www.microsoft.com/sql/howtobuy/faq.mspx
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>I have a server with 4 dual core processors.
> If I install SQL Server 2005 Express edition on it (which is free), I do
> not have to disable other 3 processors because by default express edition
> will use at most 1 processor?
> But if I use SQL Server 2005 Workgroup (or Standard) edition with one
> processor license, I would have to disable other 3 processors at the bios
> level to be legal? If I don't disable it, will it use all 4 processors
> even though I only bought license for one processor?
> Help would be appreciated.
>|||But if I installed express 2005, then no need to disable processors, right?
Thanks
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
> Yes.
>
> SQL Server will use the lesser of either the number of supported or
> installed processors. Workgroup supports up to 2 CPUs and Standard up to
> 4. However you will be violating the license agreement unless you have
> processor licenses for each processor socket available to the OS. See
> http://www.microsoft.com/sql/howtobuy/faq.mspx
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "JJ" <nospam@.nospam.com> wrote in message
> news:%23FeNFl8SHHA.920@.TK2MSFTNGP05.phx.gbl...
>|||> But if I installed express 2005, then no need to disable processors,
> right?
Correct. SQL Server Express is free so the processing licensing model does
not apply,
Hope this helps.
Dan Guzman
SQL Server MVP
"JJ" <nospam@.nospam.com> wrote in message
news:OZo$JxqTHHA.5060@.TK2MSFTNGP06.phx.gbl...
> But if I installed express 2005, then no need to disable processors,
> right?
> Thanks
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:4E406247-920D-4708-AE2F-3D8F816A0E75@.microsoft.com...
>