Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

Process license ?
Hello Everyone,

Our company is currently under the Enterprise agreement with Microsoft
and I was wondering when it came to clustering, how many processors do we
have to licenses if both boxes has four processors in each box?  The way
we're running the cluster is Active/Passive.  We are using SQL 2000 Standard
edition along with Enterprise edition of Microsoft Windows 2003 Server.  If
someone could give me some insight I would highly appreciate it.

Thank you
Alex Anderson




Report this thread to moderator Post Follow-up to this message
Old Post
Alex Anderson
01-31-06 04:23 PM


Re: Process license ?
SQL Server 2000 Standard Edition doesn't support clustering, so that is your
first problem.  Now ignoring that, in an Active/Passive configuration you
need only license the maximum number of processors on any server in that
configuration.  In your case that would mean 4.  If you had a configuration
where the usually active system had 4 and the usually passive system had 8
then you'd need to license 8.

--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com



"Alex Anderson" <AAnderson@Murrieta.org> wrote in message
news:usdeZCoJGHA.668@TK2MSFTNGP11.phx.gbl...
> Hello Everyone,
>
>    Our company is currently under the Enterprise agreement with Microsoft
> and I was wondering when it came to clustering, how many processors do we
> have to licenses if both boxes has four processors in each box?  The way
> we're running the cluster is Active/Passive.  We are using SQL 2000
> Standard edition along with Enterprise edition of Microsoft Windows 2003
> Server.  If someone could give me some insight I would highly appreciate
> it.
>
> Thank you
> Alex Anderson
>
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Hal Berenson
01-31-06 04:23 PM


Re: Process license ?
Alex Anderson wrote:

> Hello Everyone,
>
>     Our company is currently under the Enterprise agreement with Microsoft
> and I was wondering when it came to clustering, how many processors do we
> have to licenses if both boxes has four processors in each box?  The way
> we're running the cluster is Active/Passive.  We are using SQL 2000 Standa
rd
> edition along with Enterprise edition of Microsoft Windows 2003 Server.  I
f
> someone could give me some insight I would highly appreciate it.
>
> Thank you
> Alex Anderson

SQL Server 2000 Standard Edition doesn't support failover clustering.
Your options are to upgrade to Enterprise Edition or to SQL Server 2005
Standard Edition, which do both support clustering.

"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)."
http://www.microsoft.com/sql/howtobuy/faq.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--


Report this thread to moderator Post Follow-up to this message
Old Post
David Portas
01-31-06 04:23 PM


Re: Process license ?
Thank you both.  Understood!

Alex Anderson

"Alex Anderson" <AAnderson@Murrieta.org> wrote in message
news:usdeZCoJGHA.668@TK2MSFTNGP11.phx.gbl...
> Hello Everyone,
>
>    Our company is currently under the Enterprise agreement with Microsoft
> and I was wondering when it came to clustering, how many processors do we
> have to licenses if both boxes has four processors in each box?  The way
> we're running the cluster is Active/Passive.  We are using SQL 2000
> Standard edition along with Enterprise edition of Microsoft Windows 2003
> Server.  If someone could give me some insight I would highly appreciate
> it.
>
> Thank you
> Alex Anderson
>
>
>



Report this thread to moderator Post Follow-up to this message
Old Post
Alex Anderson
02-01-06 01:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 05:39 AM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006