January 2, 2004 at 4:31 pm
We are running SQL 2000, SP3a with MS03-031, Windows 2000 AS with SP4
I am getting bogus information on the license type when looking at it
through the SQL Server Licensing applet in the Control Panel and when I
query it using SERVERPROPERTY ('LicenseType')
Both methods show "Per_Seat" when I know it is Per processor.
According to Q291332 this issue was fixed in SP2.
Any ideas how I can ACCURATELY audit all my SQL Server instances for
licensing? We have over 70 instances installed, many of which were
installed before my time or without my involvement so I really need to find
a way to determine how the licensing was setup and make sure we are in
compliance.
Any help would be greatly appreciated.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
January 5, 2004 at 7:22 pm
This was removed by the editor as SPAM
February 6, 2004 at 11:33 am
Just in case it might be helpful to someone else...
This problem is limited to clustered instances of SQL Server. In these cases the only way to determine the licensing mode is to go to the setup file in ...\winnt\sqlstp0.log and search for the "LicenseMode" entry in the log. There should be an entry that says "ShowDlgLicense returned: LicenseMode = x, LicenseLimit = y". For SQL 2000 the Licensemode codes are as follows:
0 = Per Seat, 2 = Per Processor
For SQL 7:
0 = Per Seat, 1 = Per Server
LicenseLimit is either the number of processors or seats...
Of course, if you have deleted the setup files, you are out of luck as far as I know since the registry entries for the liceningmode are not reliable (they are also not enforced).
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply