When user tries to set up integrated authentication with domain name\user name using MSSQL Microsoft driver template ,error pops up while test connection as Login failed for user domain name\username.



Login test fails under SQL management Studio as well while trying to use same domain name\username and pwd for integrated authentication

• As a prerequisite ,please make sure that following are in place :

1. Downloaded sqljdbc_auth.dll under <Spotfire installation directory>/jdk/bin
2. sqljdbc41.jar under <installation directory>\tomcat\custom-ext

• Go to configuration tool
• Select bootstrap tab
• Under driver template select MSSQL Microsoft
• Put username as domain name\username
• Input the password
• Under URL section mention manually as :";integratedSecurity=true" in the last of the URL
• Hit the test connection button,this time the connection is successful

• Go to login window
• Enter the domain name\user name and password
• Go to Additional Connection Parameters tab and enter manually as :"Integrated Security=True"
• And click on connect

• https://docs.tibco.com/pub/spotfire_server/11.4.7/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/setting_up_the_spotfire_database_(sql_server_with_integrated_windows_authentication).html