Talend community forum / Connection with MS SQL Server component ???

Tibal · 2008-05-16 17:29:49

Hello

I have installed SQL Server 2005 in localhost on my computer. I've tried to parameter an Db Connections but Talend can not initiate the connection with SQL Server.

Also, when I define an connection with odbc, I made it working with a dynamic port, and I can insert data on the database with the generic components.

I saw that odbc can not be connect with SQL Server if i define the port with the default value 1433.

I need to use the MS SQL Server component for some option like create table, so does someone can help me to set the good parameter for SQL Server 2005.

Thank you

Tibal

shong · 2008-05-19 05:16:49

Hello

Which version of TOS are you using? What's your error message?

Best regards

shong

Krp · 2008-07-17 22:23:19

You should check your settings in SQL Server Configuration Manager. Maybe the port 1433 is not active.

briansms · 2008-07-17 22:45:51

I use SQL Server 2005 without a problem and without the need for ODBC. Check the configuration settings in the SQL Server Connection Manager, make sure the TCP/IP protocol is enabled and check the Client Protocols > TCP/IP > Default Port.

- Brian

syed2uk · 2008-09-05 10:07:58

Hi All,

I am using talend open studio but when i create the MS SQL Server connection then talend gives me
error "host name is not found". My sql server 2005 name is : "SSS\SQLEXPRESS" and when i
filled this name in host name so error is coming "Connection failure. You must change the Database Settings.
Unknown server host name 'SSS\SQLEXPRESS'.
".
plz solve my issue .

Thanks,
SSS

Email : syed2uk@gmail.com

briansms · 2008-09-05 13:16:35

See my answer to you in http://www.talendforge.org/forum/viewtopic.php?id=3995

- Brian

EricW · 2011-08-05 18:05:30

I am having this same problem: TOS attempts to connect, and the error message is "java.sql.SQLException:Network Error IOException: connection refused: connect". I have validated the SQL Server configuration and the connect string appears to be correct. I have attempted to connect with both tMSSqlConnection (for which I can't find any documentation) and Metadata/Db Connections/Create Connection. Is this stuff documented anywhere?

Bruno Ferreira · 2012-05-22 11:40:17

Hi,
I'm not sure if you are still struggling with this.

In my case I discovered I had to use SQL Login Authentication (as opposed to Windows Authentication).
So here's my steps:

1. Create/Make sure I had a valid SQL Login with Log permissions on SQLServer and enough permission on the Dabatase I was trying to connect to.
2. Make sure that SQL Server was configure to accept Windows and SQL Server authentication
3. Test connecting to you Server/Database using the login you provided.
4. Then use same credentials/details on the Talend DI Connection Window.

Good luck guys,
I'm still a newbie on talend

pedro · 2012-05-22 11:44:44

Hi Bruno

Have you gotten some errors?

Regards,
Pedro

Ibran · 2012-06-30 15:52:44

Hi its Ibran,

can anyone tell how to connect to mssql from talend i am getting

impossible to initialize the connection error please please help me..

my database settings in talend are

DB Type - Microsoft SQL Server

login - myusername
password - mypassword
server - localhost
port - 1433
database - myDatabaseName
schema - (blank)
Additional parameters - instance=SQLEXPRESS

and in sql server i have enable the tcp/ip port and default port is 1433

pedro · 2012-07-02 05:08:07

Hi Ibran

Welcome to Talend Community!
Please create a new topic next time.

Did you encounter any issue about MSSQL connection?
We need more info.

Regards,
Pedro

Ibran · 2012-07-02 08:20:38

pedro wrote:
Hi Ibran

Welcome to Talend Community!
Please create a new topic next time.

Did you encounter any issue about MSSQL connection?
We need more info.

Regards,
Pedro

Hi
I am new to this talend please tell me how to connect to the mssql from talend and
i am able to connect to the mysql but with mssql its giving error impossible to initialize the connection.

pedro · 2012-07-02 08:21:49

Hi

Please show us the error info. Or upload a screen shot.

Regards,
Pedro

Ibran · 2012-07-02 08:41:04

pedro wrote:
Hi

Please show us the error info. Or upload a screen shot.

Regards,
Pedro

hi,

i am getting this error
impossible to initialize the connection

Ibran · 2012-07-02 09:06:04

pedro wrote:
Hi

Please show us the error info. Or upload a screen shot.

Regards,
Pedro

now i am connecting to the MsSql with general JDBC as DB Type
and i am getting this error now

Connection failure. You must change the Database Settings.
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host locahost, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

Last edited by Ibran (2012-07-02 09:06:30)

pedro · 2012-07-02 09:09:38

Hi

The error indicates that some settings like host or port is not correct.
Or go to SQL Server Configuration Manager to see whether TCP/IP has started.

Regards,
Pedro

Ibran · 2012-07-02 09:16:44

pedro wrote:
Hi

The error indicates that some settings like host or port is not correct.
Or go to SQL Server Configuration Manager to see whether TCP/IP has started.

Regards,
Pedro

Thanks for your reply,
can you send me what should be the configuration in SQL Server.

pedro · 2012-07-02 09:21:54

Hi

Which version of TOS do you use?

Here is my SQL Server settings.

Regards,
Pedro

Uploaded Images

Ibran · 2012-07-02 09:30:55

pedro wrote:
Hi

Which version of TOS do you use?

Here is my SQL Server settings.

Regards,
Pedro

this is Microsoft SQL Server Settings, I want general JDBC Settings .
and i am using TOS 5.1.1 version.

Ibran · 2012-07-02 09:40:36

pedro wrote:
Hi

Which version of TOS do you use?

Here is my SQL Server settings.

Regards,
Pedro

i have tried your settings now i am getting this 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

pedro · 2012-07-02 09:47:24

Hi

The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.

Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.

Regards,
Pedro

Ibran · 2012-07-02 10:18:19

pedro wrote:
Hi

The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.

Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.

Regards,
Pedro

Hi,

thank you for your response now i am able to connect to the mssql from talend with General JDBC as a DB Type.
but when i changed the DB Type to Microsoft SQL Server i am getting this error can you help for this also,

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

Thank you.

Ibran · 2012-07-03 08:57:42

Ibran wrote:
Ibran wrote:
pedro wrote:
Hi

The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.

Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.

Regards,
Pedro
Hi,

thank you for your response now i am able to connect to the mssql from talend with General JDBC as a DB Type.
but when i changed the DB Type to Microsoft SQL Server i am getting this error can you help for this also,

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

Thank you.

please give me some suggestion for this above error.

pedro · 2012-07-03 09:02:59

Hi

I told you yesterday it seemed to be a bug...
But then you said it was OK and you fixed it...

If you still get this exception, please report it on BugTracker.
PS: Do not add the URL of this forum. Just describe the issue on BugTracker.

Regards,
Pedro

Ibran · 2012-07-11 08:42:03

hi,

I Ibran now i am trying to run talend job from JAVA, I am successfully running the talend job from JAVA, but
can any one tell me how to pass parameter from java class to the talend this is very important in my project please help me out of it.

Announcement

Unanswered posts

#1 2008-05-16 17:29:49

Connection with MS SQL Server component ???

#2 2008-05-19 05:16:49

Re: Connection with MS SQL Server component ???

#3 2008-07-17 22:23:19

Re: Connection with MS SQL Server component ???

#4 2008-07-17 22:45:51

Re: Connection with MS SQL Server component ???

#5 2008-09-05 10:07:58

Re: Connection with MS SQL Server component ???

#6 2008-09-05 13:16:35

Re: Connection with MS SQL Server component ???

#7 2011-08-05 18:05:30

Re: Connection with MS SQL Server component ???

#8 2012-05-22 11:40:17

Re: Connection with MS SQL Server component ???

#9 2012-05-22 11:44:44

Re: Connection with MS SQL Server component ???

#10 2012-06-30 15:52:44

Re: Connection with MS SQL Server component ???

#11 2012-07-02 05:08:07

Re: Connection with MS SQL Server component ???

#12 2012-07-02 08:20:38

Re: Connection with MS SQL Server component ???

pedro wrote:

#13 2012-07-02 08:21:49

Re: Connection with MS SQL Server component ???

#14 2012-07-02 08:41:04

Re: Connection with MS SQL Server component ???

pedro wrote:

#15 2012-07-02 09:06:04

Re: Connection with MS SQL Server component ???

pedro wrote:

#16 2012-07-02 09:09:38

Re: Connection with MS SQL Server component ???

#17 2012-07-02 09:16:44

Re: Connection with MS SQL Server component ???

pedro wrote:

#18 2012-07-02 09:21:54

Re: Connection with MS SQL Server component ???

#19 2012-07-02 09:30:55

Re: Connection with MS SQL Server component ???

pedro wrote:

#20 2012-07-02 09:40:36

Re: Connection with MS SQL Server component ???

pedro wrote:

#21 2012-07-02 09:47:24

Re: Connection with MS SQL Server component ???

#22 2012-07-02 10:18:19

Re: Connection with MS SQL Server component ???

pedro wrote:

#23 2012-07-03 08:57:42

Re: Connection with MS SQL Server component ???

Ibran wrote:

Ibran wrote:

pedro wrote:

#24 2012-07-03 09:02:59

Re: Connection with MS SQL Server component ???

#25 2012-07-11 08:42:03

Re: Connection with MS SQL Server component ???

Board footer