Skip to content
+1-888-319-3663

COMMUNITY FORUM

Login Failed

John Ellis asked 1 year ago
Hi:
Although I’m logged in as a SmartConnect administrator, I cannot run any maps due to the error “Login failed”.
I have given my login in SQL access to the required roles in the databases.
The weird thing is that the login failure message is not ever referencing my A/D login.  Rather, it mentions the name of the server that I’m trying to run these maps on.
Any ideas?
Thanks!
John
Answers
Ethan Sorenson Staff answered 1 year ago
John,
There are a few different locations that the SQL login could be referenced that is not using a valid login.

  1. If your destination is GP, then you can check the SmartConnect > Setup > Setup > Dynamics GP Connector.

    1. Check that the account assigned to the eConnect windows service on the current machine is a member of DYNGRP in SQL. 

    2. Make sure it is set to use a dedicated SQL login and not inherit the current AD user.



  2. If you are using an ODBC data source check if that is defined in the map to use a SQL login.

    1. It may be using an ODBC default, which can be modified here: SmartConnect > Maintenance > Generic Connector > ODBC Data Source



  3. If your map has any tasks or additional columns using an MSSQL connection you will want to check that these are also using a defined SQL login.

    1. These may be using an MSSQL default, which can be modified here: SmartConnect > Maintenance > Generic Connector > MSSQL Defaults




If you would like to submit an answer or comment, please sign in to the eOne portal.