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
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:
Description of the standard terminology that is used to describe Microsoft software updates
Microsoft Business Solutions CRM software hotfix and update package naming standards
MORE INFORMATION
You can contact a Microsoft CRM support professional directly at 877-752-1122
For Additional Information, please see:
http://mscrm.exiis.net/microsoft-crm-consulting/Pages/default.aspx