My SQL Server 2005 is logging repeated EventID 18456 Category 4, Severity 14 State 11. This would indicate that the login is valid but server access failed. A trace showed that the failure is occuring on an attempted login to the Master database.
According to the error message the login attempt is not coming from a database user, it is coming from the server itself, as servername$. That is, say the server is named Paris on domain MYDOMAIN. The user login that is failing would be MYDOMAIN\Paris$.
The client IP address is the IP address for the server named Paris. I don't know what it means and I don't know what to do about it. The Paris server does host an application that uses a database on the SQL Server but that application
is running fine.
View Complete Post