PDA

View Full Version : SSO Integration for MS SQLServer



kettle_anonymous
03-16-2006, 11:46 AM
For those of us who have been assimilated, the following is a patch that will enable SSO (Single Sign-on) integration for MS SQLServer users. The file you patch is:


be\ibridge\kettle\core\database\Database.java


Since Kettle is using the JTDS library, omiting the username/password when it's left blank will automatically enable SSO on Windows platforms. Not sure if you want to modify this in the future to have an "SSO" checkbox or not, but just leaving the User / Password fields blank with the code below allows me to connect just fine.


One final note, you have to add the NTLMAUTH.DLL distributed with the JTDS library to your Java library path.
Cheers,


--Matt
<pre>
208,213c208
< Connection connection=null;
< if(databaseMeta.getUsername().length()==0 && databaseMeta.getPassword().length()==0) {
< connection = DriverManager.getConnection(databaseMeta.getURL());
< } else {
< connection = DriverManager.getConnection(databaseMeta.getURL(), databaseMeta.getUsername(), databaseMeta.getPassword());
< }
---
> connection = DriverManager.getConnection(databaseMeta.getURL(), databaseMeta.getUsername(), databaseMeta.getPassword());
</pre>

kettle_anonymous
03-16-2006, 11:47 AM
Sorry, just realized there might be confusion as to which Matt posted this. Matt Wright
matthew dot wright at hp dot com