Epicor E10 Administration Console 'MMC could not create the snap-in.' Error

I am sure someone else has the same problem. Our company is running Epicor E10.0.7.4 on Windows Server 2008. Everything installed fine, sometimes when you click on the icon for Epicor Administration Console it will come up with boxes saying "Unhandled Exception in Managed Code Snap-in".

At first, I thought there must be something wrong with the installation, I uninstalled and reinstalled the whole Epicor installation but still didn't fix the problem. One of the trick I tried that works for me is to SIMPLY run the console with "Run as administrator", or alternatively go to the properties of the short cut and enable "Run as Administator" in the Advanced button. I hope this can help someone.

Epicor E10 - How to use Excel data connection to connect to SQL Server

1. Open Excel and select Data Tab > From Other sources > From SQL Server

2. Enter the Server name and login details to the SQL server

3. Once connected, you can select the database and the particular table

4.Last step is to Save Data Connection File

5. Select the location where to put the data

6. The data come out is a table with the connection

7. If you create a Business Activity Query from Epicor E10, you can use it directly in Excel, simply right click onto the Table and Edit Query, then paste the BAQ.