February 12, 2007 at 9:46 am
In SQL Server 2000, I could see licensing by viewing the SQL Server 2000 Licensing Setup within the Control Panel. How do I do this in SQL Server 2005?
February 12, 2007 at 10:16 am
Unfortunately Microsoft has gone from ugly to hideous in this area with 2005. 2000 used to give you some information about licensing model, although it was not terribly reliable. SQL Server 2005 gives you nothing.
You need to keep track of this yourself and keep your licensing agreements!
/*****************
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
*****************/
February 12, 2007 at 11:40 pm
It is true that in SQL2K you had a little applet to track licenses. But the information entered there had absolutely no impact on the server. It didn't restrict connections and limit CPU usage. It was pretty much all FYI. In addition, once you chose a licensing model (CAL or CPU) you couldn't change it.
In SQL2K5 we removed that little applet. So yes, you'll need to use your own mechanism for tracking licenses.
Cheers,
Dan
February 13, 2007 at 10:41 am
select
serverproperty('LicenseType')
Per BOL:
Mode of this instance of SQL Server.
PER_SEAT = Per Seat mode
PER_PROCESSOR = Per-processor mode
DISABLED = Licensing is disabled.
Base data type: nvarchar(128)
Regards,Yelena Varsha
February 13, 2007 at 11:01 am
Like I said in SQL 2000 that would give you some indication of your license type, but it was not always correct. However, in SQL 2005, that query will always return 'Disabled'.
/*****************
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
*****************/
February 13, 2007 at 12:59 pm
I does return Disabled for my servers, but I was under impression that this is because we have a corporate agreement and they send us special CDs I don't have to enter the licensing mode during the installation. Is it correct for other installations? I already posted this question some time ago
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=251394
got a reply from Dan Jones, which is the same as in this discussion that this functionality was removed.
Regards,Yelena Varsha
February 13, 2007 at 2:37 pm
Nope, every installation of 2005 I've ever seen will return Disabled. In a way it kind of makes sense.
In SQL 2000 LicenseType was not always reliable and it never had any relationship to actual licenses purchased. If MS had adopted something more along the lines of Oracle or DB2 where licensing is actually enforced, I can only imagine the kind of howling and recriminations they would have faced. So in the end, they apparently gave up.
Now you're on your own to track licensing. In reality you always were, but now they don't even pretend...
/*****************
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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply