Error When Attempting to Display Mobile Management Reports

Products

• Mobile Management

Issue/Introduction

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 "

Cause

This issue is a SQL permissions problem with the user that runs the report.

Resolution

On the SQL server that hosts the Athena database for reports, in SQL Server Management Studio:

1. Select Databases, select the Athena database.
2. Expand "Security" and "Logins".
3. Create a new login for the Athena database.
4. Set the User Mapping to the Athena database as dbo.
5. Click "OK".
6. Select "Server Objects", select "Linked Servers".
7. Right-click "SMMLinkedServer" and select "Properties".
8. On the "Security" page, click the "Add" button.
9. For Local server login, select a Windows user that will need to run the reports in the Configuration Manager console.
10. Select the button "Be made using this security context".
11. For Remote login and password, enter the Athena database user and password you created above.
12. Click OK when finished.
13. Close any open instances of the Configuration Manager console and open it.
14. Re-run any of the reports.

 

 

Applies To

Symantec Mobile Management for Configuration Manager 2007 7.2 SP1

MS SQL 2008, 2008 R2