Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How can I determine the version of SQL 2005 Server on a machine.

I need to know if it is a Server license or a Processor license.

I've found

select serverproperty('LicenseType'), serverproperty('NumLicenses')

which returns:

DISABLED NULL

Also found this:

http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx

But is altering the registry the only way?

share|improve this question
add comment

4 Answers

up vote 3 down vote accepted

Keep in mind that if you installed SQL Server via a Volume License Agreement it will show as DISABLED NULL when you run the query that you posted.

Our SQL Server (which is legit and installed via a volume license agreement) doesn't return license information as the volume license installer doesn't ask for license information.

Your most reliable way to check on licenses is to find the paperwork from when it was purchased.

share|improve this answer
add comment

This indicates that licensing is disabled on your server. Perhaps it's SQL Express or SQL Developer edition, neither of which have licensing requirements in the sense of Per Seat / Per Processor licensing.

Here is the MSDN reference page for SERVERPROPERTY() for SQL 2005 that lists all of the possibilities.

share|improve this answer
add comment

Sql Server no longer tracks licensing - if you want to enable it you can modify the registry (unconfirmed)- see this Microsoft Blog post

share|improve this answer
add comment

Check your edition as well. For Developer edition, the LicenseType will return 'disabled'

select serverproperty('LicenseType'), 
       serverproperty('NumLicenses'), 
       serverproperty('Edition');
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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