Skip to main content

Sage 100 (On-Premise) - "Login failed due to logon trigger execution" Error Solution

Dylan Sewell avatar
Written by Dylan Sewell
Updated over 8 months ago

If you get an error when connecting that says:

  • “Login failed due to logon trigger execution”

then it means the .Net Core adapter needs to be given permission using the SAGE Database Administrator application.

How to fix this issue:

  1. Go to your Sage Database Administrator Application

  2. Go to "Advanced Settings" -> Advanced SQL Server Settings > "Edit Approvals"

  4. Ensure the following approvals have been selected:

    1. Core .Net SqlClient Data Provider

    2. Microsoft SQL Server Management Studio

    3. Microsoft SQL Server Profiler

    4. Microsoft SQL Server Reporting Services

  6. Click "okay"

This should resolve the issue you were experiencing.

Did this answer your question?