November 29, 2007 at 4:26 am
I'e just taken over control of a SQL 200 server, but no one seems to know what licence mode it was installed with.
In the Server properties in Enterprise Manger, there are tabs to limit both the number of processors, and the number of connections (this one uses all the processors, and has no concurrent connection limits). However, these figures can be changed easily, so don't necessarily mean it was installed with 4 per-processor licences.
Is there any way to discover this?
November 29, 2007 at 8:05 am
It really doesn't matter how it was installed. This an administrative license only. What matters is that you have the administrative licenses in a file cabinet and you are abiding by them.
http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
November 29, 2007 at 9:18 am
Steve,
So, from a technical perspective (though obviously not a legal one) it doesn't make any difference what licence mode you select when you install SQL Server, because you can go and change the restrictions (number CPU's used, number of client connections) once it has been installed? And there is nothing to indicate what was selected, except for the paper licences?
Adam
December 2, 2007 at 1:31 pm
It's indicated in the registry keys, but it doesn't affect operation.
December 3, 2007 at 3:51 am
Steve Jones - Editor (12/2/2007)
It's indicated in the registry keys, but it doesn't affect operation.
Steve,
Thanks - you wouldn't happen to know the exact key would you? I've looked through all the keys under HKLM\Software\Microsoft\MSSQLServer, but I can't see any that give any indication as to which Licencing mode was selected during installation.
Regards
Adam
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply