Tip #659: Installing Dynamics CRM on a named SQL Server instance

I don't trip

It is possible to install Dynamics CRM On-premises using SQL Server named instance. For most parts, the process is straightforward and no different from a “standard” installation except that you have to use server_name\instance_name notation when referring to SQL Server. But sometimes things don’t go according to the plan and this is what I learned: […]

Tip #609: Higher SQL compatibility level does not mean better

Gayan “Performance Wizard” Perera continues to live up to his nickname with another awesome performance tip. tl;dr Beware setting the SQL database compatibility level to a level higher than 110 on a CRM 2016 system. The scenario You have an entity with more than 5 secured fields. When the record is opened it either times […]

Tip #386: The fastest way to provision new organization

For people who complain that they provision CRM organizations daily, hourly, weekly and cannot relax for 5 minutes while new organization is being created, here the quickest way to provision new CRM on-premises organizations: One-off preparations Go through the pain one last time and watch the paint dry while creating a new organization (name it, […]

Tip #310: CRM 2013 to CRM 2015 Upgrade Gotcha #1

SQL Server Reporting Services Connector Uninstall Warning

Thinking about doing an in place upgrade from CRM 2013 to CRM 2015? If so it isn’t just a matter of running the SetupServer.exe file. That is even assuming that your underlying infrastructure supports CRM 2015. One notification that you run into immediately is the pre-requisite to uninstall the CRM Connector for SQL Reporting Services. […]

Tip #302: Optimize CRM by updating statistics and reorganizing indexes

Another SQL nugget from Gayan “Mr Performance” Perera: If you’re running CRM (any variant) on-premise you can optimize the speed of the system by setting up two management jobs inside SQL. First, update statistics of the organization_MSCRM database every day (outside business hours). Second is to reorganize the indexes of the organization_MSCRM database every 2-4 […]

Tip #171: If email router is having a slow day or how to add custom index

Sometimes things are slow. Very. Slow. So slow that your email router starts spitting dreadful messages: #9628 – An error occurred while delivering the e-mail message with subject “None of your business” in mailbox foo@bar.baz for delivery to https://crm.bar.baz. System.ServiceModel.FaultException`1 [Microsoft.Xrm.Sdk.OrganizationServiceFault]: SQL timeout expired. (Fault Detail is equal to Microsoft.Xrm.Sdk.OrganizationServiceFault). If you are on CRM […]

Tip #105: Can I remove SQL SysAdmin and Local Administrator permissions

A question that is frequently raised in large enterprise deployments of Microsoft Dynamics CRM is can the local administrator and SQL SysAdmin permissions be removed from the installing user after the installation. The answer is “yes, but…” Yes, you may remove these permissions after the installation is complete. The user who performed the installation will […]