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'.

 

Details:

   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

Hi,


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


Regards


Roger

Login or Signup to post a comment