Jason

So, in my infinite wisdom I decided to try and resolve an issue (Working on 2 issues at a time, important point.)

First issue: I noticed that one of our CRM services wasn’t actually using one of our production service accounts, no issue at all. Quick fix and a service restart. (ProTip 2: Don’t do this during production hours. Do as I say not as I do). Never an issue. Not actually sure who configured this the first time around, but stuff happens.

The second issue, I was trying to resolve a stupid issue regarding a CRM user account (See where this is going?). Cool, open CRM, settings, administration, add user, save. This is where my heart rate jumped 100BPM.

In my infinity wisdom, I copied the service account into the username, let it populate then hit save.

INSUFFICIENT PERMISSIONS. Contact an administrator.

[Lots of swearwords]+[Panic attack]+[Emotional breakdown as I don’t want to do any sort of restoration during production hours]

O WAIT, I R ADMIN AND KNOW CRM DATABASE. THIS COULD BE WORSE.

  1. Open up SSMS
  2. use [CRM DB]
  3. SELECT * From SystemUserBase where DomainName = ‘domain\serviceaccount
  4. Copy the SystemUserID

Run the following scripts (Taken from: https://markuserlandsson.wordpress.com/2014/10/02/adding-dynamics-crm-service-account-as-a-crm-user/ ) – With a modification

Note: This SQL will error regarding table references, delete from said tables too.

Restart services / Reboot as required.

ProTip: ONE TASK AT A TIME.
ProTip 2: DON’T ADD SERVICE ACCOUNTS AS USERS UNLESS YOU WANT TO BE LOCKED OUT OF ALL PERMISSIONS.
ProTip 3: BREATHE.

November 6, 2019

Dynamics CRM ProTip: NEVER add a service account as a user account

So, in my infinite wisdom I decided to try and resolve an issue (Working on 2 issues at a time, important point.) First issue: I noticed […]
November 5, 2019

The length of the ‘subject’ attribute of the ‘annotation’ entity exceeded the maximum allowed length of ‘500’.

Today I Learnt: Note subjects for Dynamics CRM 2016/365 (8.2) on-premises has a 500 character limit. Customization -> Note (Entity) -> Fields -> Subject -> Set […]
September 30, 2019

PowerShell – Install Chrome on Windows Server

Script is shameless stolen from: https://www.ryadel.com/en/install-google-chrome-with-powershell-script/ Run the following in PowerShell, let it run till completion then search for Chrome.
September 25, 2019

C# – Lets do API stuff without tokens, but using Azure Functions

Once again.. Unsupported, not production ready, does what I want it to do. I’ve also not included models and some other bits, as this is reference […]
September 25, 2019

Some C# – Lets do API things with tokens, JSON, lists and models.

Just dumping some code which I’ll evidently need to reference at some point and as it works.. I don’t want to re-write it (Yes, it’ll go […]
March 1, 2019

Python – Boto3 – Upload to S3

Here’s how you upload a file into S3 using Python and Boto3. If you wanted to upload a whole folder, specify the path and loop through […]
November 8, 2018

Dynamics CRM v9 On Premises: Needed downloads for standalone deployment

30/09/2019: If this is wrong, tweet me. Added some stuff for 9.0. 30/09/2019: Enhanced Security Configuration (https://tunecomp.net/disable-internet-explorer-enhanced-security-configuration-windows-server-2016/) Download for Server:¬†https://download.microsoft.com/download/B/D/0/BD0FA814-9885-422A-BA0E-54CBB98C8A33/CRM9.0-Server-ENU-amd64.exe ODBC Driver: https://download.microsoft.com/download/D/5/E/D5EEF288-A277-45C8-855B-8E2CB7E25B96/x64/msodbcsql.msi Download for SQL […]
May 4, 2018

Custom Ruleset

Death and 0HP: When you hit 0hp/drop, you start rolling death saves (DC10 check for success) 3 failed death saving throws leads to permanent death (aka: […]
March 28, 2018

SQL Server Permissions – the CHECK_POLICY and CHECK_expiration options cannot be turned off – SQL Account.

[crayon-5dce12e049140005457649/]  
November 2, 2017

Microsoft Dynamics 365 (online and on-premises) Update 2.2

Here you go..¬†https://support.microsoft.com/en-us/help/4046795/microsoft-dynamics-365-online-and-on-premises-update-2-2   Go deploy to UAT/Development.