Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by maria.d.st » Fri, 18 Aug 2006 04:47:56


I had previously read a thread on this newsgroup stating multiple
instances were not supported on a single cluster with SQL Server '05
Standard Edition.

I'm researching information to take to the business for why we need SQL
Server 2005 Enterprise Edition instead of Standard Edition. This is a
new two-node, four processor active/passive cluster on 2003 Enterprise
OS and I have a requirement for an app installation to have its own
instance of sql server (security reasons). I have other apps that will
share another instance of sql server '05. I'm worried that the
licensing we have now (this was purchased prior to me coming on board)
is not sufficient to support this type of configuration, nor does it
allow for additional nodes or processors. I have the documentation
supporting the limitation on scalability for infrastructure, but I
haven't found explicit documentation about standard edition not
supporting multiple instances. I really want the argument for
Enterprise to be a no-brainer and not meeting the project requirements
will get their attention...

Where may I find Microsoft documentation that states this?
 
 
 

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by Geoff N. H » Fri, 18 Aug 2006 05:04:29

First, whoever wrote your requirements has little or no understanding of SQL
Security if they think that different instances results in enhanced
security.

The correct answer depends on how you have licensed your SQL installation.
If you have a per-proc license, you can run as many instances as your system
can hold (up to 16) on the cluster. The only gotcha is that once you
install the second instance, you have to license all processors in all
hosts. This applies to both Enterprise and Standard Edition systems. Per
server licenses are for a specific server environment.

If you are a per-server license with CALs, you need a new license for each
instance, but a CAL can connect to any number of SQL servers/instances.

Personally, I would go with Standard Edition for a two-node, four-proc SQL
2005 cluster, especially if I was using per-processor licensing, and put the
savings into a larger system. If you need to move up to a larger cluster,
that is when you spend the $$$. Since the retail price difference is ~20K
per processor, you can buy a lot of server for that money.

This link may help:
http://www.yqcomputer.com/ #EWC

Finally, verify this with your Microsoft office before spending any money.
I am not a lawyer, nor do I work or speak for Microsoft.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

 
 
 

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by uttamk » Fri, 18 Aug 2006 05:18:27

Maria,

Multiple clustered instances of SQL Server 2005 (Standard Edition) is supported on the same cluster. The limitation is on the number of nodes of the cluster. And that is 2. i.e. You can have clustered SQL Server 2005
instances (Standard Edition) on two node cluster. Since you have a two node cluster, you should be good.

Here is the documentation

SQL Server 2005 Features Comparison
http://www.yqcomputer.com/

SQL Server 2005 Licensing: Frequently Asked Questions
http://www.yqcomputer.com/

Whitepaper - SQL Server Pricing and Licensing
http://www.yqcomputer.com/

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.yqcomputer.com/

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.yqcomputer.com/
http://www.yqcomputer.com/
 
 
 

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by maria.d.st » Fri, 18 Aug 2006 05:26:46

I agree that the business doesn't know why they're asking for a
separate instance, but that's a whole different issue. Thanks for your
candor.

We currently have four processor licenses. Each node has four
processors. This is an Active/Passive configuration. Why would all
processors on all hosts require licensing for a new instance in an
active/passive configuration?

Thanks for the help...

Maria
 
 
 

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by maria.d.st » Fri, 18 Aug 2006 05:34:41

Thanks, Uttam.
 
 
 

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by Geoff N. H » Fri, 18 Aug 2006 06:45:17

icrosoft has a special license exemption for a failover node, be it via
Clustering, Mirroring, or Log Shipping. When you are clustering, if you add
a second instance, you must license the second node. If you have fewer
instances than nodes, then you have to license enough procs to cover all
instances. They came up with these rules, not me.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




< XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...


 
 
 

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by uttamk » Sat, 19 Aug 2006 03:17:46

Maria,

I am not a Licensing expert (yes, we have Licensing experts in Microsoft) but to find the answer to your qs

" We currently have four processor licenses. Each node has four processors. This is an Active/Passive configuration. Why would all processors on all hosts require licensing for a new instance in an
active/passive configuration?"

I searched the "SQL Server 2005 Licensing: Frequently Asked Questions"
http://www.yqcomputer.com/

and found the following

Q. If I am doing log shipping in an active/passive failover configuration, how should I license the backup server?
A. In this scenario, the passive server does not require a license, unless the passive server has more processors than the active server, and the active server is licensed under the per processor model.


Since you will have 4 processor licenses and you are going to have an active/passive failover configuration, you do not need licenses for the passive node.

Now coming to your qs on running multiple instances on the active node

Q. How does licensing work with the multi-instance feature in SQL Server 2005?
A. You can run multiple instances of SQL Server 2005 on a single computer. Multiple instances are used by organizations that have several applications running on a server but want them to run in isolation so that any
problem in one instance will not affect the other instances. In SQL Server 2005, you can now run multiple instances with the Workgroup, Standard, and Enterprise editions when they are licensed server/CAL or on a
per-processor basis.


So, if you have processor licenses, you can run multiple-instances on the active node.

Note that if you have an active/active failover scenario then you will have to license the procs on both the active nodes.

BTW - For SQL Server 2005, one can have upto 25 clustered instances on the same cluster. 16 was the limit for SQL Server 2000.


Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.yqcomputer.com/

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.yqcomputer.com/
http://www.yqcomputer.com/
 
 
 

Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?

Post by uttamk » Sat, 19 Aug 2006 03:32:26

Maria,

Additional information from "Microsoft Whitepaper - SQL Server Pricing and Licensing"
http://www.yqcomputer.com/

When doing failover support, a server is designated as the passive server. The purpose of the passive server is to absorb the data and information held in another server that fails. A passive server does not need a
license, provided that the number of processors in the passive server is equal or less than those of the active server. The passive server can take the duties of the active server for 30 days. Afterward, it must be
licensed accordingly.

Here it clearly says that the passive server does not require license (provided it has equal or less procs than active server).

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.yqcomputer.com/

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.yqcomputer.com/
http://www.yqcomputer.com/