The following generic connection error message is logged while executing the job step Risk Fabric cube processing (16) of the RiskFabric Processing job, or while executing job steps 13 (Process DIM Measures and Dimensions) and 15 (Process Event Scenario Measures and Dimensions) of the RiskFabric Intraday Processing job:
<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3239182436" Description="Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'RiskFabric', Name of 'RiskFabric'." Source="Microsoft Analysis Services" HelpFile="" />
NOTE: this connection error differs from the invalid username or password error documented in KB article OLE DB error: Username or password is incorrect.
This error occurs in an environment matching the following conditions:
RiskFabric
relational database is hosted in a named instance of SQL Server.RiskFabric
relational database specifies both the server and instance name hosting the database, rather than the fully qualified domain name (FQDN).1433
is open on the server hosting SQL Server.Release : 6.x
Component : Microsoft SQL Server
The default instance of the Microsoft SQL Server database engine listens for TCP connections on port 1433
. Named instances use dynamic ports. In an environment in which specific ports or port ranges are restricted by firewall rules, the use of a named instance in the data source connection string causes a connection to be made using dynamic ports, resulting in connectivity failures even though port 1433
has been explicitly opened for communication between the two servers and only one database engine instance exists on the SQL Server.
Modify the data source connection string by following this procedure:
RiskFabric
OLAP cubeRiskFabric
relational database