Login failed for user domainname\username while using MSSQL Microsoft driver template in TIBCO Spotfire Server
Article ID: KB0072328
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | Tibco Spotfire server 11.5 |
Description
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
Login test fails under SQL management Studio as well while trying to use same domain name\username and pwd for integrated authentication
Issue/Introduction
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
Resolution
- As a prerequisite ,please make sure that following are in place :
- Downloaded sqljdbc_auth.dll under <Spotfire installation directory>/jdk/bin
- 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
Additional Information
Doc: Setting up the Spotfire database (SQL Server with Integrated Windows authentication)
Feedback
Yes
No
Powered by
