Data engine on the HUB HA not able to connect to the DB.

Document ID : KB000008489
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

If you have a secondary Hub configured with the probe HA for a fail over purpose and after the primary hub fail and the HA hub got up and running and the probe data engine don't get the port and pid, check the log to see if you have a issue with the database connection:

[BasicCredentials::ReadConfiguration] Reading configuration from data_engine.cfg setup

[530940] de:    provider=SQLOLEDB

[530940] de:    server=sql,1433

[530940] de:    database=CA_UIM

[530940] de:    user=sa

[530940] de:    password=******

[530940] de:    parameters=Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI

[530940] de: ADO_Database::ADO_Database []

[530940] de: Base_Database::Base_Database []

[530940] de: Connection Interface OK - ADO Version: 6.3

[530940] de: Recordset Interface OK

[530940] de: Command Interface OK

[530940] de: [main] Open - 1 errors

 [530940] de: (1) Open [Microsoft OLE DB Provider for SQL Server] Login failed for user 'DOMAIN_NAME\SERVER_NAME\$

[530940] de: Database script - processing 3 database scripts

[530940] de: Database script - Module: [ NIS_BASE            ], File: [scripts\sqlserver_nis_base_create.sql], run check: [yes], run script: [ no]

[530940] de: COM Error [0x800a0e7d] Unknown error 0x800A0E7D - [ADODB.Recordset] The connection cannot be used to perform this operation. It is either closed or invalid in this context.

[530940] de: COM Error [0x800a0e7d] Unknown error 0x800A0E7D - [ADODB.Recordset] The connection cannot be used to perform this operation. It is either closed or invalid in this context.

 

 

Environment:
Secondary Hub with probe HA configured with Microsoft SQL server
Cause:

The probe data engine parameters is configured with Integrated Security=SSPI

parameters = Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI

This parameters is the same as Integrated Security=true;

This parameters force the secondary hub to connect to the Database as windows user authentication.

Resolution:

Remove the Integrated Security=SSPI from the parameters on the data_engine.cfg on the HA hub.

change this line:

parameters = Network Library=dbmssocn;Language=us_english;Integrated Security=SSPI

to

parameters = Network Library=dbmssocn;Language=us_english

Restart the data_engine probe.

Additional Information:

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/connection-string-syntax