Login failed for user SmartConnect
Terry Dickens asked 7 years ago
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?
Patrick Roth Staff answered 7 years ago
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 7 years ago Thank you. This answered my question.
Aaron replied 7 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 7 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 6 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 6 years ago
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 6 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.