戻る
-
タイトル
SQL Server agent doesn't collect data with "Login failed" error and "SQL-Server Error Code = 18456. SQL state : 28000" -
説明
One of the SQLServer agents doesn't collect data.
The DBSS agent log displays an exception similar to the following:
AgentConnectionException:Failed to establish a SQL-Server JDBC connection protocol to Host [server1.mycompany.com\DEFAULT_INSTANCE], user account [foglight] . Reason : [[DataDirect][SQLServer JDBC Driver][SQLServer]Login failed for user 'foglight'.- Profile:MSSQLProfile{host='server1.mycompany.com', instance= 'DEFAULT_INSTANCE', username='foglight', authType= 'SQL_SERVER', port= '1433' useNTLMv2= 'false', socketTimeout= '900', secureConnection= 'REQUEST' }]. . [SQL-Server Error Code = 18456. SQL state : 28000]
-
原因
The database logon account supplied is in error or cannot be processed by the security providor:
- The Windows login is restricted either by exclusion or inheritance(group or policy), or role association
- The Windows login is not added to the SQL Server
- The Windows Login is disabled.
- The login Username is incorrect (type, missing domain)
- The login Password is incorrect (typo, expired, length)
- lnstance name is incorrect (check for multiple instances on same host)
- Domain Trust missing
- NTLM version mismatch
- Firewall restriction or network communication issue (DMZ, hosted environment, geolocated datacenters)
-
対策
Confirm the account is active and working and the credentials are what is expected to process the login. Test the login by using both a remote host and from the instance itself. Resolve the account issue and reactivate the agent with the correct working credentials.