Regresar
-
Título
Connection error: "Unknown error code:08001:NTLM mutual authentication failed." -
Descripción
Connection error: "Unknown error code:08001:NTLM mutual authentication failed." -
Causa
The root cause for the NTLM message is within Windows networking & Environment. It is advised to use the PING and IPCONFIG commands to verify that the IP address that the client is using for the server is correct or if there are multiple IP addresses. If the IP address is not correct, you must determine where the incorrect address comes from, and then contact your network administrator. -
Resolución
RESOLUTION 1:Use IP address for monitoring the SQL Server host and both SQL Server or Windows domain account authentication can be used in the hostname field in the Agent Status Properties of the SQL Server agent and the Host Name Override field of the WindowsAgent.Note: The hostname may be replaced by the IP address in the database, hosts, and infrastructure dashboard with this change. An alternative may be to update the hosts file on the FglAM to include the IP address, servername, and fully qualifield domain name.RESOLUTION 2:Execute SQL Server Management Studio when querying "select @@servername". Use this specific name output for in the hostname field of the Agent Properties monitoring the host.RESOLUTION 3:Use the SQL Server authentication instead of Windows Authentication (domain/user )in the properties of the monitored agent.