How to identify your SQL Server version and edition even if SQL Services are not running

Leave a comment (2) Go to comments

I was being called in a mid of a upgrade project from SQL Server 2005 to SQL Server 2008. The assigned DBA resource has gathered all the information related to SQL Server. SQL Services were stooped so that cold backup of files can be performed at file level. So SQL services were taken down and the backup team started backing up all the drives.

Suddenly there was some confusion about the Edition of SQL Server as this server was assigned as test box so no much hardware was used. People are not sure whether it was a Standard Edition, Enterprise Edition or an Developer Edition.

In Ideal conditions, To determine which version of Microsoft SQL Server 2008 is running, connect to SQL Server 2008 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

 SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Problem

I was being called to answer which Edition and version of SQL Server 2005 was installed, when SQL Services were offline, without starting the SQL Services.

Solution :

Irrespective of the version of SQL Server, information is saved in the registry. Only the location changes for various versions. The path in the registry is as follows.

SQL Server Default Instance(2000)



HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup

SQL Server Default Instance(2005)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

SQL Server Named Instance (2008)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.ONE\Setup

 

This is how the information looked like in Registry Editor, Getting information of default Instance from registry editor

How to identify your SQL Server version and edition even if SQL Services are not running sql server information from registry identify SQL Server version and edition even even if SQL Services are offline howto check the sql server edition when sql services are down howto check the sql server edition How to tell what SQL Server version you are running How to identify your SQL Server version and edition even if SQL Services are not running How to identify your SQL Server version and edition How to find the service pack version installed on SQL Server how to find SQL Server version how to find SQL Server edition Find your Sql Server Version and Edition when sql services are stopped Find your Sql Server Version and Edition when sql services are offline Find your Sql Server Version and Edition when sql services are down Determining What Microsoft SQL Server Edition is Installed

Getting information of named Instance from registry editor

How to identify your SQL Server version and edition even if SQL Services are not running sql server information from registry identify SQL Server version and edition even even if SQL Services are offline howto check the sql server edition when sql services are down howto check the sql server edition How to tell what SQL Server version you are running How to identify your SQL Server version and edition even if SQL Services are not running How to identify your SQL Server version and edition How to find the service pack version installed on SQL Server how to find SQL Server version how to find SQL Server edition Find your Sql Server Version and Edition when sql services are stopped Find your Sql Server Version and Edition when sql services are offline Find your Sql Server Version and Edition when sql services are down Determining What Microsoft SQL Server Edition is Installed

Conclusion :  Registry editor is still a very useful tool which stores all application information.  You can easily get information like SQL Server :-


  • "Version"="10.1.2531.0"
  • "SQLPath"="C:\\Program Files\\Microsoft SQL Server\\2008\\MSSQL10.ONE\\MSSQL"
  • "ProductCode"="{B8E9F8A1-9F4D-43D5-ABD6-1DF067FAA469}"
  • "SqlProgramDir"="C:\\Program Files\\Microsoft SQL Server\\2008\\"
  • "FeatureList"="SQL_Replication_Core_Inst=3 SQL_Engine_Core_Inst=3 SQL_DataFiles_Core_Inst=3 SQL_ENGINE_DB_CNI=3 SQL_Replication_CNI=3 SQL_Replication_FNI=3 SQL_CMDLINETOOLS_CNI=3 SQL_DUMPER_CNI=3 SQL_Engine_CNI=3 SQL_ENGINE_CORE_CNI=3 SQL_LEGACYTOOLS_CNI=3 SQL_REPL_ENGINE_SUPPORT_CNI=3 SQL_SLP_ENGINE_SUPPORT_CNI=3 MPT_AGENT_CORE_CNI=3 SQL_AGENT_FNI=3 SQL_DATA_COLLECTOR_FNI=3 SQL_LEGACYTOOLS_FNI=3 SQL_MAIL_FNI=3 SQL_REPL_ENGINE_SUPPORT_FNI=3 SQL_UPGRADESCRIPTS_FNI=3"
  • "PatchLevel"="10.1.2531.0"
  • "SQLBinRoot"="C:\\Program Files\\Microsoft SQL Server\\2008\\MSSQL10.ONE\\MSSQL\\Binn"
  • "Language"=dword:00000409"
  • EditionType"="Enterprise Evaluation Edition"
  • "Edition"="Enterprise Evaluation Edition"
  • "Collation"="SQL_Latin1_General_CP1_CI_AS"
  • "SQLDataRoot"="C:\\Program Files\\Microsoft SQL Server\\2008\\MSSQL10.ONE\\MSSQL"
  • "FullTextDefaultPath"="C:\\Program Files\\Microsoft SQL Server\\2008\\MSSQL10.ONE\\MSSQL\\FTData"
EOF - How to identify your SQL Server version and edition even if SQL Services are not running, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

2 Comments.

  1. good way to get server version and edition

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.

Trackbacks and Pingbacks: