Error Connecting MS SQL Server 2005

Highlighted
One Star

Error Connecting MS SQL Server 2005

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
Community Manager

Re: Error Connecting MS SQL Server 2005

Hello
Unknown server host name 'SSS\SQLEXPRESS'.

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

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Error Connecting MS SQL Server 2005

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
One Star

Re: Error Connecting MS SQL Server 2005

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
One Star

Re: Error Connecting MS SQL Server 2005

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
One Star

Re: Error Connecting MS SQL Server 2005

FYI I'm using TOS 2.4.1 and JRE 1.6.0_07
Five Stars

Re: Error Connecting MS SQL Server 2005

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

Re: Error Connecting MS SQL Server 2005

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
One Star

Re: Error Connecting MS SQL Server 2005

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 ;-).
One Star

Re: Error Connecting MS SQL Server 2005

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
Employee

Re: Error Connecting MS SQL Server 2005

One Star

Re: Error Connecting MS SQL Server 2005

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

Re: Error Connecting MS SQL Server 2005

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
One Star

Re: Error Connecting MS SQL Server 2005

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.