Licence Disabled

[Skittle]

One of the SQL Server's I have inherited is a bit of a mystery to me. I today looked at the licence settings for a requirement for another package and found to my surprise that the licencing mode is listed as 'disabled'.

How can you enable/disable the licencing mode?
What does it mean legally? It sounds to me as if the server is breaking the rules if it is used by more than one connection/user.

SELECT  SERVERPROPERTY('productversion'), 
        SERVERPROPERTY ('productlevel'), 
        SERVERPROPERTY ('edition'),
        SERVERPROPERTY(‘LicenseType’),
        SERVERPROPERTY(‘NumLicenses’)

The results are:-

8.00.760
SP3
Standard Edition
DISABLED
NULL




Dazed and confused
N+, MCDBA 2000, MCAD .NET

 

[Catadmin]

Depends on what the server's being used for. If it's the passive server for an active/passive log shipping scenario, you don't need a license for it.

Here's Microsoft's SQL Server 2000 Licensing FAQ location. Look it over and see if any of it fits what you're seeing:

http://www.microsoft.com/sql/howtobuy/faq.mspx

Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

That would be developer or eval edition.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Skittle]

Really???

Is there a way to confirm that?
The version is listed as the 'standard edition' from the serverproprty.

Dazed and confused
N+, MCDBA 2000, MCAD .NET

 

[Skittle]

I have stumbled on some more information.
If you use the licensing per processor, the SERVERPROPERTY(‘LicenseType’) can return a value of 'DISABLED'.

See link:-

http://support.microsoft.com/?kbid=291332

I checked the SQL Server 2000 Licensing Setup within control panel ( never noticed this before ) and it confirms the license mode is indeed per processor. Phew!!!

I was shocked to find it set to disabled BUT i'm more shocked that MrDenny ( 'he who knows all' ) didn't know about this little feature ).

Thanks for your help chaps.







Dazed and confused
N+, MCDBA 2000, MCAD .NET

 

[mrdenny]

That's just stupid that it shows disabled (espically since it's not disabled).

I hope you don't think any less of me because of this.

(Keep in mind it will also show disabled for the developer, which is what I ran your code against).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Skittle]

MrDenny your hero status in my eyes has only slightly been tarnished.

)






Dazed and confused
N+, MCDBA 2000, MCAD .NET