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
Enter the name of the Server and database which you want to import.
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.
The second error was resolved by updating the password in Impersonation Information.
