|
From: Ray M. <Ray...@te...> - 2012-09-27 16:46:34
|
I spent a few hours unsuccessfully trying to connect to a Microsoft SQL server using integrated authentication (Kerberos), following instructions I found on various sites, and the instructions never seemed to work. It turns out Microsoft changed the rules. You now need to add the parameter authenticationScheme=JavaKerberos . See: http://msdn.microsoft.com/en-us/library/gg558122.aspx Sample connection string that works: jdbc:jtds:sqlserver://123.123.123;instance=server1;databaseName=students;integratedSecurity=true;authenticationScheme=JavaKerberos Also in driver properties set "Domain". Do not include the domain in any user name setting. This was tested using Squirrel SQL (Java) with jtds on Mac OSX. Hopefully the previous sentence has the search terms someone might use who needs to know this information. -- Ray Morris Curriculum & eLearning Services Ray...@te... 979-458-6812 |
