How to Fix a MBS_Grant_IMPERSONATE Error from the Support Debugging Tool

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

While 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

This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.