Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
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.
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
