April 20, 2011 at 3:05 pm
Is there any way to find the number of devices using the SQL server? Can we find what kind of license model(Processor License/Server plus Device CALs/Server plus User CALs) does SQL server have?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
April 21, 2011 at 3:02 am
Anybody is having idea on this?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
April 21, 2011 at 4:11 am
I too would be interested to know if there is a way to do this? Under SQL 2000 you had the Licensing applet within control panel that would inform you which licensing option (Per Seat inc. no. of devices or Processor) was chosen during installation.
But for 2005 & 2008 this no longer exists.
April 22, 2011 at 12:21 pm
Sumanta Roy (4/20/2011)
Is there any way to find the number of devices using the SQL server? Can we find what kind of license model(Processor License/Server plus Device CALs/Server plus User CALs) does SQL server have?
I don't have a degree in MS Licensing but you can find the number of distinct hosts (i.e. devices) and users accessing your server with these:
SELECT DISTINCT
host_name
FROM sys.dm_exec_sessions
WHERE host_name IS NOT NULL ;
SELECT DISTINCT
original_login_name
FROM sys.dm_exec_sessions
WHERE original_login_name IS NOT NULL ;
Regarding what your licensing your server has associated with it...I think if you can prove you bought a license you're covered...it's not like it was in the NT4 and SQL 2000 days when you had to enter that info at installation time and it was stored in each server.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 23, 2011 at 12:27 am
SELECT ServerProperty('LicenseType') as LicenseType, ServerProperty('NumLicenses') as ProcessorCount
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 23, 2011 at 7:21 am
Another drive-by posting brought to us by Syed.
Here again, those values are irrelevant unless they're backed by real licensing purchases, That said, they will always return DISABLED and NULL by default because the installer does not ask in SQL 2005 or SQL 2008 like it did in SQL 2000.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply