During PowerPivot integration, I have found some issue which requires troubleshoot. Following are some errors and troubleshoot I have made
Problem Error message during test connection procedure “A connection cannot be made. Ensure that the server is running.”.
Error raised when you press “Test connection” during creation of new connection type. Resolution
Make sure that you have associated web application and correct service application proxy. A different connection type may be served by different service application proxy.