The user @AlwaysLearning already says it all:
First, go to download jTDS - SQL Server driver
. Paste those files into the Driver Manager
, picture attached:
You may need to create another User Drivers
as it shall already have the default SQL Server by DBVisualizer, in my case, I make it like SQL Server-1
.
Now the crucial part is to copy the ntlmauth.dll
file from the downloaded folder (x64>SSO>ntlmauth.dll
) to the correct path.
The correct path is: C:\Windows\System32
. Restart the DBVisualizer, type the Database URL
to be jdbc:jtds:sqlserver://127.0.0.1:1433/pubs
, where pubs
is the database to be replaced with, and you should be good.
PANIC SITUATION:
If I disconnect the SQL Server-1
and reconnect again, I will get the I/O error like I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
The way I overcome this difficulty is silly: simply close the DBVisualizer and open it again. Not sure if somebody can fix this panic situation.