Login failed for User SmartConnect

When trying to log into SmartConnect we receive an error stating, Login failed for user ‘SmartConnect’. This may occur trying to log into SmartConnect, running a map, trying to start the SmartConnect Windows Service. Basically, the error could occur anywhere in SmartConnect.

The solutions in this article pertain to SmartConnect 20.16 and newer.

During Login

If the error message, Could not log into the SQL Server login failed for user ‘SmartConnect’., appears, this would be an issue with the SmartConnect user password that was entered during installation on the current machine. There are two methods available to correct this error.

1. Reset the SmartConnect user password in SQL Management Studio to match what was used during the installation on this machine.
   1. If there are other machines where we can log into SmartConnect, then the following step will need to be used on those machines.

    

2. Go to the SmartConnect Configuration application. Browse to the C:/Program Files (x86)/eOne Solutions/SmartConnect folder.
   1. Right Click on the eOne.SmartConnect.Config.exe application and choose Run as Administrator
   2. Fill in the SmartConnect MSSQL Server, SmartConnect MSSQL Database, SmartConnect MSSQL User, SmartConnect MSSQL Password and click Test Connection.
   3. If the right password is entered, the rest of the configuration data will fill in the window.
      1. Click Save Changes to update the configuration file on this machine.

         

   4. If the wrong information is entered, the error ‘Failed to connect to the SmartConnect database, please check the entered credentials and try again.’. You will need to enter the correct information to reset the password on this machine using the Configuration tool or refer to step 1 above to reset the SmartConnect password using SQL Management Studio.

       

      

   5. If other machines are having the same issue, you can copy the eone.SmartConnect.Setup.Config to the other machines SmartConnect folder without having to run the Configuration utility.

       

During Map Execution

If this error appears while running an integration, it means the SmartConnect user has been set as credentials within the map. This could be on the data source for an ODBC connection or on the destination, if it’s a SQL Table or SQL Stored Procedure. Additionally, it could be a Task, calculated column or Dynamics GP Rolling Column that may throw this error, if the SmartConnect user password is incorrect. The only time this will occurs on a Dynamics GP Rolling Column is if the SmartConnect user is set as the Credentials in the Dynamics GP Connector. You will need to update all areas this user is set within the map or modify the password in SQL Management Studio to match the password used here. Be sure to check any MSSQL Default, ODBC

NOTE: eOne does not recommend using the SmartConnect user for purposes other than connecting to the SmartConnect database itself.

eOne SmartConnect Service

When trying to start the eOne SmartConnect Service, we receive the message ‘The eOne SmartConnect Service service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.’

The only method for checking to what may cause this issue, is to go to Administrative Tools->Event Viewer on the machine where the scheduling service is being started. Expand the Applications and Services Logs folder. Open the SmartConnect Event Log.

Look for this error, ‘Failed to create the SmartConnect session factory: Login failed for user ‘SmartConnect’.’

Use the steps above to open the configuration file and reset the correct SmartConnect user password on this machine.

Web Service

If you are receiving the login error on either the SmartConnect WCF Web Service or SmartConnect Web Service, you can use the same SmartConnect Configuration utility mentioned above to update the configuration file for each web service.

As previously mentioned, go to the SmartConnect Configuration application. Browse to the C:/Program Files (x86)/eOne Solutions/SmartConnect folder.

1. Right Click on the eOne.SmartConnect.Config.exe application and choose Run as Administrator
2. Fill in the SmartConnect MSSQL Server, SmartConnect MSSQL Database, SmartConnect MSSQL User, SmartConnect MSSQL Password and click Test Connection.
3. If the right password is entered, the rest of the configuration data will fill in the window.
4. Click on the ellipsis for either of the web services and find the configuration file.
   1. The WCF web service configuration file, by default, will be in the C:/Program Files (x86)/eOne Solutions/wcf folder.
   2. The Web service configuration file, by default, will be in the C:/Program Files (x86)/eOne Solutions/www folder.