Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message "The server principal 'xxx' is not able to access the database 'XXXXX' under the current security context." when using Audit Trails in Microsoft Dynamics GP

Error message "The server principal 'xxx' is not able to access the database 'XXXXX' under the current security context." when using Audit Trails in Microsoft Dynamics GP

Error Message

A user who has Audit Trail permissions can no longer access Audit Trails or run Audit Trail reports. For example, in the Smartview window in Audit Trails, these messages occur (referencing the user's alias for the xxxxx and respective Audit database for the XXXXX):

GPS Error epAuditTrailView I_PB_Refresh_CHG: 10

SQL Error epAuditTrailView I_PB_Refresh_CHG: 916
 
The server principal 'xxxxx' is not able to access the database 'XXXXX' under the current security context. 

ODBC Error epAuditTrailView I_PB_Refresh_CHG: 08004


↑ Back to the top

Cause

The security table in Audit Trails (mxTableAccess - MXAT4001) needs to be refreshed.

↑ Back to the top

Resolution

To resolve the issue you can install Audit Trails again to refresh the security table, as follows:  

1 Click on Microsoft Dynamics GP, point to Tools, point to Company, point to Audit Trails, and click on Install Audit Trails.

2. In the Install Audit Trails window, click Install.

3. In the Install Wizard window, click Install.

4. Click Finish.



↑ Back to the top

More Information

Installing Audit Trails again will automatically grant users access to the audit databases. Since Audit Trails is already installed for the company, the installation will realize this and move to Step #3 in the Install Wizard which will take the system through the process of adding new users to the database. This will not reset any audits or anything that is already set up. The current data in the audit tables will stay in tact. 

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2450782
Revision : 1
Created on : 1/7/2017
Published on : 8/5/2011
Exists online : False
Views : 161