Showing posts from August, 2014

OLE DB error: OLE DB or ODBC error when deploying using Microsoft.AnalysisServices.Deployment.exe

When deploying an ASDatabase file using the Microsoft.AnalysisServices.Deployment.exe tool, you might get a cryptic "OLE DB error: OLE DB or ODBC error" message. The details message includes there was a problem connecting to one of the data sources.

I scratched my head for quite some time until I had a better look at the actual connection string. The server name was correct as well as the database name and security configuration. For example:

Provider=SQLNCLI11.1;Data Source=.;Integrated Security=SSPI;Initial Catalog=MyDatabase_Warehouse

At first I didn't notice the "Provider" part, but then I decided to strip the connection string to the bare minimum, and try again.

Data Source=.;Integrated Security=SSPI;Initial Catalog=MyDatabase_Warehouse

Surprisingly, it worked right away. But I honestly have no idea why it does not work if you specify the provider.
Maybe it is related to differences with the SQL client version installed on the machine that generated the pack…