[a259746]

I am using e.spreadsheet v9sp3
Need to connect to a SQL Server with an ID that is set up to only connect using WINDOWS AUTHENTICATION.
I am able to connect perfectly fine to another SQL db that allows SQL Authentication.
Please help me with the Driver, Driver Class, Database URL and any drivers or CLASS files i may need to install/save to my PC. Thanks in advance.

[blagerweij]

a259746, on 25 October 2011 - 05:13 AM, said:

I am using e.spreadsheet v9sp3
Need to connect to a SQL Server with an ID that is set up to only connect using WINDOWS AUTHENTICATION.
I am able to connect perfectly fine to another SQL db that allows SQL Authentication.
Please help me with the Driver, Driver Class, Database URL and any drivers or CLASS files i may need to install/save to my PC. Thanks in advance.

Using Microsoft JDBC:
jdbc:sqlserver://localhost;integratedSecurity=true;
(make sure you add the sqljdc_auth.dll on the java.library.path)


Using open source jTDS:
jdbc:jtds:sqlserver://localhost/dbname;domain=MYDOM
Leave username and password blank, add ntlmauth.dll to java.library.path; see README.SSO in the distribution

Kind regards,

Barry Lagerweij