Need help with error - "login failed for user"

I am new to this company and they use this program, currently getting this error when running tasks on Easy morph Launcher, not sure how to fix

Hello @itsupport and welcome to the Community!

The error message in your screenshot contains the details that can help you with fixing the problem:

  • In your workflow, the import from a database is failing (something related to tickets, judging by the name of the table that contains the action)
  • The error returned from the database is "Login failed for user 'terrafirma'" which likely means that the user account configured in the database connector used by the action can't access the database.

To understand better how importing from a database works in EasyMorph, see also this tutorial article: EasyMorph | Loading data from a database

where or how would i change that User? Is it a sql user? AD?

It depends on how exactly access to the database is configured in your EasyMorph installation. The EasyMorph action that imports data from the database uses a pre-configured connector. Look at the connector settings. You can find the connector as explained in the screenshot below:

There are usually two options:

  1. ODBC
    If the database is accessed via an ODBC connection configured in Windows, then your database connector in EasyMorph will be of the ODBC type. In this case, you need to change the settings of the respective ODBC connection in Windows.

  2. Native connector
    If the database is accessed using a native connector in EasyMorph, then the authentication settings can be changed right in the connector.

Hey, sorry for the extremely late reply, I was able to get it working but don’t entirely understand why it broke, all i did was reset the connector, now the issue is back and resetting the connector isn’t working, but it indeed is the same error of login failed

How is your database connnector configured - is it ODBC or native?

let me get screencap

I just dont understand why when I send a test after setting up the connector again i get the test, but when I run the task in launcher it fails due to that user not being allowed, i also adopted this setup, it was done before I got to this company, I have the name of the database but wouldnt know how to get to it.

Hi @itsupport,

Can you please elaborate on why you posted screenshots of both Microsoft Exchange Online and Microsoft SQL Server connectors? Are you having issues with both of them?

I can see from the third screenshot that you have two connectors named "ProductionAnalysicsDb", one from a connectors repository and another from the project. Is it possible that you are resetting one of them, but actually using the other one? In most cases, it's not a good idea to have two connectors with the same name.

I’ll be completely honest, I adopted this system and do not know the first thing on how it works. This is outside my scope of operations.

@itsupport We won’t be able to help you without getting answers that clarify the situation. I’d suggest finding someone in your organization who can help with answers to our questions regarding your configuration of Microsoft Exchange and SQL Server.