SCSM DWASDatabase - Can't Process Cubes - Encryption not supported on the client 08001

  • Article

SSAS processing error:

Client unable to establish connection; 08001;

Encryption not supported on the client.; 08001

In case the DWASDatabase has Data Sources set to SQL Server Native Client 11.0

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

**
We actually want to change that to be using** Microsoft OLE DB Provider for SQL Server

Provider=SQLOLEDB.1;Data Source=SERVERNAME;Integrated Security=SSPI;Initial Catalog=DATABASENAME

Then you must choose a server and appropriate database for each data source. By default, you'll want the data source to be the same name as the database.

CMDWDataMart

  • SERVERNAME
  • CMDWDataMart

DWDataMart

  • SERVERNAME
  • DWDataMart

OMDWDataMart

  • SERVERNAME
  • OMDWDataMart

Save each DataSource, AND OPEN EACH ONE ONCE MORE BECAUSE:

YOU MUST ENTER THE PASSWORD FOR THE IMPERSONATION ACCOUNT AGAIN ON EACH DATA SOURCE AFTER DOING THE ABOVE!