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

One Star

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

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
One Star

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

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)
One Star

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

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;
"jdbcSmiley Surpriseddbc:GLO474\SQLEXPRESS , VRSandPit"
One Star

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

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.
One Star

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

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
One Star

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

same issue here, any solution yet? thanks
One Star

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

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
One Star

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

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.
One Star

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

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.