topic Re: Error Connecting MS SQL Server 2005 in Installing and Upgrading

Error Connecting MS SQL Server 2005

Anonymous — Sat, 16 Nov 2024 14:14:38 GMT

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

Re: Error Connecting MS SQL Server 2005

Anonymous — Fri, 05 Sep 2008 09:45:31 GMT

Hello

Unknown server host name 'SSS\SQLEXPRESS'.

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

shong

Re: Error Connecting MS SQL Server 2005

Anonymous — Fri, 05 Sep 2008 10:04:25 GMT

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

Re: Error Connecting MS SQL Server 2005

Anonymous — Fri, 05 Sep 2008 10:31:53 GMT

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

Re: Error Connecting MS SQL Server 2005

Anonymous — Fri, 05 Sep 2008 10:40:23 GMT

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

Re: Error Connecting MS SQL Server 2005

Anonymous — Fri, 05 Sep 2008 10:46:43 GMT

FYI I'm using TOS 2.4.1 and JRE 1.6.0_07

Re: Error Connecting MS SQL Server 2005

briansms — Fri, 05 Sep 2008 12:19:07 GMT

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

Re: Error Connecting MS SQL Server 2005

Anonymous — Sun, 07 Sep 2008 05:11:41 GMT

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

Re: Error Connecting MS SQL Server 2005

_AnonymousUser — Fri, 19 Sep 2008 16:24:19 GMT

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

Re: Error Connecting MS SQL Server 2005

Anonymous — Thu, 02 Oct 2008 00:23:02 GMT

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

Re: Error Connecting MS SQL Server 2005

Sebastiao_Qlik — Wed, 29 Oct 2008 17:27:41 GMT

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

Re: Error Connecting MS SQL Server 2005

_AnonymousUser — Fri, 09 Jan 2009 09:06:44 GMT

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

Re: Error Connecting MS SQL Server 2005

josephmundadan — Fri, 24 Aug 2012 07:11:18 GMT

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

Re: Error Connecting MS SQL Server 2005

Anonymous — Fri, 13 Sep 2013 15:05:54 GMT

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.