Bee Pee

Client unable to establish connection; Encryption not supported on the client

Task – Hook up the cubes to the SSAS which have been created previously.

Errors on Processing the Cube

Client unable to establish connection; 08001; Encryption not supported on the client

A Connection could not be made to the DataSourceID of … Name of ..

Solution: Open Visual Studio ( am using VS2015 with SSDT) and follow the menu options as shown below

File > Open > Analysis Services Database
opencube

Enter the name of the Server and database which you want to import.

importcube

Expand the Cubes node in the solution explorer. Right click cube and choose Process. The cube processing gave the following errors

Client unable to establish connection; 08001; Encryption not supported on the client

A Connection could not be made to the DataSourceID of … Name of ..

The first part of first error made me think that maybe my connection details were not correct. Having checked the connection 4 or 5 times, I was puzzled as to what the error could be.
And the solution was as simple as changing the provider.

Change Provider

 

The second error was resolved by updating the password in Impersonation Information.

Add Impersonation

Leave a Reply

Your email address will not be published. Required fields are marked *