Lost connection to SQL Server
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.
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.
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.
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?
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.