Licence Mode

  • 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?

  • 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

  • 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

  • It's indicated in the registry keys, but it doesn't affect operation.

  • 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