SQL Server Performance

SQL Server 2005 license

Discussion in 'SQL Server 2005 Clustering' started by dba247, Jun 22, 2007.

  1. dba247 New Member

    Can somebody please tell me how to check for license expiration date for a sql server 2005 install ?

    The current install was done using a download from msdn and I didn't have to punch in a key during the install.

    Does this mean this is a free trial for a limited period but we may have to eventually "activate" the license when the trial period expires ?

    Regards.
  2. satya Moderator

    YOu need not to enter such keys in SQL 2005, only you need to have paper license when such Audit is perfomed.
    DOn't worry licensing has been changed in SQL 2005, readhttp://www.microsoft.com/sql/howtobuy/faq.mspx and specifically on this topic.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dba247 New Member

    Satya,

    That's good to know.

    But what about "how to check for licensing for an existing install" - are there any commands
    to do this ?

    Thanks.
  4. satya Moderator

  5. dba247 New Member


    That's exactly what I was looking for - great!

    One last question about licensing - since we don't need to enter any keys for sql 2005, does this also mean that the msdn (sql server 2005 x64) download that we are using doesn't have an expiration date but we have to buy a (paper) license (esp. for auditing purposes)?

  6. satya Moderator

    Unless you haven't installed or used any EVALUATION edition you are safe to go and there isn't any expiry set on the application. For all the SQL instances that are used must have valid paper licenses, refer to the link above for furthe information.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  7. dba247 New Member

    Unfortunately I don't know if the edition downloaded was an EVALUATION edition or not - is there
    a way to determine this ?
  8. satya Moderator

    Run SELECT @@VERSION and see the results.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  9. dba247 New Member

    Here's the results:

    Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21
    Copyright (c) 1988-2005 Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Does this mean it's not an EVAL edition ? So there's not expiration date
    for this edition as such right ?
  10. MohammedU New Member

    Evaluation edition shows as Enterprise Edition when you run SELECT @@version...

    I am not sure how to check this...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  11. MohammedU New Member

    I don't think there is any way other than checking the installation date...

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=257649&wa=wsignin1.0


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  12. dba247 New Member

    Sounds good, thank you.
  13. satya Moderator

    SELECT CONVERT(char(20), SERVERPROPERTY('Edition')) will get you more information.



    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page