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

[Anonymous]

Hello

Unknown server host name 'SSS\SQLEXPRESS'.

Maybe you can try 'SSS\\SQLEXPRESS' or type in the ip address.
Best regards

shong

[Anonymous]

Hello,
I'm using SQLexpress as well.
It's work fine but I don't specify SQLEXPRESS like you.
So just put SSS as server name, it should be OK.
JC

[Anonymous]

Hi All,
I have tried all method but still same error 'Unknown Server Host name...." my connection string is "jdbc:jtds:sqlserver://SSS\\SQL05:1433/Test;" but this connection is not working .
I want to connect sql server 2005 connection but i think in talend jdbc is not supporting .
My Computer Name : SSS
Database Server Name : SQL05
Database : Test
plz solve this issue ...
Thanks in advance ,
Syed

[Anonymous]

Hello,
I'm using SQL 2005, it work fine.
You have to allow remote connexion on your SQL server.
I think that is not allowed by default.
and give the good right to your sql user.

JC

[Anonymous]

FYI I'm using TOS 2.4.1 and JRE 1.6.0_07

[briansms]

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

[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 : "SYED-PC\JAZZSQL" and when I
fill this name in server field then error is coming "Connection failure. You must change the Database Settings.
Unknown server host name 'SYED-PC\SQLEXPRESS'.
". I have been tried with only ?JAZZSQL? and with instance name but still error is coming.
plz solve my issue and give me result with snapshot plz.
Thanks,
SSS
Email : syed2uk@gmail.com

[_AnonymousUser]

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

Brian, you are the best ;-).

[Anonymous]

What was the final connection string? I'm running sql server express 2008. What do you have in the Server entry. Mine is U0102571-XPA, which is my computer name. It's also how the managment studio references the database as well