Category: CRM SQL

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

by Indika Abayarathne

When the Sql server instance is differ from the machine name, this error will be given as a result of verification tasks under the system check of CRM installation. Most of the time this happens if the Sql server instance changes after the first installation and reinstallations. Anyhow this can be fixed easily as we … Continue reading CRM Installation Error : Sql instance name must be the same as computer name

SQL Server function to get Business Unit Guid by Name

by Indika Abayarathne

This will be very useful when you are migrating data to CRM database from some other system database. Specially when filling base tables we should give business unit guid to it. You can use following function and I have given the way that you should use it in your data migration scripts. CREATE FUNCTION dmfx_GetBusinessUnit(    … Continue reading SQL Server function to get Business Unit Guid by Name