Login failed for user domainname\username while using MSSQL Microsoft driver template in TIBCO Spotfire Server

Product:TIBCO Spotfire Server
Versions:Tibco Spotfire server 11.5

Summary:
User faces error as Login failed for user domainname\user name under configuration tool-bootstrap while test connection and under SQL management studio while trying to set up user account with domain name for integrated authentication

Details:
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

Resolution:

• 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

To test the integrated security with domain name/username under SQL management Studio :

• 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