SQL Server 2008 R2 Standard edition License update (Developer license to Production License) RRS feed

  • Question

  • We have an MSDN copy of the SQL server 2008 R2 standard edition which we have installed in production environment. We have subsequently bought a licensed copy of MS SQL server 2008 r2 Standard edition. Using the feature Maintenance and Edition Upgrade in SQL setup, we have updated the licensed product key information of the SQL server 2008 R2 from licensed setup file in production environment. We wanted to know how to view the licensed product key information from the server. Also we wanted to check if we have completed the process and we are legally using the software

    Query: select serverproperty('LicenseType'),serverproperty('NumLicenses') Is always returning “Disabled” and “NULL” before and after using Edition upgrade with valid license details.


    Friday, November 19, 2010 11:04 AM


  • Hello,

    SQL Server does not keep track licenses.

    Please verify you upgraded to Standard Edition:


    SERVERPROPERTY('Edition') AS Edition,


    For information about licensing, you can call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. You can also visit the following site for more information and support on licensing issues:


    Hope this helps.   

    Alberto Morillo

    Friday, November 19, 2010 1:16 PM