MSSQLSERVER_18452

Applies to: SQL Server

Details

Attribute Value
Product Name SQL Server
Event ID 18452
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name LOGON_INVALID_CONNECT
Message Text Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.%.*ls

Explanation

The user attempted to log in with credentials that can't be validated. Possible causes are:

  • The login may be a SQL Server login but the server only accepts Windows Authentication.

  • You're trying to connect using SQL Server Authentication but the login used doesn't exist on SQL Server.

  • The login may use Windows Authentication but the login is an unrecognized Windows principal. An unrecognized Windows principal means that the login can't be verified by Windows. This could be because the Windows login is from an untrusted domain.

  • This issue might be related to consistent authentication where the trust level between domains might cause failures in account authentication or the visibility of Service Provider Name (SPN)s.

Similar problems can cause the less-specific error 18456.

User Action

If you're trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication mode.

If you're trying to connect using SQL Server Authentication, verify that the SQL Server login exists.

If you're trying to connect using Windows Authentication, verify that you're properly logged into the correct domain.

You can run the SETSPN and RUNAS commands to test the trust relationship independent of your application.