79273856

Date: 2024-12-12 04:55:23
Score: 1
Natty:
Report link

The user @AlwaysLearning already says it all:

First, go to download jTDS - SQL Server driver. Paste those files into the Driver Manager, picture attached:

enter image description here

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.

Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • User mentioned (1): @AlwaysLearning
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: user284331