Skip to content


Lost connection to SQL Server

Tom asked 5 years ago
I am in the process of evaluating SmartConnect and am working through some installation issues.  My testing  is being done in our DEV environment, which requires me to periodically refresh from production.  We just did our first refresh, and I can no longer start SmartConnect, getting the message: Could not log into the SQL server.  Login failed for user ‘SmartConnect’.  Obviously the SmartConnect install made some changes to the DEV server that were lost in the refresh.  How can I reestablish connectivity so I can proceed with my eval?
Ethan Sorenson Staff answered 5 years ago
When SmartConnect is installed it creates a SQL user named SmartConnect that is used for connections to the SmartConnect database. So either the user no longer exists in SQL, or the password has changed. We have a help article for troubleshooting this error.
Login failed for User SmartConnect
Tom answered 5 years ago
Thanks Ethan, the user ‘SmartConnect’ was lost in the refresh from prod.  I recreated is and that message no longer appears.  
Unfortunately it was replaced by this message: 
Could not log into the SQL Server.  Cannot open database ‘SmartConnect’ requested by the login.  The login failed.  Login failed for user ‘SmartConnect’.
Makes sense.  When the refresh from prod was done, it wiped out everything SmartConnect did to the SQL server.  
Is there a way to re-do all the changes simply?  Uninstall and reinstall SmartConnect?  anything?  My testing has come to a halt until I get through this.
Ethan Sorenson Staff replied 5 years ago

It is hard to say what would fix this error without seeing your instance, but I would say the config file still isn’t pointed to the right database. Check in SQL that there is a database named SmartConnect. If there isn’t, you can create a new database in SQL named SmartConnect, and make the SmartConnect user the owner of that database. Then when you open SmartConnect system maintenance will run and create all of our tables in the database.

Tom replied 5 years ago

Again …thanks I created the database and SmartConnect launched and created tables.

So I know that during testing, if I need to refresh DEV I will need to recreate the SmartConnect user and the SmartConnect database to resume. Maps get lost though…. Are they easy to back up and restore?

Ethan Sorenson Staff replied 5 years ago

In the future you can either backup the SmartConnect database so you can restore it after the server refresh, or you can use the SmartConnect import/export feature.

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