Named instance licensing

[CharlesL]

Hello,

I currently am doing all my licensing per proc - here's the question:

If I have a SQL Server with 2 procs, and have a 2-proc license, and I have 3
named instances on the same server, does those 2-proc SQL licenses cover all
the named instances?

[Mohit K. Gupta]

Nope.

SQL Server Per processor licensing states that you must have a license for
each CPU that is accessible to OS. That is if your OS can see 2 CPU, then
you must have 2 CPU for each instance. So in your case you need 2-CPU
licensing x 3; one for each instance. Each instance named or default
requires its separate license and cannot be shared between two or more
instances.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/

"CharlesL" wrote:

> .
>

[Sylvain Lafontaine]

You should state the version of the SQL-Server that you are using (Year +
Edition) as well as the exact date that you have bought it for some versions
because the licensing model has changed many times in the past between
versions/editions; sometimes even inside a version.

In its latest incarnation for SQL-Server 2008, the answer is yes for your
question about the Per-Processor licensing: « A processor license gives you
the right to install any number of copies of SQL Server 2008 in a single
physical or virtual operating system environment, as long as you have
purchased processor licenses for all of the physical processors on that
computer. If you have made a processor inaccessible to all operating system
copies on which the SQL Server software is set up to run, you do not need a
software license for that processor. »;

Reference: http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx#

See also:
http://download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%20SQL%20Licensing%20Overview%20final.docx

Again, this is for SQL-Server 2008 (any edition) and it might not be true
for a previous version/edition of SQL-Server.

--
Sylvain Lafontaine, ing.
MVP - Access
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)

"CharlesL" <char...@pinalcountyaz.gov> wrote in message
news:%23cafHha...@TK2MSFTNGP04.phx.gbl...