SQL Database Login Failure

Question

One of my users is getting a "login failed for user" message when trying to login.

The most common answer that I've seen is making sure that that SQL configuration is set to "SQL Server and Windows Authentication mode" which it is. I believe that the issue might be with some sort of network authentication. Users in one building can access the database while users in another building cannot access it.

Any thoughts on this?

Answer 1

Any thoughts on this?

With that less on informations: No.

Lookup SQL Server ErrorLog for details about the failed login attempts; by default that gets logged.

Answer 2

Hi @Tom Tucker

This is a common error.

You can provide the ErrorLog according to Olaf's advice.

As a supplement, you can refer to this official document.

https://learn.microsoft.com/en-US/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error?view=sql-server-ver16

Best regards,

Percy Tang