Error Connecting MS SQL Server 2005

[Anonymous]

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

[Sebastiao_Qlik]

see http://www.talendforge.org/forum/viewtopic.php?pid=17856#p17856 for an example.

[_AnonymousUser]

under sql server configuration monitor:
1run sql server browser
2 enable TCP/IP protocol

[josephmundadan]

For named instances, Additional Parameters field gets the instance name, not the standard server/instance.
Try using:
Additional Parameters: instance=SQLEXPRESS
- Brian

Thanks Brian. You made it work.
This is what I have done.
Additional Parameters: instance=SQLEXPRESS
Restart service with TCP/IP enabled

[Anonymous]

Hi All
I am new to talend.
I have created an oracle connector which works fine.
I have tried creating a connection to SQLExpress 2012.
I have the latest Java installed.
I have tried the connection with both Named Pipes and IP address, both enabled with port 1433 as the default port.
I have tried both with and without the additional parameter: instance=SQLEXPRESS
Every time I try a check I get "Connection failure. You must change your database settings"
tried all sorts of connections even.
jdbc:jtds:sqlserver://mypc:1433;instance=SQLEXPRESS
Anyone have any idea what may be wrong.