Using the Excel AddIn and attempting to run a SmartConnect map. Receiving an error back that says “Web request did not return any data. Verify the mapID is correct and try again.” The error message in the Excel AddIn looks like this:
This means you do not have the ASP.NET components installed on your IIS server.
1. Go to Start – Administrative Tools – Server Manager
2. Click on “Add roles and features”
3. Click on Features
4. Expand the .NET Framework 3.5 Features and .NET Framework 4.5 Features. At the very minimum mark all the components shown in the screenshot below.
5. After installing the features restart the SmartConnect WCF service by going into IIS Manager highlighting the service and pressing the restart button on the right.