January 13, 2016

CRM SQL – sp_dropserver / sp_addserver

Had an instance after doing a VM clone where the CRM installer couldn’t see the server I wanted. Did some digging… Open the database you want […]
January 13, 2016

Dynamics 2015 to Dynamics 2016 – Existing SQL Server connections to the Microsoft Dynamics CRM databases must be closed before setup can continue.

Finally got my hands on the 2016 ISO from work and am testing some upgrade paths on a VM which I actually need to scrap… Hit […]
January 12, 2016

Dynamics CRM 2015 Installation – Uninstall Microsoft Dynamics CRM Connector for SQL Server Reporting Services..

Decided to upgrade our 2013 environment today and hit the following error (Staging server) Quick and easy fix.. Open add/remove programsĀ and remove the CRM reporting extension […]
January 12, 2016

SQL Server – Change table ownership

We’ve got a 3rd party application we’re having to upgrade which generates tables on the fly, the issue with this is that the database owner (Which […]
January 11, 2016

Dynamics CRM 2013 – Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.

Hit this error on our staging environment today, all of our testing has been going well till this appeared.. CRM -> Settings -> Data Management -> […]
December 16, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL – Campaign Interactions

Had a request today to pull interactions for a certain campaign today. CoreMotives has a great interaction section which allows you to view information about clicks, […]
December 15, 2015

Dynamics CRM 2013 SQL – System Jobs Monitoring

Last one for today.. Another instance of me using SSRS to send me emails every day, just so I can keep track of system wide errors. […]
December 15, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL -Triggered Emails Count

Another one… Use this for daily SSRS subscriptions because I’m too lazy to log into the server to check. Plus there’s no aggregation available on the […]
December 15, 2015

SilverPop (CoreMotives) – Dynamics CRM 2013 SQL – Submitted Data Extract Query

Ran into a limit using the CoreMotives web form result export button from our on-prem CRM (2013) deployment so I wrote a little SQL script to […]
March 3, 2015

CRM Email Router strikes again

Spent a day and a half trying to figure out why our CRM Email Router hasn’t been playing with others. Managed to find out why today. […]