Yes it is possible to use windows authentication to connect to the Ms SQL server. But you need to copy the correspondent native library into the ivyServers JVM.
To activate windows authentication proceed as follows:
1. Download the full JTDS driver package: [download site][1]
2. Extract the downloaded ZIP
3. Navigate into the extracted system folder that matches your ivyServer environment. (e.g. **x64** or **x32**)
4. Copy the **ntlmauth.dll** from the SSO folder (within the system folder). Into the ivyServers **/jre/bin** folder.
5. Now start **XpertIvyServerConfigC.exe** with a windows profile that is allowed to connect to the server. (Maybe use the [RUNAS][2] command to run in another profile)
6. Ensure that the USER NAME and PASSWORD field is empty.
7. Press the connect button, enjoy :-)!![DB connected by SSO][3]
This solution is inspired by a [stack overflow][4] question..
[1]: http://sourceforge.net/projects/jtds/files/jtds/1.3.0/jtds-1.3.0-dist.zip/download
[2]: http://ss64.com/nt/runas.html
[3]: /upfiles/windowsAuthConnected_1.PNG/upfiles/windowsAuthConnected_1.PNG
[4]: http://stackoverflow.com/questions/13267764/i-o-error-sso-failed-native-sspi-library-not-loaded
