topic Re: Unable to connect to sql server using window authentication in Talend Studio

Unable to connect to sql server using window authentication

Anonymous — Wed, 31 Dec 2014 12:48:08 GMT

I am trying to connect to Sql server using windows authentication. I created a new connection in metadata with all the required parameter for generic JDBC type. I am using Microsoft JDBC driver.
I keep getting the authentication failed error even after using the correct username and password.
Here is the screenshot for that.

Re: Unable to connect to sql server using window authentication

Anonymous — Wed, 31 Dec 2014 14:58:42 GMT

Hi,
What's talend build version you are using? What's your OS and sql server? Could you please create a new connection in metadata with all the required parameter for MSSQL DB (tMSSqlConnection) type instead of generic JDBC type to see if it is OK with you?

Best regards
Sabrina

Re: Unable to connect to sql server using window authentication

Anonymous — Fri, 02 Jan 2015 04:59:08 GMT

Yes, It works fine for mssql server . I am even able to connect to SQL server using JDBC type if I set integratedSecurity to false and give user name and password to use sqlserver authentication. Its only not working if I set Integratedsecurity to true.
I am using Talend 5.3.1, Windpows server 2008 and Sql server 2008R2.

Re: Unable to connect to sql server using window authentication

Anonymous — Sat, 03 Jan 2015 11:57:43 GMT

Yes because an Java program cannot have access to the integrated credentials. This is only possible with special designed Windows programs. The JDBC driver does not support the mode integratedSecurity=true

Re: Unable to connect to sql server using window authentication

Anonymous — Sun, 04 Jan 2015 10:16:29 GMT

Hi,
So far, talend don't support for that. Because integrated security=true is a parameter for the jars that microsoft distributes. Talend uses the jtds jar and jtds connection string.
Please take a look at: http://stackoverflow.com/questions/167464/can-i-connect-to-sql-server-using-windows-authentication-from-java-ee-webapp
Best regards
Sabrina

Re: Unable to connect to sql server using window authentication

Anonymous — Mon, 05 Jan 2015 06:30:41 GMT

What do you mean by "the jars that Microsoft supports". If you are refering to Microsoft JDBC drives , I am already using that.
Here are the conncetion parameters that I am using:
DB Type: General JDBC
JDBC URL : jdbc:sqlserver://TEST:1433;Database=TestDB; integratedSecurity=true
Driver jar : c:\program files\java\jre1.7.0\lib\sqljdbc41.jar \\this is the jar file of microsoft jdbc driver . I have placed it in java lib folder.
class name : com.microsoft.sqlserver.jdbc.SQLServerDriver
username : domain\uname
password : unamepassword
mapping file : id_MSSQL
As per this link in jira.talendforge this should work. Please let me know if I am using the correct values and not missed anything.

Re: Unable to connect to sql server using window authentication

Anonymous — Mon, 05 Jan 2015 06:56:05 GMT

Yes this way it should work. We actually thought you use the dedicated tMS* components.
I suggest you try the necessary properties in a separate tool like the SQLDeveloper and if you get it running there use the configuration in your Talend job.
It looks like your URL is wrong. The first parameter must be separated from the path with a question mark! Change the first ; with a ? and try again.

Re: Unable to connect to sql server using window authentication

Anonymous — Mon, 05 Jan 2015 11:08:54 GMT

I replaced ; with ?. But it still didnot work. I am still geting the follwing error:
Connection failure. You must change the Database Settings.
com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:5fe9820a-c18d-4af9-b19a-bca3103de2cc
The connection string is as per this Microsoft article.
I have copied the dll sqljdbc_auth.dll to java\bin and windows\system32 folders. I have also added the dll's path in Path environment variable.

Re: Unable to connect to sql server using window authentication

Anonymous — Mon, 05 Jan 2015 12:30:49 GMT

Hard to say whats necessary. I would digger in the Microsoft knowledge base how to do this.

Re: Unable to connect to sql server using window authentication

Anonymous — Tue, 06 Jan 2015 05:55:24 GMT

This seems to be a BUG.
tjdbcconnection is working fine with the same set of values. But creating new generic JDBC connection in metadata is not working.

Re: Unable to connect to sql server using window authentication

Anonymous — Tue, 06 Jan 2015 08:54:27 GMT

Hi,
Have you tried it in anther server(Win7) to see if this issue repro?
Best regards
Sabrina

Re: Unable to connect to sql server using window authentication

Anonymous — Fri, 16 Jan 2015 08:21:00 GMT

Hi,
Can we consider this topic as resolved?
Best regards
Sabrina

Re: Unable to connect to sql server using window authentication

Anonymous — Mon, 26 Nov 2018 10:47:40 GMT

If you are looking for best online game then you should try cool math game junction , It is really an interesting and entertaining game and is available in various version so choose your interest among them and enjoy your free time with joy.

Re: Unable to connect to sql server using window authentication

Anonymous — Thu, 17 Oct 2019 11:36:55 GMT

Most of the time this JDBC SQL connection causing a problem just because of network issues, today's JDBC SQL driver use is so less and most of the network connection doesn't allow the port of JDBC that's why it's causing a problem. Try ODBC driver or implement a direct connection which is more secure and professional.

Best Dissertation Help