topic Re: Can't get a connection to local SQL Server Express 2008 in Talend Studio

Can't get a connection to local SQL Server Express 2008

Anonymous — Mon, 20 Aug 2012 16:52:23 GMT

Hi,
Can't seem to establish a connection to a local instance of SQL Server Express 2008. Just keep getting the error;
"Connection failure. You must change the Database Settings.
java.sql.SQLException: Network error IOException: Connection refused: connect
"
On "jdbc:jtds:sqlserver://GLO474/SQLEXPRESS:1433/VRSandPit;"
Other tools like TOAD connect fine, just not my TALEND connection
Anyone out there with any idea ????
Thanks

Re: Can't get a connection to local SQL Server Express 2008

Anonymous — Mon, 20 Aug 2012 17:38:42 GMT

I get the same thing with a server instance of MS SQL 2008 -- it appears there may be something wrong with the driver and you need to use the ODBC version instead (which works for me)

Re: Can't get a connection to local SQL Server Express 2008

Anonymous — Mon, 20 Aug 2012 18:12:37 GMT

Tried it but I just get the error message;
"Connection failure. You must change the Database Settings.
Data source name not found and no default driver specified
"
With this string;
"jdbc dbc:GLO474\SQLEXPRESS , VRSandPit"

Re: Can't get a connection to local SQL Server Express 2008

Anonymous — Mon, 20 Aug 2012 19:59:59 GMT

This is a pretty common problem and there are a number of old threads about this. Review all those and you will probably find the answer. Among other common problems, you have to make sure your sql server supports logging in with a userid and pw, not just windows authentication. You might need to go to the Advanced > Additional JDBC props and add instance=VRSandPit.

Re: Can't get a connection to local SQL Server Express 2008

Anonymous — Tue, 21 Aug 2012 12:45:14 GMT

Yep, it's a common problem. I've followed a number of threads this morning, reinstalled SQL Server Express 2008, downloaded .DLL files, opened ports for TCP/IP.
The only thing I've not tried is killing a chicken at midmight.
Does anyone have a walk-through guide to installing SQL Server 2008 on a 32 bit Windows 7 machine and getting TOS v5.0.1 to talk to it.
Thanks

Re: Can't get a connection to local SQL Server Express 2008

Anonymous — Thu, 25 Oct 2012 15:46:31 GMT

same issue here, any solution yet? thanks

Re: Can't get a connection to local SQL Server Express 2008

Anonymous — Fri, 02 Nov 2012 15:20:50 GMT

my solution for a local connection was as follows:

1. verify version of Talend that was installed via- Help -> About Talend Studio -> Installation Details
2. from same location verified version of Java that Talend was using, since i had both 6 and 7 installed.
3. Download jtds-1.2.6
4. Copy "jtds-1.2.6.jar"
FROM C:\Users\...\Desktop\jtds-1.2.6-dist
TO C:\Program Files\Java\jre7\lib
5. Copy "ntlmauth.dll"
FROM C:\Users\...\Desktop\jtds-1.2.6-dist\x64\SSO
TO C:\Program Files\Java\jre7\bin
6. Restarted PC
7. Set TCP port 1433 in SQL Server Configuration Manager under SQL Server Network Configuration -> Protocols for Server -> TCP/IP -> IPAll -> TCP Port (for some reason this was blank)
8. Added Additional parameters to connection setup:
?Integrated Security?=true

Re: Can't get a connection to local SQL Server Express 2008

_AnonymousUser — Fri, 15 Feb 2013 05:35:24 GMT

THis is a major fail for Talend. Frequent issue yet they haven't created a fix or even just a checklist for hacking this problem. Im done with Talend.

Re: Can't get a connection to local SQL Server Express 2008

Anonymous — Fri, 15 Feb 2013 21:00:38 GMT

Had this, too. Ended up abandoning Windows Authentication. Created a MS SQL Server User that used SQL Server Authentication. Credentialed the TOS DI job with that user, and it has worked great ever since.