How to check whether your installed SQL Server instance is CORE or CAL

One day we got a mail from client asking us to upgrade existing SQL Server instance to new version and edition. At the same he also asked me the existing SQL Server instance license type is it a CORE or CAL. I have gone through the a couple of SQL Server commands like  SELECT @@version and SELECT SERVERPROPERTY('LicenceType') but the results shown as NULL. Later i checked with one of my old friends and he suggested me to check that in the below path. And i found it in the below path. You can see multiple .txt files here but take old folder and you could see a file name like  SQL_ENGINE_CORE_INST_CPU64_1. If you open this file you could see a product name as second line  below

C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20140708_110252

Product: \\Racnu337bn08\ddrive$\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi

Comments

Popular posts from this blog

System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Pre login Handshake or Connection Timeout Period

Transparent Data Encryption(TDE) with Master Key and Certificate in SQL Server