Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Musgrave MVP, GPUG All Star, Community Legend]

Up

0

Down

::

Hi Mary

As you have GP Power Tools, you can check the two Dex.ini settings you mentioned in the Dex.ini Settings window.

However, if they are not achieving what you need, then use the Dex.ini Configuration window to clear the SQLLastUser Dex.ini settings in the Global Dex.ini.

Regards

David

[Lance brigham]

Up

0

Down

::

Hi Mary,

The screenshot of the login window you provided is not the normal login window for GP. I know I’ve seen that login window before when attempting to run GP, but can’t recall the exact circumstances surrounding when that occurs and is indicative of there being some other issue in place causing that login window to appear instead of the standard window. It might be a misconfigured ODBC configuration that causes that so I’d suggest verifying that first. For reference, I’ve attached what the login should look like as well as what you provided so you can see the difference.

Let me know if any questions.

Thanks,

Lance Brigham

Principal Consultant

Velosio

[David Musgrave MVP, GPUG All Star, Community Legend]

Up

0

Down

::

As for the Dexterity login dialog, rather than the Dynamics login dialog, this is caused by some custom code or ISV product attempting to access SQL tables before you have actually logged in.<div>

Please make sure your ISV products are up to date, including GP Power Tools. 😄 There is a hotfix available.

This dialog would not look at the Dex.ini settings you mentioned.

If you cancel that login, it should generate an error with a table name that would help identify the product that is causing the issue.

Regards

David

</div>

[MARY MALLAZZO]

Up

0

Down

::

David

Attached is the error returned when the initial login screen is cancelled, unfortunately it does not have a table name.

I do not see an option to clear the SQLLastUser, in the Dex.ini Settings window in GP Power Tools. Are you referring to the Configuration Maintanenance Window? Which table would it be?

Thank you!

Login-Issue-SQL-error-Nov-24.docx 43 KB Word Document - Click to view

Options

• Copy Download Link

[David Musgrave MVP, GPUG All Star, Community Legend]

Up

0

Down

::

Hi Mary

The code is trying to connect directly to SQL rather than access a table so that does not identify the product.

The ability to set the SQLLastUser to nothing is in the Dex.ini Configuration window, not the Dex.ini Settings window. It is a different window under the Setup menu.

However, the only way to identify the product causing the issue now would be to temporarily remove products from the launch file.

Once the extra login issue is fixed, you probably will not need to clear SQLLastUser.

Please update GP Power Tools to build 31.3 as there are a few issues fixed.

Regards

David

[MARY MALLAZZO]

Up

0

Down

::

Davide

Thanks for the suggestion. Unfortunately this is not a consistent issue. So removing the 3rd party from the launch file may not tell us anything.

We will install the update/hot fix to Power Tools this week.

Thank you!