I am trying to understand how this works.
I have access to a SQL server DB. When I set up the connection via DBVisualizer (driver SQL Server (jTDS) and leave userid & password blank I connect as expected. I understand this to mean I am using Windows Authentication. This makes sense and is working as expected.
However, when I enter my MS id and password my connection fails. How come I can't connect by passing my username and password?
Login failed for user 'xxxxxx'.
Error Code: 18456
SQL State: 28000
My device is windows 10 and I am using DBVisualizer 10.0.15
Is the authentication mode on the server set as mixed allowing both SQL Server and Windows authentication?