How to determine which License is being used?

  • I am trying to figure out what type of CAL or license is being used on our current 2005 server. I'm using this as a baseline for our 2008 server because I didn't place the 2005 original order and the old receipt is no help.

  • SELECT SERVERPROPERTY('LicenseType')

    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)

  • I believe for SQL 2005 and better you're always going to get DISABLED back from that query.

    Licensing isn't embedded in SQL or the registry anymore. You need to keep track of this as a "paper only" license.

  • You may be right..

    CEWII

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply