How can I find how many license I have on a server

Question

Post reply

How can I find how many license I have on a server

Sopheap Suy

SSCertifiable

Points: 7893
More actions
December 23, 2003 at 8:43 am

#160483

I am trying to find out how much or what type of license we have on our sql server box. How can I find this information out. Of course I could tell if it's a Standard vs Enterprise Edition but how many device or user license do we have? I know for sure that we don't use per cpu license schema.

Thanks in advance.

mom

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

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

K. Brian Kelley SSC Guru Points: 114532 More actions · Answer 1

K. Brian Kelley

SSC Guru

Points: 114532

December 23, 2003 at 8:47 am

#487609

At the console or through Terminal Services

Start | Settings | Control Panel | Licensing.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

Rodrigo Acosta SSC-Insane Points: 21261 More actions · Answer 2

Rodrigo Acosta

SSC-Insane

Points: 21261

December 23, 2003 at 8:49 am

#487611

Run:

SELECT serverproperty('LicenseType')

SELECT serverproperty('NumLicenses')

Sopheap Suy SSCertifiable Points: 7893 More actions · Answer 3

Sopheap Suy

SSCertifiable

Points: 7893

December 23, 2003 at 9:19 am

#487623

bkelley,

I found chose licensing mode, window server, per seat but no number of seat... It does not have information about SQL Server license.

racosta,

SELECT serverproperty('LicenseType')--result is disable

SELECT serverproperty('NumLicenses') -- result is null.

mom

K. Brian Kelley SSC Guru Points: 114532 More actions · Answer 4

If it's per seat, that number isn't stored on the SQL Server. You'll probably need to contact whoever in your organization is in charge of licensing to determine how many CALs you have for SQL Server.