The SELECT permission was denied on the object 'V_WM_DeviceHistory' (4320072)

While trying to access the Windows Mobile reports you get the following error:

Error

Unexpected error while attempting to read from the database.

The SELECT permission was denied on the object 'V_WM_DeviceHistory', database 'MessageStats', schema 'dbo'.

SELECT COUNT(*) AS [_Count] FROM (SELECT DisplayName, Organization, MailboxEmail, StoreDN, FirstSyncDay, ServerCN, MailboxDN, DeviceID, LastPolicyUpdateTime, DeviceType, DeviceIMEI, LastGatheringTime, [Identity], DevicePhoneNumber, DeviceOSLanguage, DeviceOS,DeviceFriendlyName,DeviceModel,DeviceWipeAckTime,

DeviceWipeRequestTime, DeviceWipeSentTime, DeviceUserAgent, LastSuccessSync, FirstSyncDay as AggregateDay, FirstSyncTime, DeletionTime, DeletionDay, ActiveSyncServerDN,

-- New Mailbox attributes

Container, Alias, AssociatedNTAccountType, CreationDate, LastLogonDate, Hidden, X400Address, NTAccountDomainVersion,

-- T_MailboxesUserInfo attributes

Department, Company, Office, Assistant, Phone, Address, City, State, Code, Country, LastName, FirstName, Initials, FaxNumber, PagerNumber, MobilePhoneNumber, HomePhoneNumber, ManagerDN, SimpleDisplayName, HomePage, Info, Comment, ForwardingAddress, Division,

The Windows Mobile views did not get upgraded correctly .

Follow the steps below to fix the issue.

1. Copy the MessageStatsMigration.sql script out of the SQL directory in the Installation Package.

2. Put the script on the SQL Server that hosts the MessageStats database.

3. Open SQL Management Studio and connect to the Instance that hosts the MessageStats database.

4. Go to File - Open - Open file and browse the the MessageStatsMigration.sql script

5. Make sure that the MessageStats database is selected in the Top Left hand corner and press the Execute button to run the script.

Note: Make sure there are no errors when running the script, if there are please contact support and give them the errors.