While working on a routine CRM 2011 installation, all system checks passed except for Microsoft SQL Server’s. It failed with “The SQL Server ‘Server Name’ is unavailable. Gut instinct was firewall issues here. Disabled Windows Firewall on SQL an CRM servers but still […]
The use of SQL TDE – Transparent Data Encryption is a great way to secure your Microsoft Dynamics CRM 2011 or 4.0 systems, especially when they contain sensitive data like credit cards or social security numbers. This ensures that even if someone gets a copy of your database, it cannot be used or restored on […]
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 […]
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 […]