Connection with MS SQL Server component ???

[_AnonymousUser]

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

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

Hi
Please show us the error info. Or upload a screen shot.
Regards,
Pedro

[Anonymous]

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

[Anonymous]

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.".

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

Hi
Which version of TOS do you use?
Here is my SQL Server settings.
Regards,
Pedro

[Anonymous]

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.

[Anonymous]

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