Answers to: Change Server Configuration From SQL Server Authetication to Windows Authenticationhttps://answers.axonivy.com/questions/830/change-server-configuration-from-sql-server-authetication-to-windows-authentication<p>Hello How can I change the login method in the Server Configuration from SQL Server Authentication to a Windows Server Account? I tried in User Name Domain\user, user@Domain.wan and Domain.wan\user. Every Method was without success. Thank's for your help Ralf</p> <p><img alt="alt text" src="/upfiles/Server_Config.JPG"></p>enWed, 02 Jul 2014 14:43:37 -0400Answer by Reguel Wermelingerhttps://answers.axonivy.com/questions/830/change-server-configuration-from-sql-server-authetication-to-windows-authentication/834<p>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.</p> <p>To activate windows authentication proceed as follows:</p> <ol> <li>Download the full JTDS driver package: <a href="http://sourceforge.net/projects/jtds/files/jtds/1.3.0/jtds-1.3.0-dist.zip/download">download site</a></li> <li>Extract the downloaded ZIP</li> <li>Navigate into the extracted system folder that matches your ivyServer environment. (e.g. <strong>x64</strong> or <strong>x32</strong>)</li> <li>Copy the <strong>ntlmauth.dll</strong> from the SSO folder (within the system folder). Into the ivyServers <strong>/jre/bin</strong> folder.</li> <li>Now start <strong>XpertIvyServerConfigC.exe</strong> with a windows profile that is allowed to connect to the server. (Maybe use the <a href="http://ss64.com/nt/runas.html">RUNAS</a> command to run in another profile)</li> <li>Ensure that the USER NAME and PASSWORD field is empty. </li> <li>Press the connect button, enjoy :-)!<img alt="DB connected by SSO" src="/upfiles/windowsAuthConnected_1.PNG"></li> </ol> <p>This solution is inspired by a <a href="http://stackoverflow.com/questions/13267764/i-o-error-sso-failed-native-sspi-library-not-loaded">stack overflow</a> question..</p>Reguel WermelingerWed, 02 Jul 2014 14:43:37 -0400https://answers.axonivy.com/questions/830/change-server-configuration-from-sql-server-authetication-to-windows-authentication/834