Collection status for MSSQL Management adapter in VCF Operations shows "Network error IOException: Connection refused"
Article ID: 445658
Updated On:
Products
VCF Operations
Issue/Introduction
- The MSSQL Management adapter instance shows below status
State : DownStatus : ErrorMessage : Caught an exception while collecting: Result returned the following error: [ Network error IOException: Connection refused ] for query: [ select top 1 name AS host from sys.servers order by server_id - Performing a "Validate Connection" against the MSSQL Management adapter fails with below error:
ErrorWait for response of task 'Test connection' with id '#####' is timed out for collector '<collector-FQDN/ IP-Address>'. - The "
/storage/log/vcops/log/adapters/MicrosoftSQLServerAdapter.log" reports below failure:ERROR MicrosoftSQLServerAdapter 8848 [ops@4413 threadId="167" threadName="Collector worker thread 7" instanceId="3633"] [(3633) com.bluemedora.exuno.DataProvider.error] - com.bluemedora.JdbcCore.JdbcConnectionManager: Network error IOException: Connection timed out MicrosoftSQLServerAdapter 8848 [ops@4413 threadId="167" threadName="Collector worker thread 7" instanceId="3633"] [(3633) com.bluemedora.exuno.DataProvider.error] - com.bluemedora.exuno.DataProvider: Diagnostic Result: ------------------------------- --- Test Connection Result --- ------------------------------ Overall Result: *** Failed! *** --- Critical Tests --- 'host' is valid Type: host Result: Passed Message: 'host' is valid. 'instance' is valid Type: instance Result: Passed Message: 'instance' is valid. 'port' is valid Type: port Result: Passed Message: 'port' is valid. 'ssl_config' is valid Type: ssl_config Result: Passed Message: 'ssl_config' is valid. 'username' is valid Type: username Result: Passed Message: 'username' is valid. 'password' is valid Type: password Result: Passed Message: 'password' is valid. 'use_ntlm_v2' is valid Type: use_ntlm_v2 Result: Passed Message: 'use_ntlm_v2' is valid. 'query_count' is valid Type: query_count Result: Passed Message: 'query_count' is valid. 'query_order_by' is valid Type: query_order_by Result: Passed Message: 'query_order_by' is valid. 'connection_pool_size' is valid Type: connection_pool_size Result: Passed Message: 'connection_pool_size' is valid. 'thread_pool_size' is valid Type: thread_pool_size Result: Passed Message: 'thread_pool_size' is valid. 'thread_timeout' is valid Type: thread_timeout Result: Passed Message: 'thread_timeout' is valid. 'exclude_events' is valid Type: exclude_events Result: Passed Message: 'exclude_events' is valid. 'exclude_log_based_events' is valid Type: exclude_log_based_events Result: Passed 'event_cutoff_time' is valid Type: event_cutoff_time Result: Passed Message: 'event_cutoff_time' is valid. 'collection_mode' is valid Type: collection_mode Result: Passed Message: 'collection_mode' is valid. Initialize db driver Type: driver_initialization Result: Passed Target Is MS SQL Server Type: is_ms_sql_server Result: Failed Message: Result returned the following error: [ Network error IOException: Connection timed out ] for query: [ SELECT @@version AS version ] --- Optional Tests --- 'excluded_queries' is valid Type: excluded_queries Result: Failed Message: 'excluded_queries' not specified. '' will be used. 'database_excl_pattern' is valid Type: database_excl_pattern Result: Failed Message: 'database_excl_pattern' not specified. ERROR MicrosoftSQLServerAdapter 8848 [ops@4413 threadId="167" threadName="Collector worker thread 7" instanceId="3633"] [(3633) com.bluemedora.vrealize.adapter.microsoftsqlserver.generated.CollectionResultCache.getResult] - Error performing collection: Caught an exception while collecting: Result returned the following error: [ Network error IOException: Connection timed out ] for query: [ select top 1 name AS host from sys.servers order by server_id ] com.bluemedora.exuno.common.ExUnoException: Caught an exception while collecting: Result returned the following error: [ Network error IOException: Connection timed out ] for query: [ select top 1 name AS host from sys.servers order by server_id ] at com.bluemedora.exuno.DataProvider.collect(DataProvider.java:373) ~[5-5.4.3.jar:?] at com.bluemedora.vrealize.adapter.microsoftsqlserver.generated.CollectionResultCache.getResult(CollectionResultCache.java:44) ~[sql_server_adapter.jar:?] - The VCF Operations Collector Node is unable to connect to the MSSQL Server on the default TCP port (1433).
curl -v telnet://<MSSQL-Server-FQDN/IP-Address>:1433 Trying <MSSQL-Server-FQDN/IP-Address>:1433 ... connect to <MSSQL-Server-FQDN/IP-Address> port 1433 from <VCF Operations Collector> port 58106 failed: Connection timed out
Environment
VCF Operations 9.x
Aria Operations 8.x
Cause
The issue occurred due to an underlying network/firewall blockage preventing communication between the VCF Operations Collector and the target MSSQL instance over the Default Instance Port: 1433 (TCP). The System Requirements
Resolution
To resolve this issue follow below recommendation
- Coordinate with your Network / Security team to ensure that firewall rules allow traffic from the VCF Operations collector nodes to the target MS SQL Server instances over the Default Instance Port: 1433 (TCP).
Note: If using dynamic ports, you will want to change the default port to SQL Server Browser Service UDP port 1434. - Validate and Save: Once connectivity is verified, navigate back to VCF Operations >> Administration >> Integrations.
Select the MSSQL adapter instance.
Click Validate Connection within the MSSQL adapter instance configuration page, and Save the settings. - Confirm the collection status is OK
Feedback
Yes
No
Powered by
