Skip to content
+1-888-319-3663

COMMUNITY FORUM

Login failed for user SmartConnect

Terry Dickens asked 6 years ago
We are evaluating SmartConnect.  I like what I see so far.  We installed SmartConnect on a server and I’m able to log in.  We don’t have the GP Client on this server.  But we do have EConnect.
 
So I installed the SmartConnect User Interface on my laptop.  When I try to run SmartConnect, I get this error: “Could not log into the SQL Server Login failed for user “SmartConnect”.  Why does it think I’m user “SmartConnect”.  Shouldn’t it be logging in as my real userid?  When I remote into the server, it logs me in with my userid.  How do I set what userid SmartConnect logs in as?
Terry replied 4 years ago

I had this same issue after installing .NET 4.6.1, then rebooting …. I thought it was a .NET version issue. Turns out, my Smartconnect dbase was in a “recovery pending” state. I needed to update my Sql Service account password for Smartconnect dbase. I updated it, restarted service, and dbase was up and running, so was Smartconnect.

Answers
Patrick Roth Staff answered 6 years ago
Terry,
Why does it think I’m user “SmartConnect”. 
Because that is the user that the application uses to manage the connection to the SmartConnect database – not your Windows Auth creds.
Shouldn’t it be logging in as my real userid? 
No, it uses the SmartConnect user that our install creates to log in and connect to the SmartConnect database.  Then it validates that your windows user is included in the Security table for SmartConnect.
How do I set what userid SmartConnect logs in as?
When you did your SmartConnect client install, it asked you the password for the SmartConnect user.  If the user didn’t exist, it would create the user in SQL with that password.  Otherwise it uses that for login.  So it is possible you entered the wrong password and not the install uses that.
To fix it, you can run the eOne.SmartConnect.Config.exe application (run as administrator) and it’ll reset the password.
The other possibility is that you don’t have .net 4.5 loaded on your machine.  You will immediately get a SQL Login error if not.
patrick 
 
Terry Dickens replied 6 years ago

Thank you. This answered my question.

Aaron replied 5 years ago

Patrick – When I run the SmartConnect Configuration tool as Administrator (eOne.SmartConnect.Config.exe), I do not see how to reset the password. I can “test connection” and when I enter the correct password, it lists my MSSQL Server. The only way I know to change the SmartConnect SQL password is to change the user’s password through SQL Management Studio. Have I misunderstood the instruction?

I am working to resolve an error in my event viewer:

: SmartConnect could not be loaded:
Login failed for user ‘SmartConnect’.

Thank you for the clarification

Lorren Zemke Staff replied 5 years ago

Aaron, If you need to change the SmartConnect user password, it has to be done in SQL Management Studio. Then you can use the Configuration Tool to update each machine where SmartConnect is installed.

Tom replied 5 years ago

What happens when the workstation is running Windows 10, which comes with .NET Framework 4.6? We’re trying to get that working right now. We cannot install 4.5, because a later version already exists. And it seems that SmartConnect does not recognize 4.6.

CQuigley answered 4 years ago
I was getting this error ‘Error refreshing SmartConnect session factory : could not load an entity: [eOne.SmartConnect.Engine.Setup#1]…’, also the SQL log had ‘login failed for user ‘SmartConnect‘….’
 I had changed the password in the prior month using eOne.SmartConnect.Config.exe application.  All maps had worked when manually run.  
On the first of this month the scheduled map did not run.  I restarted the eOne SmartConnect Service and scheduled maps are running as expected now.
Terry answered 4 years ago
I had this same issue after installing .NET 4.6.1, then rebooting …. I thought it was a .NET version issue. Turns out, my Smartconnect dbase was in a “recovery pending” state. I needed to update my Sql Service account password for Smartconnect dbase. I updated it, restarted service, and dbase was up and running, so was Smartconnect.

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