December 23, 2003 at 8:43 am
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
December 23, 2003 at 8:47 am
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
K. Brian Kelley
@kbriankelley
December 23, 2003 at 8:49 am
Run:
SELECT serverproperty('LicenseType')
SELECT serverproperty('NumLicenses')
December 23, 2003 at 9:19 am
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
December 23, 2003 at 10:34 am
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.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
December 23, 2003 at 10:59 am
bkelley,
Thank you. I found out from my team lead that we have agency wide client licensing so I didn't have to worry about this part of the cost, just the basic server licensing cost is cool.
mom
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply