000033015 - RSA ECAT Console Server cannot locate database after upgrade from 4.1.1.0 to higher versions

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033015
Applies ToRSA Product Set: ECAT
RSA Product/Service Type: Console Server
RSA Version/Condition: 4.1.1.0
Platform: Windows
O/S Version: Server 2012 R2, Server 2008 R2
IssueECAT Server fails to start up.
ECAT server no longer communicates with Database after upgrading from 4.1.0.2 to 4.1.1.0
The ECAT ConsoleServer.log throws the following error:
 
[6] 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)
SQL Error Code: 80131904

The ConsoleSever output window throws the following warning message:
 
Connecting to database ENTER_SERVER_AND_INSTANCE_NAME_HERE on ENTER_DATABASE_NAME_HERE ...

Screenshot of the ConsoleServerServiceOut.exe output:
Screenshot of the Error
Note:  The placeholder will only be listed in the Output window.
CauseThis is due to bug in the ECAT 4.1.1.0 Installer.
Instead of the database instance and database server name, the installer will insert placeholders.
ECAT server will use the placeholder value, instead of the real database name when trying to establish a connection to the database.

 
ResolutionNavigate to the <Drive>:\ECAT\Server folder.
There should be more then one copy of the ConsoleServer.exe.config file.
Find the one that has a placeholder value in it, and rename it to ConsoleServer.exe.config-not_working
If the good one has a different file extension, rename it to ConsoleServer.exe.config and re-start the ECAT Console Service.
 

Attachments

    Outcomes