When launching SmartConnect after a new installation, receiving an error that says “eOne.SmartConnect.UI.External has stopped working” If you expand the “Problem Details” you get an event with a Problem Event Name of APPCRASH, and a Fault Module Name of clr.dll
This can be caused by two different scenarios.
1. The SmartConnect SQL user did not get created with the correct permissions.
OR
2. Some versions of NET Framework 4.5.1 have this issue per this article: .NET Framework 4.5.1 breaks ADO.NET connections to SQL Server
The solution for issue 1 is the following:
- Open up SQL Management Studio and go to the Security – Logins folder.
- Right click on the SmartConnect user and pick Properties
- Go to the “User Mapping” page and see what the SmartConnect user looks like. Their “Default Schema” needs to be “dbo”.
- If it’s set to anything else, click on the button at the end of the “Default Schema” column and type in “dbo” in the “Select Schema” window. Hit the “Check Names” button then hit the “OK” button.
- For the SmartConnect database, the SmartConnect user needs to be in the “public” and the “db_owner” role. Make sure both those checkboxes are checked before hitting the “OK” button.
- Now relaunch SmartConnect, the error should be resolved
The solution for issue 2 is to install the .NET Framework 4.5.2 which can be downloaded from here: Microsoft .NET Framework 4.5.2
