Welcome to Cognettacloud

9x Microsoft Business Solutions 365 MVP, I'm the CTIO for congruentX and a community Technology Evangelist Delivering Edge Experiences Using Microsoft Dynamics 365, Azure & Power Platform (Power BI, PowerApps & Power Automate) & Office 365

CRM 2011 Installation Error: SQL instance name must be the same as computer name

This error is common when the SQL instance name is different the computer name. Open SQL management studio, and issue an SP_HELPSERVER. This will return the current SQL instance name which is most likely different than the machine name. Verify the correct machine, by right clicking on computer, properties and looking under Computer Name, Domain […]

Migrating CRM 2011 Online databases to SQL OnPremise: Database cannot be started in this edition of SQL Server

When Microsoft Dynamics CRM 2011 is installed using a Microsoft SQL Server 2008 Enterprise edition (CRM Online) , a partition is created for the auditing functionality of Dynamics CRM 2011. The AuditBase table uses partitioning which is only available for Microsoft SQL Server 2008 Enterprise. This also holds true for database backups received from Microsoft’s […]