You receive an "A server error has occurred Sync has been canceled" error message or a "Device registration failed" error message when you try to connect by using Microsoft CRM Mobile 1.2 (903885)


The information in this article applies to:

  • Microsoft CRM Mobile, when used with:
    • Microsoft CRM 1.2
  • Microsoft CRM 1.2

SYMPTOMS

When you try to connect by using Microsoft Business Solutions CRM Mobile 1.2, you receive one of the following error messages on a Microsoft Windows Mobile Pocket PC 2003 device or on a Windows Mobile Pocket PC 2003 Phone Edition device. On a device that already has Microsoft CRM Mobile 1.2 installed, you receive the following error message:
A server error has occurred. Sync has been canceled.
On a device on which you try to configure a new Microsoft CRM Mobile 1.2 installation, you receive the following error message:
Device registration failed. For more information contact your system administrator.
Additionally, if the administrator views the Application log on the computer that is running Microsoft CRM 1.2, the administrator sees the following event: Event Type: Error
Event Source: MBSDeviceRegistration
Event Category: (40)
Computer: ServerName
Description: Exiting service abruptly.
Source : .Net SqlClient Data Provider
Message : User does not have permission to perform this operation on view 'dbo.MSCRMComputedSchemaVersion'.
SQL exception
Line# : 1
Message : User does not have permission to perform this operation on view 'dbo.MSCRMComputedSchemaVersion'.
Source : .Net SqlClient Data Provider Exception Contents : System.Data.SqlClient.SqlException: User does not have permission to perform this operation on view 'dbo.MSCRMComputedSchemaVersion'. at Microsoft.BusinessSolutions.Mobility.Exceptions.MbsMoException.Throw(Exception exception) at Microsoft.BusinessSolutions.Mobility.RdaMessageBus.RdaMessageBus.ProcessInBoundMessages(ScheduleItem item) at Microsoft.BusinessSolutions.Mobility.EndPointScheduling.Scheduler.ExecuteScheduledItem(Object item)

CAUSE

This problem occurs if all the following conditions are true:
  • Microsoft SQL Server is not running on the same computer as Microsoft CRM 1.2.
  • The administrator creates and then publishes a schema update in Microsoft CRM 1.2.
  • The following two services are not running when the administrator publishes this schema update:
    • Microsoft CRM Mobile Device Registration Service
    • Microsoft CRM Mobile Integration Service
In this situation, the account that updates the views in the Microsoft CRM Mobile database is not given the database owner right. Therefore, the Microsoft CRM Mobile 1.2 users are not granted access to log on by using Microsoft CRM Mobile 1.2.

RESOLUTION

Update information

The following file is available for download from the Microsoft Download Center:
DownloadDownload the 903885 package now. Release Date: P1

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file. For more information about installing software updates for Microsoft Business Solutions CRM 1.2, click the following article number to view the article in the Microsoft Knowledge Base:

839939 How to install software updates and hotfixes for Microsoft Business Solutions CRM v1.2

Installation information

Before the administrator runs the CRMMobDatabaseConfig.exe tool that this update contains, the administrator must back up the Microsoft CRM databases by using the SQL Server backup tool. Additionally, the administrator must back up the Microsoft CRM organizational unit in the Active Directory directory service. For more information about how to back up Microsoft CRM, the administrator should see "Chapter 10: Backing Up and Restoring your Microsoft CRM System" in the Microsoft CRM Implementation Guide.


Note Before the administrator follows the instructions in this article, the administrator must have a complete backup copy of the database that the administrator can restore if a problem occurs.

The administrator installs this update on computers that are running Microsoft CRM 1.2 Server. When the administrator installs this update, the administrator is prompted to extract the CRMMobDatabaseConfig.exe tool to a folder. To start the CRMMobDatabaseConfig.exe tool, the administrator locates the folder to which they extracted the tool and then runs CRMMobDatabaseConfig.exe. When the tool starts, the administrator clicks Configure. To make sure that the tool ran without errors, the administrator views the Status dialog box.

Note This tool creates a log file in the same folder where the administrator extracted the tool. The log file is named CRMMobDatabaseConfig.log.

Prerequisites

To install this update, the administrator must have installed Microsoft CRM version 1.2.

Removal information

The administrator cannot remove this update.

Restart requirement

If the administrator is prompted, the administrator restarts the computer after they install the update.

File information

The English version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
   Date         Time   Version    Size    File name
   ---------------------------------------------------------------
   15-Jul-2005  18:54  2.0.440.0  84,744  Crmmobdatabaseconfig.exe

MORE INFORMATION

To determine whether you experience this problem, the administrator runs the following SQL Query Analyzer statement against the Organization_Name_MSCRMMobileSubscriptions database:
SELECT * FROM MSCRMComputedSchemaVersion   
SELECT * FROM MSCRMSchemaVersion
If the returned values do not match, users will experience the symptoms that are mentioned in the "Symptoms" section. For more information about the terminology that is used to describe Microsoft product updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:

824648 Description of the standard terminology that is used to describe Microsoft software updates

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Modification Type:MinorLast Reviewed:9/8/2006
Keywords:kbMBSMigrate kbQFE kbHotfixServer kbpubtypekc KB903885 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.