The Update Rollup 11 for CRM 2011 (KB2739504-V2) completed successfully. However, the database update failed for some organizations.

Written by Denis Stadler on . Posted in Dynamics CRM 2011

After installing the CRM 2011 Update Rollup 11 I’ve recieved a very interesting message:

The Update Rollup 11 for Microsoft Dynamics CRM Server (KB2739504-V2) completed successfully. However, the database update failed for some organizations.

After studying for a while, what I noticed was that:

  • the default language for the CRM 2011 server was English (United States)new-organization-wizard
  • the default language in SQL Server for the user used to do the installation was Britishsql-user-locale

It seems that the difference between American English and British is so important that the CRM 2011 Rollup 11 cannot handle it :).

The SQL commands used to fix this were:

--Check the Language used by the CRM user
EXEC sp_helplogins 'user'

--See the language lists
SELECT * FROm syslanguages

--Update the SQL login configuration
EXEC sp_defaultlanguage 'user', 'us_english'

Then I have reaplied the update and it worked like a charm.
succesfull-update

Tags: , , , ,

Trackback from your site.

Denis Stadler

I'm a technology enthusiast, with more than 10 years of experience in SharePoint and Dynamics CRM projects. To find more details about, please visit the about me page.

Leave a comment

*