connection to MS SQL SERVER not work

[Anonymous]

hello Everybody,
I use new version of talend (TOS 3.0.0). I would like to use the components about MS SQL SERVER database.
So when i create db connection, that not work. Error message : "Connection failure. You must change the Database Settings.
Network error IOException: Connection refused: connect"
Please what i do??
thanks

[Anonymous]

Hi,
MSSQL needs to be configure to accept remote connection and also the firewall needs to allow traffic.
have a look at this page:
http://jtds.sourceforge.net/faq.html#connectionRefused
this is the website for the project that develops MSSQL java driver.

Nicolas

[Anonymous]

hello,
That work with MS SQL SERVER but i use MS SQL SERVER EXPRESS Edition and that not work.
can you help me please??

[Anonymous]

Hello,
MS SQL EXPRESS has named instances
So you have to fill Additional Parameters field
Try using:
Additional Parameters: instance=SQLEXPRESS

José

[Anonymous]

Hi,
I do it but that not work. the erro is "Unable to get information from SQL Server: S-XXXXXXXXXXX"
this is the string of connection :

 jdbc:jtds:sqlserver://S-XXXXXXXXXXX:1433/Base_FR;instance=SQLEXPRESS

generated by talend
Thank

[Anonymous]

rgent,
have you tried this:
http://jtds.sourceforge.net/faq.html#instanceGetInfo

[_AnonymousUser]

In Sql Server Express 2008 try to : start - programs - microsoft sql server 2008 - configuaration tools - sql server configuration monitor - find the node ''protocols for..." and enable tcp-ip.

[_AnonymousUser]

Important: stop/start the service to keep updates.

[_AnonymousUser]

I have the same problem, with the same error Connection failure. You must change the Database Settings.
Unable to get information from SQL Server: SERVERNAME
I enable TCP/IP for MS SQL SERVER but not resolve.
Via ODBC , i connected DB. But i have an unsopported future.

[_AnonymousUser]

I left the schema field empty and added instance=<instanceName> in Additional Parameters.
The String of Connection should look like
jdbc:jtds:sqlserver://<server>:<port>/<database>;instance=<instanceName>
Hope it helps