Microsoft SQLServer datasource configured with Windows Authentication fails with an error when using JTDS driver
Article ID: KB0077087
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
While connecting to MS SQL server using Windows authentication from TIBCO Data Virtualization, the following error may be seen.
Error:- Login failed. The login is from an untrusted domain and cannot be used with Windows
Error:- Login failed. The login is from an untrusted domain and cannot be used with Windows
Issue/Introduction
While connecting to MS SQL server using Windows authentication from TIBCO Data Virtualization, the following error may be seen : "The login is from an untrusted domain and cannot be used with Windows."
Resolution
Add "useNTLMv2=true" parameter in the existing datasource connection URL to resolve the issue.
Example:- jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE_NAME>;useNTLMv2=true
JTDS will use Windows NTLM authentication and will provide a successful database connection.
Example:- jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE_NAME>;useNTLMv2=true
JTDS will use Windows NTLM authentication and will provide a successful database connection.
Feedback
Yes
No
Powered by
