Notifications
Announcements
No record found.
eConnect OutGoing Service: Cannot open database "TWO" requested by the login. The login failed. Zillions of errors in the event log.
Naturally, the database does not exist in our installation. It must have been deleted in SQL Server but not in GP
If the TWO database shows in the GP system tables, but does not exist in SQL Server, I'd run the ClearCompanies script to remove it, that way nothing is seeing TWO mentioned and then looking for it, causing problems.
For example, this would cause GP Utilities to hang looking for the database should you try and do an upgrade.
Once you do that, then I'd see if that resolves or changes this eConnect Outgoing error.
Thanks
In my case the issue was that there remained references to sample database 'TWO' in the eConnect config files. I replaced those with references to our production database and the errors stopped filling up the event log.
In my case also, TWO already did not exist in [DYNAMICS].[SY01500]. Still, I am sure that ClearCompanies is invaluable in other cases. Can you point me to the latest version of the script? All I have been able to find is
www.gpug.com/.../DownloadDocumentFile.ashx
Thanks for your help.
The 'new' ClearCompanies script can be found at this article:
How to remove a company that is no longer being used - Dynamics GP | Microsoft Learn
The direct download link to it is here:
https://mbs2.microsoft.com/fileexchange/downloadfile.aspx?fileid=e1140f50-afc0-4a4d-83ef-e9826aff6d64
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
