SQL Server Performance Forum – Threads Archive

SQL License Mode

Any one knows how to check the licenses mode on SQL, per processes or per seat ? I want to document the system.

Hi, you can do it with serverproperty(”) read BOL for more. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Regards Hemantgiri S. Goswami [email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

Hello ghemant, Take one of our SQL box for example, I know it is per seat. Running the following script on SQL box, QA, select serverproperty(‘LicenseType’)
select serverproperty(‘NumLicenses’) results are as follows:-
DISABLED
Null So, I think there must be somewhere else to grab the information. thanks, Lan

Hi,
its their , please read BOL for more its not the full you have to convert it to varcahr()
SELECT CONVERT(char(20), SERVERPROPERTY(‘servername’))
refer :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_3mi1.asp Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

Hello ghemant, I run the following scripts on the SQL box: SELECT CONVERT(char(20), SERVERPROPERTY(‘Edition’))
SELECT CONVERT(char(20), SERVERPROPERTY(‘NumLicenses’))
SELECT CONVERT(char(20), SERVERPROPERTY(‘LicenseType’)) Results:-
Standard Edition
Null
Disabled Still not right.

Meaning that licensing is disabled on this server. I’m not sure but it’s possible this setting is invoked if you have selected Per Processor licensing, but then selected 0 processors. It could also have been done explicitly by someone. You should still be able to check on your licensing settings on the server. Open the server Control Panel and click on the SQL Server 2000 Licensing set up icon (not to be confused with the regular Windows Licensing icon). You cannot change licensing modes from here, but you can add or remove processors from your licensing set up. Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;291332 for relevant information. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

thanks for all. I decide to manully check the mode 🙁

Hello Satya,
The link you provided is for 2000….. from where I can configure the licencing for the sql server 2005 …..

Either http://www.microsoft.com/sqlserver/2005/en/us/how-to-buy.aspx or http://www.microsoft.com/Sqlserver/2005/en/us/licensing.aspx can help you.

]]>