Tuesday , November 19 2024

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.

Ekrem Önsoy December 11, 2018 MSSQL

ERROR MESAGGE:

Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

EXPLANATION:

If you try to connect to your Windows account with a domain that you are not a member of, you will encounter this error.

SOLUTION:

You can connect with a SQL Server Login instead of Windows account.

Note: In this case, the SQL Server that you want to connect to needs to be set to “SQL Server and Windows Authentication mode”.

About Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply Cancel reply