In this article, I am going to explain fixing a problem related login failure error with SQL Server.
The Problem
One of the common error in the SQL Server error log is
« Login failed for user ‘DomainNameServerName$’. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]« .
Even though it says that the login failure from user ‘DomainNameServerName$’, the actual user can be different. So the error message is a kind of misleading. This is the main problem with this error. So it is very hard to find our from where the error is coming.
If you