Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB"

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

The following error is captured in the Information Centric Analytics (ICA) application server log (w3wp_RiskFabric.<yyyyMMdd>.log) when accessing the Events > Data In Motion dashboard, or when loading other dashboard widgets backed by MDX queries:

Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".

Environment

Release : 6.x

Component : Dashboard

Cause

Errors in the application logs referencing the RiskFabric_ASDB linked server can be caused by either of the following conditions:

1. The linked server's security context is using an inherited identity
2. The MSOLAP driver is damaged or has been removed

Resolution

To resolve this error, first determine which of the two conditions described above are applicable to your situation. Follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric database
3. In Object Explorer, navigate to Server Objects > Linked Servers
4. Right-click the linked server RiskFabric_ASDB and select Properties
   The Linked Server Properties - RiskFabric_ASDB window will open
5. In the Linked Server Properties window, select the Security page
6. For a login not defined in the local server login list on this page, select the option for connections to Be made using this security context
7. Enter the credentials of the ICA service account, or of an account that is a members of the Administrator group on the SQL Server Analysis Services (SSAS) server
8. Click the OK button to save your settings and close the Linked Server Properties window

If the error persists after following this procedure, re-install the MSOLAP driver for your installation of SQL Server.