none
PowerPivot Error "Failed to connect to the server. Reason: Unspecified error" when importing other files

    Question

  • I have been getting the error below on a regular basis when attempting to import Excel, Text, or Access files.

    I'm running Office 2010 (SP1), and PowerPivot (SP1). After reading a similar thread I reinstalled PowerPivot. It worked until I closed Excel. Now it recuses to allow import or update of these files. I really need it to work. Anyone have an solution or even something to try - other than uninstalling and reinstalling PowerPiviot everytime I need to import or refresh files?

    Thanks,

    ============================
    Error Message:
    ============================

    Unspecified error
    ----------------------------
    Failed to connect to the server. Reason: Unspecified error

    ============================
    Call Stack:
    ============================

       at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
       at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.OleDb.OleDbConnection.Open()
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
    ----------------------------
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.InitializeConnectionObject(String connectionIdentifier)
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open(String& connectionIdentifier)
       at Microsoft.AnalysisServices.BackEnd.RelationalDataSourceConnection.Open()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.TestConnection()
       at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)

    ============================

    Thursday, May 15, 2014 6:01 PM

Answers