Sunday, November 13, 2011

CRM2011 Setup/Upgrade Errors and Resolutions

This is the second part of my last blog Installing CRM2011 with Precreated AD Groups.
The following are some of the errors and their resolutions encountered during installation/upgrade

Error 1

SQLSERVERAGENT (SQLSERVERAGENT) service is not running on the server ......



· Check if SQLSERVERAGENT service is running
· Open the port 445 for SQL Server.

Error 2

During the import of the organizations the following warning was received.
"Fragmented indexes were detected in the Microsoft Dynamics CRM database",


Re-index the organisation databases
USE MyDatabase
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
EXEC sp_updatestats
Updating statistics ensures that queries compile with up-to-date statistics

Error 3

The following error message was received when testing the email router:
Type 'System.ServiceModel.Channels.ReceivedFault' in Assembly 'System.ServiceModel, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable


Add the account running the email router services to PrivUserGroup security group.

Error 4

The following error message was received when accessing the reports from any of the organizations:
Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj) Cannot create a connection to data source 'MSCRM'. (rsErrorOpeningConnection)
The reason was SSRS connector(reporting extensions) was installed using user other than deployment account. The SSRS service account was missing in privreportinggroup group.


  • · Add SSRS service account to privreporting group.
  • · Reinstall the reporting extension again using deployment account.
The process to resolve was as follows:
  1. 1. Uninstall the Reporting Extensions.
  2. 2. Go to the CONFIG DB (MSCRM_CONFIG) of CRM and update your organization's row in the Organization table to set the AreReportsPublished boolean field to FALSE.
  3. 3. Re-install the Reporting Extensions and they should publish the reports again.
Note: You will see the message about installation is republishing the reports again


The section contains information on the issues encountered that required fixing for the upgraded organisations.

Issue 1

Unknown labels in settings group as shown in the screen shot below. This had happened to all four organisations.
image clip_image006
             Before                              After


Follow the Microsoft article for resolution:

Issue 2

The main tab is closed by default as shown in the screen shot below:
It is noted that this happened on multiple different locations throughout all the organisations.


  • Open the form in customisation mode.
  • Expand the tab, save the changes and then publish the changes.
There were few other things that did not work after upgrade. One of them was, the client has custom button to “Create Phone Cal” on contact and account form. The button was using builtin javascript function “locAddActTo(4210)”. I need to change the ribbon and javascript to fix that that function does not exist in CRM 2011.

That’s all from me.


  1. Thank you! You spared me a couple of hours of googling. Error 1 was my issue. I opened the firewall and was good to go :)