Changing Licensing Mode

Question

Post reply

Changing Licensing Mode

Sam Sheikh

Say Hey Kid

Points: 678
More actions
May 18, 2006 at 2:17 am

#112251

OK boring subject but...
I have a number of SQL 2000 Standard Edition servers installed under the wrong licensing mode i.e "Processor License" rather than "Per Seat". Is there a way of changing the mode and entering the CAL number?
Thanks in advance for any help.
May 22, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

I could be mistaken, but I think you need to reinstall SQL Server to change license modes.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Andy S-235350 Grasshopper Points: 10 More actions · Answer 2

CHANGING SQL SERVER 2000 LICENSING MODE

This is not supported by Microsoft.

Whatever you do is your own fault.

This is for informational use only.

1. REGEDIT:

Change this value to '1' (this unlocks the SQL License Setup tool which is currently grayed-out):

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\MSSQLLicenseInfo\MSSQL8.00\Mode

2. CONTROL PANEL - SQL SERVER 2000 LICENSING SETUP:

Select the appropriate License Mode and Quantity that you have purchased. Click Continue.

(This will change the Registry 'Mode' value mentioned above to '0' for per-seat, and '2' for per-processor. 'ConcurrentLimit' will be set to the number of Processors or Seats that you specify.)

3. SQL SERVICE:

Restart

4. SQL QUERY ANALYZER (To verify the change):

SELECT serverproperty('productversion') as SQLVersion, serverproperty('edition') as SQLEdition, SERVERPROPERTY ('LicenseType')as LicenseType, SERVERPROPERTY ('NumLicenses') as LicenseNum, serverproperty('productlevel') as SQLRelease;

GO

5. CLUSTERED SQL SERVERS (where applicable):

You will need to run this on every SQL server in a cluster.

-AJ

sqlstar2011 SSCertifiable Points: 6000 More actions · Answer 3

http://support.microsoft.com/default.aspx?scid=kb;en-us;870617

Andy S-235350 Grasshopper Points: 10 More actions · Answer 4

http://support.microsoft.com/default.aspx?scid=kb;en-us;870617

That article explains how to change the NUMBER of licenses, not the licensing MODE (Per-Processor to/from Per-Seat).

(it is stated in the KB article:

'Note In the SQL Server 2000 Licensing Setup utility, the licensing mode that appears is the mode that you selected when you set up SQL Server 2000. You cannot change the mode in the SQL Server 2000 Licensing Setup utility.')

Generally, you cannot change the licensing mode unless you unlock it (my previous post: Step1), and once you change it, you need to restart the SQL service in order for it to actually 'take' (my previous post: Step3).