![Login failed for user “user”. Reason: The account is disabled (Microsoft SQL Server ,Error: 18470 ) | Code! Code! Code! Login failed for user “user”. Reason: The account is disabled (Microsoft SQL Server ,Error: 18470 ) | Code! Code! Code!](https://piusnjoka.files.wordpress.com/2013/06/server_properties_to_enable_mix_mode_authetication.png)
Login failed for user “user”. Reason: The account is disabled (Microsoft SQL Server ,Error: 18470 ) | Code! Code! Code!
![permissions - Linked Server using Impersonation fails SSMS GUI Connection test but sp_testlinkedserver succeeds - Database Administrators Stack Exchange permissions - Linked Server using Impersonation fails SSMS GUI Connection test but sp_testlinkedserver succeeds - Database Administrators Stack Exchange](https://i.stack.imgur.com/a9IeP.png)
permissions - Linked Server using Impersonation fails SSMS GUI Connection test but sp_testlinkedserver succeeds - Database Administrators Stack Exchange
![SQL query to linked server error: "Msg 18456, Level 14, State 1, Line 901 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - Microsoft Q&A SQL query to linked server error: "Msg 18456, Level 14, State 1, Line 901 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - Microsoft Q&A](https://learn.microsoft.com/api/attachments/216565-image.png?platform=QnA)
SQL query to linked server error: "Msg 18456, Level 14, State 1, Line 901 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - Microsoft Q&A
![Linked server - connection fail from remote computer (using ssms) - Database Administrators Stack Exchange Linked server - connection fail from remote computer (using ssms) - Database Administrators Stack Exchange](https://i.stack.imgur.com/aoNYd.png)
Linked server - connection fail from remote computer (using ssms) - Database Administrators Stack Exchange
![SQL SERVER - Linked server creation error: OLE DB provider "SQLNCLI11" for linked server returned message "Invalid authorization specification" - SQL Authority with Pinal Dave SQL SERVER - Linked server creation error: OLE DB provider "SQLNCLI11" for linked server returned message "Invalid authorization specification" - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/a/linked-01.jpg)
SQL SERVER - Linked server creation error: OLE DB provider "SQLNCLI11" for linked server returned message "Invalid authorization specification" - SQL Authority with Pinal Dave
![Resolved: Login failed for user NT AUTHORITY\ANONYMOUS LOGON - Delegation Step-by-Step - Eitan Blumin's blog Resolved: Login failed for user NT AUTHORITY\ANONYMOUS LOGON - Delegation Step-by-Step - Eitan Blumin's blog](https://eitanblumin.com/wp-content/uploads/2022/10/Delegation.jpg)
Resolved: Login failed for user NT AUTHORITY\ANONYMOUS LOGON - Delegation Step-by-Step - Eitan Blumin's blog
![login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008 - Stack Overflow login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008 - Stack Overflow](https://i.stack.imgur.com/p1WUd.png)
login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008 - Stack Overflow
![how to stop using sql server login credentials in a linked server? - Database Administrators Stack Exchange how to stop using sql server login credentials in a linked server? - Database Administrators Stack Exchange](https://i.stack.imgur.com/JZ2L7.png)
how to stop using sql server login credentials in a linked server? - Database Administrators Stack Exchange
![login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008 - Stack Overflow login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008 - Stack Overflow](https://i.stack.imgur.com/DIxzC.png)
login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008 - Stack Overflow
![SQL SERVER - FIX Error 18456, Severity: 14, State: 6. Login failed for user - SQL Authority with Pinal Dave SQL SERVER - FIX Error 18456, Severity: 14, State: 6. Login failed for user - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/a/state06-01.jpg)
SQL SERVER - FIX Error 18456, Severity: 14, State: 6. Login failed for user - SQL Authority with Pinal Dave
![SQL SERVER - FIX – Linked Server Error 7399 Invalid authorization specification - SQL Authority with Pinal Dave SQL SERVER - FIX – Linked Server Error 7399 Invalid authorization specification - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/c/linked-error-02.jpg)
SQL SERVER - FIX – Linked Server Error 7399 Invalid authorization specification - SQL Authority with Pinal Dave
![SQL SERVER - Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It - SQL Authority with Pinal Dave SQL SERVER - Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2017/12/link-error-01-800x388.jpg)
SQL SERVER - Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It - SQL Authority with Pinal Dave
![SQL SERVER - Fix - Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) - SQL Authority with Pinal Dave SQL SERVER - Fix - Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/errorconnect2.jpg)