Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

How to Fix a MBS_Grant_IMPERSONATE Error from the Support Debugging Tool

How to Fix a MBS_Grant_IMPERSONATE Error from the Support Debugging Tool

  • Comments 0

David Meego - Click for blog homepageWhile we are troubleshooting error messages from the Support Debugging Tool, I had another one reported last week.

The error message below is displayed by the Support Debugging Tool when setting up the SQL Profile Tracing functionality from the Administrator Settings >> SQL Profile Trace Settings window:

An error occurred executing SQL statements: MBS_Grant_IMPERSONATE. GPS Error: 24, SQL Error: 15151 [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot fine the login 'XXX', because it does not exist or you do not have permission.

 

This error will occur if there are user records in the SY_Users_MSTR (SY01400) table which do not have an associated SQL Login at the SQL Server. If you capture a DEXSQL.LOG, you will be able to see the user(s) that are causing the issue. For example:

/*  Date: 09/19/2012  Time: 21:33:45
SQLSTATE:(37000) Native Err:(15151) stmt(45087392):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the login 'XXX', because it does not exist or you do not have permission.*/
/*

 

To resolve this issue either create the missing SQL Logins or remove the additional Microsoft Dynamics GP users from the system, so that SQL and the SY01400 table match.

 

Also see the related articles below:

 

Hope this is useful.

David

Comments Information

PLEASE READ BEFORE POSTING

Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 4 and 4 and type the answer here:
  • Post