up vote 1 down vote favorite
share [g+] share [fb]

I'm trying to square up licensing, and I'm looking at a few SQL 2008 boxes that are in a cluster and I can not see where it says Enterprise Edition anywhere, even though I know that's what it's running.

I need to figure this out, because I have a few Reporting Servers that are on Virtual Machines that may or may not be running Enterprise Edition.

I can't do this through a query since the DB Services are not installed on the Reporting Servers. However, I still have to license those boxes

link|improve this question
75% accept rate
feedback

6 Answers

up vote 4 down vote accepted

From KB321185:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
link|improve this answer
I can't do this through a query since the DB Services are not installed on the Reporting Servers. However, I still have to license those boxes. – Jim May 29 '09 at 15:49
Ah, ok. You can get the edition from the registry then. HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSRS10.MSSQLSERVER\Setup\Edition. Have a look there. – squillman May 29 '09 at 16:01
Note, you might have to replace the MSRS10.MSSQLSERVER with the intallation name of your particular instance. MSRS10 means ReportServer, MSSQLSERVER is the default instance. – squillman May 29 '09 at 16:03
That registry entry was exactly what I needed! Thanks! – Jim May 29 '09 at 16:31
All right, rock on! :) – squillman May 29 '09 at 16:34
feedback
up vote 0 down vote

use [master] select @@version

link|improve this answer
feedback
up vote 0 down vote

Log at the log files in the directory /MSSQL/LOG. The SQL log files will be called ERRORLOG.x where x is a number, normally up to about 6, and it just indicates where the log file has been cycled.

Open these in notepad/wordpad, and the edition should be shown when the server is started; for example one of my servers has the entry

2009-05-17 00:00:01.86 spid89      Microsoft SQL Server 2005 - 9.00.3077.00 (X64) 
    Dec 17 2008 20:40:08 
    Copyright (c) 1988-2005 Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

You may have an issue if you regularly cycle the logs, and haven't had a server restart, but other wise this should help

link|improve this answer
feedback
up vote 0 down vote

I think I found a way.

There is a file: C:\Program Files\Microsoft SQL Server\100\License Terms\SQLServer2008_License_ENT_1033.rtf

That seems to suggest the Enterprise Version was installed.

Remember, the paticular server I'm looking at, does not have any database services installed. This prevents me from using the Logs, or SQL queries to identify the version.

link|improve this answer
Have a look at my comments to my answer. I think the registry is probably a bit more reliable in general... – squillman May 29 '09 at 16:17
I missed that comment. That totally worked. Thanks! – Jim May 29 '09 at 16:30
feedback
up vote 0 down vote

What exactly was installed then?

Kev

link|improve this answer
All of the Reporting and Business Intelligence features. – Jim May 29 '09 at 16:33
feedback
up vote 0 down vote

If you can launch a Query to the server you can execute

SELECT @@version

@@version returns the complete description of the SQL Server version that is running, including version and number.

If you want to get this information and can’t connect to SQL Server to execute the query you can access the registry and go to the key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCE_NAME\Setup\

Here there are 2 values that describe the version installed:

  • Edition: Contains the name of the edition installed
  • PatchLevel: Contains the complete version number
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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