NetVault Plug-in for SQL Server 14.0 - User Guide

AlwaysOn Discovery Messages

This topic describes some of the system generated alerts or events that help to identify and respond to the changes.

Failed to login to SQL Instance message indicates that the attempt to establish a connection to the specified SQL Server instance using ODBC (Open Database Connectivity) has failed. This failure occurs during the execution of the driver connect functionality, which is responsible for connecting with the SQL Server instance.

NOTE: Displays : In NetVault binary logs Interface : Browse, Backup Log Level : LogError Mitigation : Ensure to input appropriate ODBC driver name

Following are some of the possible causes listed below:

Failed to login to SQL Instance message indicates that the connection attempt to the SQL Server instance is unsuccessful. The code provides detailed logging to help diagnose the issue. The reasons for failure could be due to invalid credentials, network issues, or SQL Server configuration problems. Follow the troubleshooting steps to identify and resolve the root cause of the failure.

NOTE: Displays : In NetVault binary logs Interface : Browse, Backup Log Level : LogJobMessage Mitigation : Use Plug-in configure menu to set the environment as AlwaysOn Availability Groups

Unable to determine if this is an AlwaysOn Availability Cluster or not message displays after the SQL Server Plug-in is unable to query using ODBC APIs the SQL Server instance to determine whether AlwaysOn Availability Groups are enabled.

The message indicates that the Plug-in for SQL Server query to check the AlwaysOn property is not successful. When the query is not successful, the check for the AlwaysOn property is deferred and applied using SQL Server queries. The obatined results are recorded in the NetVault Database.

Alternatively, the AlwaysOn property can be configured in the Plug-in for SQL Server. The configured value takes preference.

The Windows service for instance %s on host %s does not run, unable to check for AlwaysOn support.

NOTE: SQL Server specific APIs that require SQL Server must be active.

NOTE: Displays : In NetVault binary logs Interface : Browse Log Level : LogJobMessage Mitigation : Use Plug-in configure menu to set the environment as AlwaysOn Availability Groups

The message The Windows service for instance %s on host %s appears not to be running, unable to check for AlwaysOn support indicates that the SQL Server instance's Windows service might be currently not running or not accessible using ODBC queries. As a result, the Plug-in for SQL Server cannot query the SQL Server instance for the AlwaysOn property. The message is informational and serves as a diagnostic indicator rather than an error. It highlights a condition that might require attention but does not necessarily stop the program's execution or functionality.

This message serves as a diagnostic indicator that the SQL Server instance's service is not running, preventing AlwaysOn Availability Groups checks.

NOTE: Displays : In NetVault binary logs Interface : Browse Log Level : LogJobMessage Mitigation : Use Plug-in configure menu to set the environment as AlwaysOn Availability Groups

This message serves as a diagnostic indicator that the SQL Server instance's service is not running, preventing AlwaysOn Availability Groups checks.