Metric Collector failure post-migration

Products

• Information Centric Analytics

Issue/Introduction

After migrating an instance of Information Centric Analytics (ICA) to a new server, the Metric Collector job step in the nightly RiskFabric Processing job fails and the following error message is logged in the RiskFabric.Collector log and in the SQL Server Agent history log:

Unhandled Exception: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception: Access is denied

Environment

Release : 6.x

Component : Metric Collector

Cause

The RiskFabricCollector executable's connection string points to the wrong database server.

Resolution

Update the connection string by following this procedure:

1. Open File Explorer on the new database server
2. Navigate to the Database Utilities folder
   
   NOTE: The default path is %SystemDrive%\Program Files\Bay Dynamics\Database Utilities
   
   
3. Open the file RiskFabricCollector.exe.config with Notepad or a text editor of your choice
4. Locate the <connectionStrings> key and edit the connectionString Data Source value to point to the correct database server
5. Save and close the file