How to check the sql server licenses

Question

select

 

serverproperty('LicenseType'),serverproperty('NumLicenses') giving result

DISABLED NULL

What does it mean?

I want to check either I can use this sql server in production or how to check the sql server licenses.

 

 

---

"SQLSERVER DBA" "INDIA"

Answer 1

hi,

I am sure that if its not a 'developer' edition or a beta version of SQL Server, you can use it in a commerical environment.

---

http://sqlservertipsandtricks.blogspot.com/

Answer 2

Hi 

SERVERPROPERTY('LicenseType') returns the Mode of this instance of SQL Server.

 

PER_SEAT = Per Seat mode

PER_PROCESSOR = Per-processor mode

DISABLED = Licensing is disabled (This will be returned for MSDN or TechNet License or SQL Express or Evaluation or Developer Edition)

SERVERPROPERTY('NumLicenses') - 

 Number of client licenses registered for this instance of SQL Server if in Per Seat mode.

Number of processors licensed for this instance of SQL Server if in per-processor mode.

Returns NULL when the server is none of these.

MSDN Licenses should be used for Development and Testing and cannot be used for Production, similarly TechNet License should be used for Evaluation purposes

For detailed reference on SERVERPROPERTY read this article 

http://msdn.microsoft.com/en-us/library/ms174396.aspx

 

 

---

Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
If you found this post useful, let us know by clicking "Vote as Helpful" and Propose as Answer