Dynamic CRM 获取license from DataBase 【转】

Retrieve your Dynamics CRM license key easily

 

How to Retrieve Dynamics CRM License Key

Open up your SQL Server instance, and locate the MSCRM_Config database.

Retrieve your Dynamics CRM license key easily – Image 01

Fire up the following Query and you should have the license key right in front of you:

 

1	SELECT NVarCharColumn FROM ConfigSettingsProperties where ColumnName = 'LicenseKeyV6RTM'

 

 

Retrieve your Dynamics CRM license key easily – Image 02

 

 

Retrieve your Dynamics CRM license key easily – Image 03

In this case, I used the Microsoft Dynamics CRM Server 2013 (no CAL limit) Trial key. The key happens to be “CQWW3-TNXBF-HRQWC-CVTW9-M968H” which is returned by the query result.

The above query works for CRM 2013. But if you want to do the same for CRM 2011, there will be a slight change in the query. Everything else remains the same; meaning you’ll need to query the MSCRM_CONFIG database here as well.

 

1	SELECT LicenseKeyV5RTM FROM ConfigSettings

Executing the above query should display the License Key used to register CRM 2011.

 

Retrieve your Dynamics CRM license key easily – Image 04

The above key that you see is again a Trial Key for Dynamics CRM 2011 that was used while installation.

For CRM 4.0, there’s a change in query again. The database remains the same. Following will list the license key.

 

1	SELECT LicenseKey FROM ConfigSettings