Voltar
-
Título
Cannot setup OS monitoring for database agent to Windows server "OS validation failed " AND "A connection could not be established" -
Descrição
When adding operating system (OS) monitoring for SQL Server agent. it fails with error : A connection could not be established.
In Management Server log also reported this:VERBOSE [cwspsfjxrw-2] script.system:dbwc_mssql_installer.validateOS - Parsed result of callback [validateOS] on agent DBSS-Installer-, session 1463486387320, request 1463486445680:--------- OS Validation results for session 1463486387320 ------------ Instance ---OS connection = Invalidused Physical Host name = NoFinished OS validation. -
Causa
CAUSE 1
Login issue
CAUSE 2
RPC server is unavailable due to a firewall port blocking the connection or the service not running on the remote host.
CAUSE 3
Missing permissions to connect from a Linux FglAM (Foglight Agent Manager) to a Windows host using WinRM -
Resolução
RESOLUTION 1Ensure that the OS credentials entered into the agent installer or validation utility are valid and are in the DOMAIN\USER format.RESOLUTION 2Review KB94039 RPC Server is Unavailable (0x800706ba)
RESOLUTION 3
Configure the Linux FglAM to connect in Powershell:
Set-WSManQuickConfig -force
Set-item WSMan:\localhost\Client\AllowUnencrypted true
Set-item WSMan:\localhost\Client\Auth\Basic true
Set-item WSMan:\localhost\Client\Auth\Negotiate true
Set-item WSMan:\localhost\Client\Auth\kerberos true
Set-item WSMan:\localhost\Client\TrustedHosts "*" -force