title: SQL Server : Login failed for user
body: <p>A month ago I created a job in IBM <code>DataStage</code>, in the job I did ETL into database target, the job success executed. But two days ago when I was testing the connection of my database target in IBM <code>DataStage</code>, suddenly it failed to connect. <a href="https://i.stack.imgur.com/wwirw.png" rel="nofollow noreferrer">This is the error message</a>. I did not change the password of the database so I'm very confused why I failed to connect, I already look for <a href="https://www.liquidweb.com/kb/troubleshooting-microsoft-sql-server-error-18456-login-failed-user/" rel="nofollow noreferrer">solutions</a> and one solution says since its probably caused by the authentication and needs to be changed into SQL Server authentication, it requires SQL Server Management Studio (I'm not sure if the authentication is the problem because I never changed <strong>any setting</strong> ever since I created the database and the job . But with <code>DBeaver</code>, I still can access and manage my database. What's going on actually and how to fix this?</p>