MSOLAP initialization properties error

Products

• Information Centric Analytics

Issue/Introduction

When attempting to update the service account password used for the security context of the RiskFabric_ASDB linked server by following the procedure documented in knowledgebase article Update ICA services credentials and data source credentials, the following error message is displayed:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".
OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB" returned message "The following system
error occurred: ". (Microsoft SQL Server, Error 7373)

The same error may also be triggered when opening certain dashboards in the Risk Fabric console. The console will display a generic error message similar to the following:

Request Failed

The request failed. Click 'OK' to close this window or Refresh to refresh the page.
Try again or contact the site administrator

Error ID: <ID>

Querying the error ID in the Log_Client table returns an error message like the following:

Status: 400 StatusText: Bad Request response

The Risk Fabric server log will also contain an entry similar to the following with a timestamp corresponding to the time at which the dashboard threw the original error:

[99:ERROR] LoggingExceptionFilterAttribute.OnException() https://<hostname>/api/DIM/GetIncidentAndMatchCountsOverTime
System.Data.SqlClient.SqlException (0x80131904): Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB".

Environment

Version : 6.x

Cause

Although the exact underlying cause of this error is not known, it appears to concern the interoperation of the Remote Desktop Protocol (RDP) and Kerberos authentication in environments in which Kerberos constrained delegation is in use.

Resolution

If you have encountered this error while attempting to update the RiskFabric_ASDB linked server's credentials, connect to the server hosting the Microsoft SQL Server instance in which the RiskFabric relational database is installed by using an RDP client and run SQL Server Management Studio (SSMS) as an administrator on that server, rather than connecting to the database through an instance of SSMS running on a remote system.

If you have encountered this error while attempting to view dashboards in the Risk Fabric console, ensure all RDP sessions are closed on the server hosting the RiskFabric relational database. If that does not resolve the error, contact your AD administrator or Microsoft for assistance.

Additional Information

Sample statement for querying the Log_Client table (replace <error_ID> with the error ID displayed in the Risk Fabric console):

SELECT Detail, EntryDateStamp FROM RiskFabric.dbo.Log_Client WITH (NOLOCK) WHERE LogClientID = <error_ID>;