SQL Server Licensing

Question

Post reply

SQL Server Licensing

nmoore

SSCrazy

Points: 2414
More actions
March 16, 2005 at 6:12 am

#102436

This may be a stupid question but here goes:

If you have inherited some servers running SQL 2000 and SQL 7 on NT and 2000 where can you find out if the server was set up to run in processor licensing mode or in the mode where CALs are needed. If it is using CALs whats the easiest way to determine the number of CALs?
Nigel Moore
======================

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

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

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 1

covered under serverproperty

SELECT 'LicenseType',

(CASE WHEN CONVERT(char(20), SERVERPROPERTY('LicenseType')) = 'PER_SEAT'

THEN 'Per Seat Mode'

WHEN CONVERT(char(20), SERVERPROPERTY('LicenseType')) = 'PER_PROCESSOR'

THEN 'Per Processor Mode'

ELSE 'Disabled'

END)

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/

Stuart Davies SSCoach Points: 19505 More actions · Answer 2

What if

select SERVERPROPERTY('LicenseType')

returns "Disabled" - what does that mean?

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

"Disabled" is supposed to mean that a licensing type wasn't chosen during installation, but SQL 2000 had a bug that was fixed in sp2. And I don't think 'select SERVERPROPERTY' works in SQL 7 at all.

You could try looking at "SQL Server Licensing" icon in control panel of each server.

Greg

colin.Leversuch-Roberts SSC Guru Points: 52643 More actions · Answer 4

I've never found the licensing has any physical effect on the server, it6's more for licensing server - if you're running that it might be relevent - mainly for audit purposes I think.

[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/