Forum Discussion
SQL Server account locked out and password did not match?
Hi We have this situation that a SQL Server account has been having two different login failures recently. The errors appear in the SQL Server log without much details. Wonder if any one had enc...
Here are some possible sources where it can come from
- Application connecting via ODBC or using a connection string
- Scheduled task
A useful troubleshooting step would be to run netstat -ano in the command prompt on both computers. This will allow you to check if there is an active connection attempt to SQL. If a connection attempt is visible, the last column will show the Process ID (PID). You can then cross-reference this PID in Windows Task Manager to identify which application is attempting to establish the connection.