Determine License installed (ms sql 2000 and 2005)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jrod - 29 Jul 2008 14:42 GMT

How can I determine what type of license (CAL or processor based licenses)
are installed per server?

Reply to this Message

vinu - 29 Jul 2008 14:49 GMT

try

select SERVERPROPERTY('LicenseType')

Signature

vinu
http://oneplace4sql.blogspot.com/

> How can I determine what type of license (CAL or processor based licenses)
> are installed per server?

Reply to this Message

vinu - 29 Jul 2008 15:01 GMT

If the above query returns DISABLED then locate this "sqlslic.cpl" file in
sql server folder(C:\Program Files\Microsoft SQL Server\80\Tools\Binn) ,
right click->Open with Control Panel.
this will show you the licensing type used

Signature

vinu
http://oneplace4sql.blogspot.com/

> try
>
[quoted text clipped - 3 lines]
>> licenses)
>> are installed per server?

Reply to this Message

Vicky - 31 Jul 2008 12:18 GMT

Vinu,
I got the result -- DISABLED and then tried to locate the sqlslic.cpl
file at the location you specified but I have not found it there....
Also, I have not found it any where on the Server...

> If the above query returns DISABLED then locate this "sqlslic.cpl" file in
> sql server folder(C:\Program Files\Microsoft SQL Server\80\Tools\Binn) ,
[quoted text clipped - 19 lines]
>
> - Show quoted text -

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 31 Jul 2008 13:19 GMT

I got the result -- DISABLED and then tried to locate the sqlslic.cpl
file at the location you specified but I have not found it there....
Also, I have not found it any where on the Server...

DISABLED usually means you are using an MSDN copy of SQL Server (so, not a
production license - MSDN licenses are meant for development and testing).

Reply to this Message