After installing Reporting Services for Mobile Management for Configuration Manager 2007, you attempt to run one of the reports and receive an error.
An error occurred when the report was run. The details are as follows:
Linked servers cannot be used under impersonation without a mapping for the impersonated login.
Error Number: -2147217900
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 7437 "
This issue is a SQL permissions problem with the user that runs the report.
On the SQL server that hosts the Athena database for reports, in SQL Server Management Studio:
Symantec Mobile Management for Configuration Manager 2007 7.2 SP1
MS SQL 2008, 2008 R2