How to get your Dynamics CRM License Key from the Database

Today a colleague asked me how to receive the License Key for a customer’s existing Dynamics CRM environment. As I did not knew the version used at the customer, I send him the information for alle environments, I currently work with.

Dynamics CRM 2011

USE MSCRM_CONFIG
SELECT LicenseKeyV5RTM FROM ConfigSettings

Dynamics CRM 2013

USE MSCRM_CONFIG
SELECT [NvarCharColumn] AS CRM2013LicenseKey FROM [MSCRM_CONFIG].[dbo].[ConfigSettingsProperties] S WHERE S.ColumnName = ‘LicenseKeyV6RTM’

Dynamics CRM 2015

USE MSCRM_CONFIG
SELECT [NvarCharColumn] AS CRM2015LicenseKey FROM [MSCRM_CONFIG].[dbo].[ConfigSettingsProperties] S WHERE S.ColumnName = ‘LicenseKeyV7RTM’

This post is based on a blog post by Hosk, but he did not update it yet for Dynamics CRM 2015. 😉

So no credits for me today. 🙂

Deploying Dynamics CRM 2015 Solutions using xRM CI Framework

The last week we were struggling with deploying and most of all publishing a big solution in Dynamics CRM 2015 On-Premise.

The environment was has been migrated from CRM 2011 to CRM 2015 (of course with intermediate step on CRM 2013) and there are of course a lot customizations and extensions we need to change before satisfying the customer.

As already mentioned, we had problems with a bigger solutions, keeping most of the new entities and webresources. After the 5th or 6th attempt, we were able to perform the import of the solution, but for days we were facing an error when trying to publish the customizations.

After changing all related timeout values (i.e. the OLEDBTimeout) and values in the web.config, we were still seeing an error on the CRM website and also in the Event Log of the Deployment Server. Additionally we have checked the SQL Server performance, which was okay and also the server performance which was also performing very well.

To give you an overview about our environment, we are using a Front End Server, one Back End Server including the Deployment Roles, one SQL Server and a separate SQL Server. All of them equipped with enough CPU power, enough memory and with good connection. So nothing to be worried about here.

I earlier was looking for an opportunity to publish our solution packages using Windows PowerShell or at least the Command Line Tool, but I never had enough time to create something on my own. Yesterday when I was facing these SQL timeouts in the event log, I decided to give the xRM CI Framework a try.

After some configuration and reading the documentation, I was able to connect to our CRM environment. The good thing is, I was able to publish the customizations. After like a thousand times trying to publish it using the website.

This is just a short article, that the xRM CI Framework was helping a lot. I’m going to write more about it and how to use it in the next days. But first I will watch some football and have a beer. 😉

Dynamics CRM 2015 Update 0.2 released

For a long time now Update 0.2 for Dynamics CRM 2015 was announced and finally it is here today.

Update 0.2 for Microsoft Dynamics CRM 2015

There are a lot of enhancements and new supported technologies like Windows 10 and Edge, but for me another point is currently the most important. With Update 0.1 a bug was introduced preventing you from importing an organisation from a database backup. The detailed description was already made by PowerObjects in this post.

This was very frustating and stopped us at several projects. Although there was a workaround (which is of course not supported by Microsoft), we lost a lot of time when trying to import an organisation.

Now I will have a look at the new Update 0.2 and report about anything that might be worth posting about it. 🙂

My first post – A short introduction

Hey everyone or ‘Moin Moin’ like we say in Northern Germany,

this is my first post in my first blog ever and I think that it’s bad manner not to introduce myself.

My name is Sebastian and I am working as an IT professional for a Microsoft Partner in Germany. Since 2011 I am working with Dynamics CRM, starting with version 4.0, but in the years i followed Microsoft’s product lifecycle to the current version 2015. I gathered experience with on-premises installation, but also with CRM Online in several projects.

Starting in a CRM support team, I quickly focussed on infrastructure related topics around Microsoft Dynamics CRM. Of course the main point was to support and enhance the CRM application itself, but with the time I was looking for a lot things about the technologies sourrounding Dynamics CRM, like Microsoft SQL Server or Microsoft Exchange.

I was always a fan of reading other professionals blogs and find out more about Dynamics CRM, but still there were a lot of questions I was not able to find an answer for. There had been always a struggle about setting up an own blog, as there are already a lot of information sources. But today I was reading again the blog of Hosk and found a very nice post where explains the current lack of postings and why it is important to him. Nevertheless there was one part, that gave me the starting shot for an own blog and I hope he is right. 🙂

By the time I will post interesting things mainly about Dynamics CRM and present solutions for things things I was not able to solve by using Google or another CRM blog. And hopefully this will be helpful to other people working with Dynamics CRM.