1

I have installed SQL Server 2016 Enterprise and applied the license key but

SERVERPROPERTY('LicenseType') is disbaled and  
SERVERPROPERTY('NumLicenses') is null

There is no key in the registery such as following for SQL Server 2016:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL13.SQL2016\Setup

Any idea how can I change LicenseType of SQL Server?

1

Any idea how can I change LicenseType of SQL Server?

Since licenses are assigned to servers externally, you can switch which licenses are assigned to which servers any time you want, subject to the restrictions on License Mobility, documented in the SQL Server Licensing Guide. Basically you can only move licenses once every 90 days unless you have Software Assurance, or experience a disaster.

6

If you read official documentation of Serverproperty (T-SQL), it says

LicenseType: Unused. License information is not preserved or maintained by the SQL Server product. Always returns DISABLED.

NumLicenses: Unused. License information is not preserved or maintained by the SQL Server product. Always returns NULL.

SQL Server does not stores license information anywhere inside its mostly on paper or in some kind of agreement between you and Microsoft or you and Vendor who is providing the software copy. Having said that you can get very limited information when you run select @@version

Any idea how can I change LicenseType of SQL Server?

You simply cannot unless you buy a totally different license.

PS:Dont worry your SQL Server installation is fine

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.