Code Free Dynamics 365 Configuration Values

By Mehmet Ozdemir | April 27, 2018 | 0 Comments

Dynamics 365 Configuration Values In many systems, there will be a need to store key/value pairs for configuration data. Examples of this might be contact email address for an email template or a link to a payment gateway etc. To further complicate things we have development, test and production environments. What will be a valid…

Windows 10 Creators Update 1703 VPN Not Working Fix

By Mehmet Ozdemir | June 5, 2017 | 10 Comments

Are you having issues connecting to VPN services on Windows 10 Creators Update 1703? If so then read on. Having installed Windows 10 Creators Update everything was working well with no real issues for me other than needing to re-install the Dell Audio application that the Microsoft updated decided I probably didn’t need anymore. Anyway, only a…

Converting a CRM Workflow to an Action

By Mehmet Ozdemir | March 8, 2017 | 1 Comment

Actions have been around for a while now and they’re a great addition to the CRM developers toolkit. But what about when you revisit an existing workflow and think, wouldn’t it be great if I could convert this guy to an action and then either call it from JavaScript or if using CRM 2016 or above use a…

CRM 2016 On-Premise to SharePoint Online Gotcha’s

By Mehmet Ozdemir | August 1, 2016 | 1 Comment

CRM 2016 On-Premise to SharePoint Online Recently, I was asked to setup server-based authentication from Dynamics CRM 2016 to SharePoint Online. Step 1, read through the TechNet article and make sure all the prerequisite stuff was complete on the CRM installation. Microsoft Dynamics CRM System Administrator security role. This is required to run the Enable Server-based SharePoint…

Quick tip: Unable to connect to IFD Organization using XRMToolBox

By Mehmet Ozdemir | May 25, 2016 | 2 Comments

Here’s a quick tip if you’re getting the following error message when trying to connect to an IFD Organization using newer versions of XRMToolBox (that use the connection wizard): Unable to Login to Dynamics CRM Assuming your IFD is setup and working correctly the issue could be something as simple as the domain and username…

Importing a CRM Organization doesn’t always reflect the new Organization name

By Mehmet Ozdemir | May 9, 2016 | 1 Comment

A typical practice when developing for CRM is to import a template org into your target environment then apply any custom schema changes (via solutions) over the top. You would then import any seed data that is required for the organization. The way to do this is a have a template organization in CRM, then…

SSIS Task: The SQL command requires a parameter named “@Param”, which is not found in the parameter mapping.

By Mehmet Ozdemir | April 1, 2016 | 1 Comment

Time for a quick blog post on this error. This error has caught me out on more than one occasion, so much so that I’m writing this post now, grrrrr! So what happens? You’re creating an SSIS Task that includes an OLEDB source. The OLEDB source calls a Stored Procedure and you’re passing in some…

Reporting Services migration made easy with ReportSync

By Mehmet Ozdemir | August 26, 2015 | 0 Comments

Recently I was given a task to move a custom application developed on top of SQL Server 2005 to SQL Server 2014 (yes a big jump!). One of the tasks was to move the reports over to the new server. The server was already built and an empty reporting services instance was available. I needed a way…

TSQL pattern matching as part of a table join

By Mehmet Ozdemir | July 9, 2015 | 0 Comments

OK so anyone with some fundamental SQL knowledge will be able to read the following SQL statement and understand what it’s returning, let’s take a look:

To summarize we’re joining the FactInternetSales table to the DimCustomer table via the foreign key called CustomerKey. From the DimCustomer table we’re returning the LastName and FirstName and…

Connecting the CRM Email Router to a CRM Online deployment

By Mehmet Ozdemir | May 20, 2015 | 0 Comments

Here’s a quick tip for connecting the CRM Email Router to a CRM Online Deployment. If you’re following along with the documentation from Microsoft: Microsoft Dynamics CRM Email Router Installing Guide for use with Microsoft Dynamics CRM Online The section that describes connecting to a CRM Online deployment states: If you are connecting to Microsoft…