Technology

Technology

June 22, 2016

C# Code Snipped – Connect to SQL and set variable

using System.Data.SqlClient; var connetion = new SqlConnection(); connetion.ConnectionString = “Data Source=XXXXXXSQL; Initial Catalog=xxx_db1; Integrated Security=true;”; connetion.Open(); SqlCommand query = new SqlCommand(“Select ID from XXX where Username = ‘” + […]
May 12, 2016

Dynamics CRM 2015 – Javascript – getServerURL() is dead

Use getClientURL() All problems will go away.
April 7, 2016

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel

Odd one today, only happened to find the solution (Short one as this is more of a note to myself) because of ‘muscle memory’ TL;DR: Make […]
April 7, 2016

Dynamics CRM 2013 to 2015 Upgrade – Encryption

Did a live upgrade of our CRM server and hit the following error when some plugins were firing: “Cannot open Sql Encryption Symmetric Key because Symmetric […]
March 22, 2016

Dynamics CRM 2013 – Current key (KeyType : CrmWRPCTokenKey) is expired. This can indicate that a key is not being regenerated correctly

Following error has appeared on one of my servers, ran the following command in command prompt (elevated) to make it go away… “C:\Program Files\Microsoft Dynamics CRM\tools\Microsoft.Crm.Tools.WRPCKeyRenewal.exe” […]
January 28, 2016

Dynamics CRM | SSRS – Error Uploading Report

Over the last week I’ve been tweaking some of our logic in CRM and totally forgot to update our reports to show our statistics..  A week […]
January 25, 2016

Dynamics CRM 2016 – Entity/Global Search – Filtering

Been playing with the new global search and didn’t like that it was searching across a pre-determined set of entities. Settings -> Administration -> System Settings […]
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 […]