다음을 통해 공유

SSAS Troubleshooting: OLE DB / ODBC error - A connection could not be made to the data source

  • 아티클

Applies to

 SQL Server Analysis Services, tabular or multidimensional databases.

Error

Full error message text, with placeholders representing actual object names:

"OLE DB or ODBC error.

A connection could not be made to the data source with the DataSourceID of <object-guid>, Name of <object-name>.

An error occurred while processing the partition <partition-name> in table <table-name>. The current operation was cancelled because another operation in the transaction failed."

This is generic data provider error that occurs during the final step of a table import, or during processing.  For tabular modeling in particular, this error can seem especially unexpected when it occurs after table data is previewed and filters are applied.

Causes

If you get this error, check for the following possible causes:

  • Database permissions are not valid. Importing or processing data is an operation that obtains security context information from the Impersonation Option page of the Data Source. Depending on which option you selected, data retrieval is requested as either the service account, the current user, or stored Windows user credentials. Whatever account is used for data retrieval must have read permissions on the external data source.
  • Data Provider version or bit-level. This error is known to occur when the connection is from a 32-bit client application, using 32-bit data providers, and the target server is 64-bit. The solution is to install both 32-bit and 64-bit data providers.

See also

For a list of all SSAS errors documented in this WIKI, see http://social.technet.microsoft.com/wiki/contents/articles/17991.analysis-services-ssas-error-messages.aspx