Cannot connect to SmartConnect after password change
Aaron asked 10 years ago
The password for the "SmartConnect" account in SQL environment of Great Plains was changed and now end users cannot connect to map ….
Is the application password for the SMARTCONNECT account hard-coded?
Does this have to do with the initial installation of eConnect?
Is the application password for the SMARTCONNECT account hard-coded?
Does this have to do with the initial installation of eConnect?
Aaron, you can use this KB article to get the SmartConnect password. The KB article talks about a different issue but the fix is the same. The SmartConnect password is set the first time you install it on the server so if you use a different password during the install on another machine it puts the wrong value in the registry. You can also uninstall and reinstall with the right password. http://www.eonesolutions.com/help-article/eone-smartconnect-service-starts-and-stops/
Lorren –
This is the error the end user gets when they attempt to map:
NHibernate.TransactionException: Begin failed with SQL exception —> System.Data.SqlClient.SqlException: Login failed for user 'SmartConnect'.
Any thoughts or suggestions?