SSIS Analysis Services Connection Error In The Transport Layer of initializing provider

Question

I'm trying to connect to an analysis services database in SSIS using a specific user name and password.

I'm getting the message

error in initializing provider. AN error was encountered in the transport layer.

The peer prematurely closed the connection.

Any ideas?

Answer 1

Are your rights properly set up in Analysis Services? Assuming when you create the new AS connection through SSIS you click the 'Edit' button in the Add New Analysis Services Connection window and type in your username and password it should work. Are you able to log in through SQL Management Studio?

Answer 2

I have the same issue. I am able to run the SSIS package via a specific user name but it fails when I runs. Both the accounts are Server Admins right on the SSAS box. I am not sure why SSIS is not able to delegate authentication. I am using ADO.NET to connect to SSAS server.

Answer 3

Try installing/reinstalling Microsoft OLE DB Provider for Analysis Services 9.0 (for 2005) or Microsoft OLE DB Provider for Analysis Services 10.0 (2008)