SQL Server Performance

How do i check the SQL Server licence mode?

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256, May 30, 2008.

  1. Trev256 New Member

    Hi - does anyone know how to check the SQL Server licence mode (for all versions) e.g. per seat or processor?
    Can this be easily located in the Registry?
    Thanks
    Trev256, May 30, 2008
    #2

  2. Ola Hallengren New Member

    Ola Hallengren, May 30, 2008
    #3

  3. Trev256 New Member

    The result is 'DISABLED' - What does this mean?
    Trev256, Jun 9, 2008
    #4

  4. Luis Martin Moderator

    LicenseTypeMode 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)
    Luis Martin, Jun 9, 2008
    #5

  5. Trev256 New Member

    How do I change the licence mode?
    Trev256, Jun 26, 2008
    #6

  6. satya Moderator

    satya, Jun 26, 2008
    #7

  7. nandan.pandey New Member

    Hi,
    I am also looking for the same, but that forum mentioned by you does not work for me. Does it work for any one?
    Thanks,
    Nandan
    nandan.pandey, Jun 27, 2008
    #8

  8. satya Moderator

    Can you explain a bit more on the problem?
    satya, Jun 29, 2008
    #9

  9. nandan.pandey New Member

    Hi Satya,
    I have a mixed environment of SQL server, in which I have few SQL Server 2000 server and few SQL Server 2005 Servers. For auditing purpose we need to track the licensing information. In SQL server 2000, I am able to get information quite easily through Control panel, but there is no way to get same kind of information for SQL Server 2005. As someone mentioned the link for configure registry setting for SQL server 2005
    http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx . I have already tried it but it did not work for me.
    Any help on it is really appreciated.
    Thanks a lot in advance.
    Regards,
    Nandan Pandey
    nandan.pandey, Jun 30, 2008
    #10

  10. satya Moderator

    Have you restarted the server after that registry hack?
    satya, Jun 30, 2008
    #11

  11. nandan.pandey New Member

    Yes, I restarted the SQL Service as well as Reboot the Server. But no luck [:(]
    nandan.pandey, Jul 1, 2008
    #12

  12. satya Moderator

    Are you able to see same kind of registry path on yoru SQL 2005 installation server?
    satya, Jul 2, 2008
    #13

Share This Page