SharePoint 2010: Troubleshooting PowerPivot Integration

English:

During PowerPivot integration, I have found some issue which requires troubleshoot. Following are some errors and troubleshoot I have made

1. Problem  
       Error message during test connection procedure “A connection cannot be made. Ensure that the server is running.”.
   Description
       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.

2. Problem
      Error message during test connection procedure “Error 404 file can not be found.” .
   Description
      You are trying to create new BISM connection to XSLX file. Then you press “Test connection” , you receive Error 404 file can not be found.
   Resolution
      Make sure that PowerPivot Service Application has been created.

3. Problem
       During PowerPivot installation, you receive error message “Instance name is missing…”.
   Description
       During PowerPivot installation and after defining the configuration, you receive Instance name is missing .. error. And then you can not proceed the installation procedure.
   Resolution
        a. Close all SQL Setup application
        b. Restart PowerPivot installation. During Setup Role, select “Add SQL Server Database Relational Engine Services to this installation”.
        c. Proceed to the Feature Selection. (Ignore warning that you already have an SQL instance)
        d. You will notice that Instance name is no longer empty. Click back, to Setup Role, and at this time deselect “_Add SQL Server Database Relational Engine Services to this installation_”. 
        e. Then follow the rest of the wizard to install PowerPivot.

4. Problem
       During PowerPivot configuration, Configure SharePoint Dependencies failed.
   Description
       Configuration tools can not create unattended account for DataRefresh. The Configure SharePoint Dependencies section failed, so that configuration can not be completed.
   Resolution
       a. In Central Administration, goto Secure Store Service application management.
       b. Add New Target Application with default configuration
                   Target Application ID   : PowerPivotUnattendedAccount
                   Type   : Individual Ticket
       c. Run PowerPivot configuration again.
                       

I hope those experience will help solving your problem.