Connection error: "Unknown error code:08001:NTLM mutual authentication failed." (4307335)

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Connection error: "Unknown error code:08001:NTLM mutual authentication failed."
Description

Connection error: "Unknown error code:08001:NTLM mutual authentication failed."
Cause

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.
Résolution

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.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 6/8/2020
Dernière mise à jour le : 5/7/2023

Titre