Start a new topic

SQL server authentication

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?

Long Message:

Login failed for user 'xxxxxx'.



   Type: java.sql.SQLException

   Error Code: 18456

   SQL State: 28000

My device is windows 10 and I am using DBVisualizer 10.0.15

1 Comment


Is the authentication mode on the server set as mixed allowing both SQL Server and Windows authentication?



Login or Signup to post a comment