Talend community forum / MS SQL Server connection problem

michaelpearson · 2012-07-20 09:51:55

I'm trying to set up a connection to a SQL Server database and I get an error saying that it is impossible to make a connection. I've tried to attach a screenshot that shows both the settings for the connection and the error but it fails to upload.

Last edited by michaelpearson (2012-07-20 09:57:46)

pedro · 2012-07-20 09:57:24

Hi

I can't find the image.
Please notice the limits:20 images per post, each image must be less then 1024x768 pixels and 200 KB.

Regards,
Pedro

michaelpearson · 2012-07-20 09:58:51

I shall give you the info as per the screen.

michaelpearson · 2012-07-20 10:02:44

the input parameters are as follows

DB Type: Microsoft SQL Server
Login: sa
Password: ********
Server: MPDBS-HP\SQLEXPRESS
Port: 1433
Database: care_demo

pedro · 2012-07-20 10:05:49

Hi

There are many possibilities why the connection fails.
First, please check the SQL Server Management Studio to check the port.
Then make sure the TCP/IP is on.
Or close the firewall.

Regards,
Pedro

michaelpearson · 2012-07-20 10:08:37

Thanks,I'll do that. This is all happening on a single, local machine, not over a network. The Port 1433 is the number Talend puts in by default.

michaelpearson · 2012-07-20 10:16:40

OK, TCP/IP is enabled and the port is set as the default 1433. Where next?

pedro · 2012-07-20 10:19:38

Hi

The IPALL is 1433?
What's the error log?

Regards,
Pedro

michaelpearson · 2012-07-20 10:29:31

Hiya

Can't see IPALL, where do I find that?

The error in Talend is 'Connection Failure. You must change the Database Settings' Impossible to initialize the connection!'

thanks
Mike

pedro · 2012-07-20 10:35:03

Hi Mike

You can find it in SQL SERVER Management Studio.

Regards,
Pedro

michaelpearson · 2012-07-20 10:45:38

Hi Pedro

I thougth there should be an IP address tab on the TCP/IP properties but there isn't one!

Mike

pedro · 2012-07-20 10:50:43

Hi

It's here.

Regards,
Pedro

Uploaded Images

michaelpearson · 2012-07-20 10:56:33

Hi Pedro

I'm obviously missing something because I can't find that tab at all. Sorry to be a pain but can you tell me how you got to it?

thanks

Mike

pedro · 2012-07-20 10:59:06

Hi Mike

Do you insall sql server on your local machine?
Is there a program called SQL Server Management Studio?
Please find more info on Google about JDBC sql server.

Regards,
Pedro

michaelpearson · 2012-07-20 11:59:32

Hi Pedro

Yes, I installed SQL Server on my local machine and I have SQL Server Management Studio. This is the first time I have had anything to do with JDBC and I think that maybe this isn't installed correctly. I'm not even sure where it should be installed. I've checked the documentation but I don't find it clear on how and where to install it.

Mike

michaelpearson · 2012-07-20 16:36:21

I've looked at all the documentation I've access to and Googled for help by still can't work out what is going on. I'm guessing that the answer lies with JDBC, but only guessing, but I'm out of my knowledge area here. Any idea where I can find what the correct JDBC installation for SQL Server/Talend should be?

Mike

pedro · 2012-07-23 03:52:01

Hi Mike

Do you have any co-workers who are familiar with SQL Server JDBC?
Usually this is a little hard for novice.

Regards,
Pedro

michaelpearson · 2012-07-23 09:31:18

I shall be checking today. Is JDBC the only mechanism for Talend Tasks to talk to SQL Server?

thanks

Mike

pedro · 2012-07-23 09:32:39

Hi Mike

Anather way is ODBC.
But if you are using 64bit system, ODBC might cause more error.

Regards,
Pedro

michaelpearson · 2012-07-23 09:36:55

OK thanks. I'll talk to my colleagues today asbout our options.

Mike

newmer · 2012-07-23 16:23:26

Hi Mike,

If you are able to find out the issue, please post back. I am having the exact same issue where I am getting the Impossible to Initialize the connection.

Thanks!

trevmetz · 2012-10-10 20:54:01

MIke, any solution? I also am trying to work through this error.

trevmetz · 2012-10-29 20:54:48

i have a solution!! wow what a mess to find all the answers.

so...

i had installed Talend DI 64 bit, i think this is the first issue to an easy solution, tho have not taken the time to uninstall and only try 32bit.

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

apandit · 2012-10-30 21:26:42

I am having exactly the same issue. Tried following the solution.
1. enabled tcp/ip port on MSSQL server at correct port
2. Since I am using 32 bit version, copied appropriate dll and jar file. Tried using both jtds-1.2.6-dist and jtds-1.3.0-dist but still getting following error

Connection failure. You must change the Database Settings.

java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2

Any idea?

Thanks
Ap

Syed Arshad · 2012-10-31 08:26:52

michaelpearson wrote:
the input parameters are as follows

DB Type: Microsoft SQL Server
Login: sa
Password: ********
Server: MPDBS-HP\SQLEXPRESS
Port: 1433
Database: care_demo

Hi Mike,

Earlier i had the same issue but it solved. I believe you might have "SQL Server Management Studio"(ssms).

- Are you able to login with SQL Server Management Studio with the above login/password then there is a problem. Check your security setting of SQL Server(is it windows authentication mode (or) SQL Server and windows authentication mode(both). If the security setting is windows authentication mode then change to both modes(SQL Server and Windows authentication mode).
- One more thing you need to verify if you are not able to login then check the properties of login(sa) which you can go through Security->Properties->Status. Select option enable if it is disabled.

All these changes done only if you are administrator user.

The above one is few reasons which you cannot connect sql server.

Regards
Arshad

Announcement

Unanswered posts

#1 2012-07-20 09:51:55

MS SQL Server connection problem

#2 2012-07-20 09:57:24

Re: MS SQL Server connection problem

#3 2012-07-20 09:58:51

Re: MS SQL Server connection problem

#4 2012-07-20 10:02:44

Re: MS SQL Server connection problem

#5 2012-07-20 10:05:49

Re: MS SQL Server connection problem

#6 2012-07-20 10:08:37

Re: MS SQL Server connection problem

#7 2012-07-20 10:16:40

Re: MS SQL Server connection problem

#8 2012-07-20 10:19:38

Re: MS SQL Server connection problem

#9 2012-07-20 10:29:31

Re: MS SQL Server connection problem

#10 2012-07-20 10:35:03

Re: MS SQL Server connection problem

#11 2012-07-20 10:45:38

Re: MS SQL Server connection problem

#12 2012-07-20 10:50:43

Re: MS SQL Server connection problem

#13 2012-07-20 10:56:33

Re: MS SQL Server connection problem

#14 2012-07-20 10:59:06

Re: MS SQL Server connection problem

#15 2012-07-20 11:59:32

Re: MS SQL Server connection problem

#16 2012-07-20 16:36:21

Re: MS SQL Server connection problem

#17 2012-07-23 03:52:01

Re: MS SQL Server connection problem

#18 2012-07-23 09:31:18

Re: MS SQL Server connection problem

#19 2012-07-23 09:32:39

Re: MS SQL Server connection problem

#20 2012-07-23 09:36:55

Re: MS SQL Server connection problem

#21 2012-07-23 16:23:26

Re: MS SQL Server connection problem

#22 2012-10-10 20:54:01

Re: MS SQL Server connection problem

#23 2012-10-29 20:54:48

Re: MS SQL Server connection problem

#24 2012-10-30 21:26:42

Re: MS SQL Server connection problem

#25 2012-10-31 08:26:52

Re: MS SQL Server connection problem

michaelpearson wrote:

Board footer