Post reply

how do you find out the license type?

  • November 8, 2007 at 5:23 am

    #376752

    Hi

    I have a named instance of sql2005 running on a windows 2000 server. The default instance is sql2000. I can find the license type for the sql2000 installation by going to control panel and clicking the sql 2000 licensing setup utility. I cannot find anything relating to sql2005 in the control panel. I have tried running the script 'select serverproperty('licensetype')' but it just returns 'disabled'.

    Is there any way of quickly finding out the license type, I have no idea how this instance was installed :unsure:

  • November 9, 2007 at 6:42 am

    #749823

    as far as I know this is correct - certainly this is what BOL says.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • November 9, 2007 at 7:32 am

    #749839

    Per BOL: LicenseType

    Mode of this instance of SQL Server.

    PER_SEAT = Per Seat mode

    PER_PROCESSOR = Per-processor mode

    DISABLED = Licensing is disabled.

    So I guess your License is Disabled.

  • November 9, 2007 at 8:17 am

    #749871

    sounds about right

    thanks Linda

  • November 9, 2007 at 8:55 am

    #749889

    There is even a Microsoft Knowledgebase Article for this

    http://support.microsoft.com/kb/291332

    N 56°04'39.16"
    E 12°55'05.25"

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

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