How many Enterprise Licenses to Buy?

We are building up a clustered server configuration with two nodes. Each
node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
to buy two Enterprise licenses (one for each 4-processor server) or 8
licenses (one for each processor on each server)? I am getting conflicting
information on this. Thanks for any info.
How many instances are you going to run in the cluster? You license per active instances (unless you
will run several instances in the same node, i.e., the other node doesn't do any SQL Server
processing at all). And, if you license per processor, you need to multiply with the number of
processor sockets you use in the machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting conflicting
> information on this. Thanks for any info.
|||It depends.
First, check with your local Microsoft office. Make sure you have a person
knowledgable about SQL licensing in a clustered environment.
Here is the base page with links to the licensing information:
http://www.microsoft.com/sql/howtobuy/default.mspx#EEAA
Here is the FAQ page
http://www.microsoft.com/sql/howtobuy/faq.mspx
The relevant question and answer are here:
Q. How does licensing work for computers that run SQL Server 2005 in
failover scenarios?
A. Failover support, where servers are clustered together and set to
pick up processing duties if one computer should fail, is now available in
Workgroup, Standard, and Enterprise editions of SQL Server 2005. Under each
of these editions, keeping a passive server for failover purposes does not
require a license as long as the passive server has the same or fewer
processors than the active server (under the per processor scenario). For
details on which failover methods are available under each edition, visit
the SQL Server 2005 Features Comparison page.
Finally, SQL 2005 supports failover clustering on Standard Edition with up
to four processors on each host. If you do not need any other Enterprise
Edition features, you will save a considerable amount of money on licensing
by using Standare Edition. Oh, and look at the DL/ML 585 series wutl
Dual-Core processors. IMHO, the best bang for the bucks.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we
> need
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting
> conflicting
> information on this. Thanks for any info.
|||We will not be doing any processing on the non-active server. From the MS
web link posted by Tibor (thank you), it looks like we need only the Server
Plus Device CALs model. There will be no web access and I know exactly how
many users will get to it at all times. I had trouble finding where it says
we don't need a license for the passive failover option. Could you send me a
link? That sounds like what we need. Do I then need CALs for each user?
|||Search for "failover" in the FAQ page.
As for the licensing, since you don't have any internet access to the
server, choose whichever licensing model (per-processor or CAL) is cheaper.
That is why Microsoft has multiple licensing models.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:BB370D4D-88FB-4ACC-B8E1-A82932038125@.microsoft.com...
> We will not be doing any processing on the non-active server. From the MS
> web link posted by Tibor (thank you), it looks like we need only the
> Server
> Plus Device CALs model. There will be no web access and I know exactly
> how
> many users will get to it at all times. I had trouble finding where it
> says
> we don't need a license for the passive failover option. Could you send
> me a
> link? That sounds like what we need. Do I then need CALs for each user?
>
|||Thank you. BTW, I did find the FAQ site on licensing. Thanks very much for
your help. I don't think our software supplier is asking us the right
questions, as they went straight for the per-processor option even though the
device CALs option is much better suited for our situation.
|||If I already have device CALS for existing SQL servers, do I need to buy new
ones for a new SQL server I am installing or do I just buy the server
license? It looks like the device CAL is good for connections to any number
of different servers, so long as each server has a license.
When doing that install on a new server, do I have to tell it how many CALs
I bought or is it basically the honor system?
I have seen some folks wondering how to enter the number of CALs. If I add
more CALs, do I need to tell my instance of SQL server how many I added?
|||A Device CAL can connect to any number of SQL servers.
There is no technical enforcement measure for CAL enforcement built into SQL
Server. It is a good idea to set up a licensing server and funnel CAL
configuration through that so you have a single point of maintenance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:DF76E12F-B60D-48B2-BFB6-5A4364B46F95@.microsoft.com...
> If I already have device CALS for existing SQL servers, do I need to buy
> new
> ones for a new SQL server I am installing or do I just buy the server
> license? It looks like the device CAL is good for connections to any
> number
> of different servers, so long as each server has a license.
> When doing that install on a new server, do I have to tell it how many
> CALs
> I bought or is it basically the honor system?
> I have seen some folks wondering how to enter the number of CALs. If I
> add
> more CALs, do I need to tell my instance of SQL server how many I added?

How many Enterprise Licenses to Buy?

We are building up a clustered server configuration with two nodes. Each
node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
to buy two Enterprise licenses (one for each 4-processor server) or 8
licenses (one for each processor on each server)? I am getting conflicting
information on this. Thanks for any info.How many instances are you going to run in the cluster? You license per active instances (unless you
will run several instances in the same node, i.e., the other node doesn't do any SQL Server
processing at all). And, if you license per processor, you need to multiply with the number of
processor sockets you use in the machine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting conflicting
> information on this. Thanks for any info.|||It depends.
First, check with your local Microsoft office. Make sure you have a person
knowledgable about SQL licensing in a clustered environment.
Here is the base page with links to the licensing information:
http://www.microsoft.com/sql/howtobuy/default.mspx#EEAA
Here is the FAQ page
http://www.microsoft.com/sql/howtobuy/faq.mspx
The relevant question and answer are here:
Q. How does licensing work for computers that run SQL Server 2005 in
failover scenarios?
A. Failover support, where servers are clustered together and set to
pick up processing duties if one computer should fail, is now available in
Workgroup, Standard, and Enterprise editions of SQL Server 2005. Under each
of these editions, keeping a passive server for failover purposes does not
require a license as long as the passive server has the same or fewer
processors than the active server (under the per processor scenario). For
details on which failover methods are available under each edition, visit
the SQL Server 2005 Features Comparison page.
Finally, SQL 2005 supports failover clustering on Standard Edition with up
to four processors on each host. If you do not need any other Enterprise
Edition features, you will save a considerable amount of money on licensing
by using Standare Edition. Oh, and look at the DL/ML 585 series wutl
Dual-Core processors. IMHO, the best bang for the bucks.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we
> need
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting
> conflicting
> information on this. Thanks for any info.|||We will not be doing any processing on the non-active server. From the MS
web link posted by Tibor (thank you), it looks like we need only the Server
Plus Device CALs model. There will be no web access and I know exactly how
many users will get to it at all times. I had trouble finding where it says
we don't need a license for the passive failover option. Could you send me a
link? That sounds like what we need. Do I then need CALs for each user?|||Search for "failover" in the FAQ page.
As for the licensing, since you don't have any internet access to the
server, choose whichever licensing model (per-processor or CAL) is cheaper.
That is why Microsoft has multiple licensing models.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:BB370D4D-88FB-4ACC-B8E1-A82932038125@.microsoft.com...
> We will not be doing any processing on the non-active server. From the MS
> web link posted by Tibor (thank you), it looks like we need only the
> Server
> Plus Device CALs model. There will be no web access and I know exactly
> how
> many users will get to it at all times. I had trouble finding where it
> says
> we don't need a license for the passive failover option. Could you send
> me a
> link? That sounds like what we need. Do I then need CALs for each user?
>|||Thank you. BTW, I did find the FAQ site on licensing. Thanks very much for
your help. I don't think our software supplier is asking us the right
questions, as they went straight for the per-processor option even though the
device CALs option is much better suited for our situation.|||If I already have device CALS for existing SQL servers, do I need to buy new
ones for a new SQL server I am installing or do I just buy the server
license? It looks like the device CAL is good for connections to any number
of different servers, so long as each server has a license.
When doing that install on a new server, do I have to tell it how many CALs
I bought or is it basically the honor system?
I have seen some folks wondering how to enter the number of CALs. If I add
more CALs, do I need to tell my instance of SQL server how many I added?|||A Device CAL can connect to any number of SQL servers.
There is no technical enforcement measure for CAL enforcement built into SQL
Server. It is a good idea to set up a licensing server and funnel CAL
configuration through that so you have a single point of maintenance.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:DF76E12F-B60D-48B2-BFB6-5A4364B46F95@.microsoft.com...
> If I already have device CALS for existing SQL servers, do I need to buy
> new
> ones for a new SQL server I am installing or do I just buy the server
> license? It looks like the device CAL is good for connections to any
> number
> of different servers, so long as each server has a license.
> When doing that install on a new server, do I have to tell it how many
> CALs
> I bought or is it basically the honor system?
> I have seen some folks wondering how to enter the number of CALs. If I
> add
> more CALs, do I need to tell my instance of SQL server how many I added?

How many Enterprise Licenses to Buy?

We are building up a clustered server configuration with two nodes. Each
node will be an HP ML580 or DL 580 with 4 processors per server. Do we need
to buy two Enterprise licenses (one for each 4-processor server) or 8
licenses (one for each processor on each server)? I am getting conflicting
information on this. Thanks for any info.How many instances are you going to run in the cluster? You license per acti
ve instances (unless you
will run several instances in the same node, i.e., the other node doesn't do
any SQL Server
processing at all). And, if you license per processor, you need to multiply
with the number of
processor sockets you use in the machine.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we ne
ed
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting conflictin
g
> information on this. Thanks for any info.|||It depends.
First, check with your local Microsoft office. Make sure you have a person
knowledgable about SQL licensing in a clustered environment.
Here is the base page with links to the licensing information:
http://www.microsoft.com/sql/howtobuy/default.mspx#EEAA
Here is the FAQ page
http://www.microsoft.com/sql/howtobuy/faq.mspx
The relevant question and answer are here:
Q. How does licensing work for computers that run SQL Server 2005 in
failover scenarios?
A. Failover support, where servers are clustered together and set to
pick up processing duties if one computer should fail, is now available in
Workgroup, Standard, and Enterprise editions of SQL Server 2005. Under each
of these editions, keeping a passive server for failover purposes does not
require a license as long as the passive server has the same or fewer
processors than the active server (under the per processor scenario). For
details on which failover methods are available under each edition, visit
the SQL Server 2005 Features Comparison page.
Finally, SQL 2005 supports failover clustering on Standard Edition with up
to four processors on each host. If you do not need any other Enterprise
Edition features, you will save a considerable amount of money on licensing
by using Standare Edition. Oh, and look at the DL/ML 585 series wutl
Dual-Core processors. IMHO, the best bang for the bucks.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:3A9EC00F-834F-4F8C-AAB7-041A2354B95D@.microsoft.com...
> We are building up a clustered server configuration with two nodes. Each
> node will be an HP ML580 or DL 580 with 4 processors per server. Do we
> need
> to buy two Enterprise licenses (one for each 4-processor server) or 8
> licenses (one for each processor on each server)? I am getting
> conflicting
> information on this. Thanks for any info.|||We will not be doing any processing on the non-active server. From the MS
web link posted by Tibor (thank you), it looks like we need only the Server
Plus Device CALs model. There will be no web access and I know exactly how
many users will get to it at all times. I had trouble finding where it says
we don't need a license for the passive failover option. Could you send me
a
link? That sounds like what we need. Do I then need CALs for each user?|||Search for "failover" in the FAQ page.
As for the licensing, since you don't have any internet access to the
server, choose whichever licensing model (per-processor or CAL) is cheaper.
That is why Microsoft has multiple licensing models.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:BB370D4D-88FB-4ACC-B8E1-A82932038125@.microsoft.com...
> We will not be doing any processing on the non-active server. From the MS
> web link posted by Tibor (thank you), it looks like we need only the
> Server
> Plus Device CALs model. There will be no web access and I know exactly
> how
> many users will get to it at all times. I had trouble finding where it
> says
> we don't need a license for the passive failover option. Could you send
> me a
> link? That sounds like what we need. Do I then need CALs for each user?
>|||Thank you. BTW, I did find the FAQ site on licensing. Thanks very much for
your help. I don't think our software supplier is asking us the right
questions, as they went straight for the per-processor option even though th
e
device CALs option is much better suited for our situation.|||If I already have device CALS for existing SQL servers, do I need to buy new
ones for a new SQL server I am installing or do I just buy the server
license? It looks like the device CAL is good for connections to any number
of different servers, so long as each server has a license.
When doing that install on a new server, do I have to tell it how many CALs
I bought or is it basically the honor system?
I have seen some folks wondering how to enter the number of CALs. If I add
more CALs, do I need to tell my instance of SQL server how many I added?|||A Device CAL can connect to any number of SQL servers.
There is no technical enforcement measure for CAL enforcement built into SQL
Server. It is a good idea to set up a licensing server and funnel CAL
configuration through that so you have a single point of maintenance.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"DaveK" <DaveK@.discussions.microsoft.com> wrote in message
news:DF76E12F-B60D-48B2-BFB6-5A4364B46F95@.microsoft.com...
> If I already have device CALS for existing SQL servers, do I need to buy
> new
> ones for a new SQL server I am installing or do I just buy the server
> license? It looks like the device CAL is good for connections to any
> number
> of different servers, so long as each server has a license.
> When doing that install on a new server, do I have to tell it how many
> CALs
> I bought or is it basically the honor system?
> I have seen some folks wondering how to enter the number of CALs. If I
> add
> more CALs, do I need to tell my instance of SQL server how many I added?

How many drives can be mapped to 2 SQLServer on cluster

Dear all,

We have just configured a SAN system and 2 SQLServer clustered(A/P).

The vendor has mapped 2 logical drives each one is accessed by each SQLServer

ex:

Logical Drives on SAN :- H: and G:

Server S1 have accesses to H: and Server S2 have accesses to G: but at a time we can see both logical drive on each system but can access there mapped drives.

Is this possible to have 2 logical drives on each server mapped with each other on the cluster server.

Server 1 having drive H: and G:

Server 2 having drive H: and G:

Note : Vendor told us that there is a BUG in SQLServer 2005 that only one drive can be mapped with each sqlserver in a cluster.

Please help

Is there can Document Released from Microsoft Regarding Clusting SQLServer2005 Please the link.

Regards

Mohd Sufian

This is not a bug, but functionality. You can only add one drive to each cluster group. If the drive is already used by one SQL server instance, you can not use the same with other instance.

Here is a webcast on 'How to custer SQL Server 2005':

http://support.microsoft.com/kb/891798

And here is a white paper:

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

|||This is technically not a problem with SQL. Most SAN's don't allow you to point more than 1 computer to 1 logical volume on the SAN.

How licences work in a backup computer

Hello,
I have found that if you have a clustered and log-shipping environtment you
don't have to buy licences for the passive computer. But in my environtment
I have the main server and then more computers with SQL Server installed but
not used (the service stopped), but in case of failure of the server, I can
restore the backup database on one of this other computers to continue
working.
I suppose that it's the same case than in clustered and log-shipping, if I
just use only one SQL Server at a time, I only have to buy licences for one
server. But I haven't found anything of than in Microsoft site. Does anyone
know how it works?
Thank you in advance,
Josep.The way I had it explained to me was that if the "standby" instance don't do any work normally, then
it doesn't need a license. And that this is regardless of what technology you are using. But I'd ask
an MS rep to be certain...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Josep" <jmartinez@.autec.es> wrote in message news:eWVpPoKoIHA.3900@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I have found that if you have a clustered and log-shipping environtment you don't have to buy
> licences for the passive computer. But in my environtment I have the main server and then more
> computers with SQL Server installed but not used (the service stopped), but in case of failure of
> the server, I can restore the backup database on one of this other computers to continue working.
> I suppose that it's the same case than in clustered and log-shipping, if I just use only one SQL
> Server at a time, I only have to buy licences for one server. But I haven't found anything of than
> in Microsoft site. Does anyone know how it works?
>
> Thank you in advance,
> Josep.
>