Login timeout expired during cube processing

Products

• Information Centric Analytics

Issue/Introduction

The Risk Fabric cube processing step (16) of the nightly RiskFabric Processing job fails in a two-tier environment in which both SQL Server and SQL Server Analysis Services (SSAS) are hosted on the same server. Both services are running and Named Pipes are enabled for the SQL Server service. The following error message is logged by the SQL Server Agent:

OLE DB error: OLE DB or ODBC error: Login timeout expired, HYT00, A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online., 08001, Named Pipes Provider: Could not open a connection to SQL Server [2]. , 08001.

Environment

Version : 6.x

Component : RiskFabric Processing

Cause

The RiskFabric relational database is hosted in a named instance of the SQL Server service but the RiskFabric multidimensional database's data source connection string is configured to point to the default SQL Server instance.

Resolution

Update the connection string by following this procedure:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Analysis Services server hosting the RiskFabric OLAP cube
3. In Object Explorer, navigate to Databases > RiskFabric > Data Sources
4. Right-click the RiskFabric data source and select Properties
   The Data Source Properties - RiskFabric window will open
5. Under the General heading, select the Connection String and click the ellipsis to the right of the string
   The Connection Manager window will open
6. From the Provider dropdown menu, select Microsoft OLE DB Driver for SQL Server
7. Enter the name of the server and instance name hosting SQL Server and the RiskFabric relational database
   NOTE: Specify the instance name after the server name with a trailing \<instance-name>
8. From the Initial catalog dropdown menu, select the RiskFabric relational database
9. Click the OK button to save your settings and close the Connection Manager window
10. Click the OK button to save your settings and close the Data Source Properties - RiskFabric window