Schemaspy Windows Authentication Sql Server

[JacBotin]

Hello people!

I have SQL Server servers with mixed mode authentication.
Only a few administrators have sql server authentication, and the vast majority are windows authentication.
I am not able to run schemaspy with windows authentication, can someone help me?
Thanks

[npetzall]

I can write section in docs later but most information exists in issue #129

[npetzall]

First I think you need the jdts driver.

Before -jar schemaspy-[version].jar you need to add -Djava.library.path
as an example java -Djava.library.path=D:\Path\To\jtds-1.3.1-dist\x64\SSO -jar schemaspy-6.0.0-rc1.jar
Then after -jar schemaspy-[version].jar you need to use -dp with path to the jdts driver and last -sso so that schemaspy will ignore user/pass requirement.

You also need to use the latest which you'll find a link in the readme it should be named schemaspy-6.0.0-SNAPSHOT.jar

[npetzall]

And when using MSSQL drivers:
https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017#Connectingintegrated

To add the integratedSecurity=true to the connection string you can use three different ways.
You can read the docs which contains -connprops integratedSecurity\\=true

Or #362 which has both connprops pointing towards a file and how you can add it to schemaspy.properties.

You still need to use the -Djava.library.path

[kfugate]

You might need to copy the ..\SchemaSpy\jdts-1.3.1-dist\x86\sso\ntmlauth.dll to your Windows System32 directory and then reboot your machine. Just updating your environment path to include this install location might not work. This is on the machine you are running Schema-spy from.

And also follow the directions given above.