topic Re: Connection SQL server express in Talend Studio

Connection SQL server express

_AnonymousUser — Sat, 16 Nov 2024 14:22:57 GMT

Hello,
I tried to connect Talend with SQL Server 2005 Express.
I don't understant which parameter do I need to set, because each time I check the connection, Talend send me 2 differents errors :
Unknown server host name
or
Connection failure. You must change the Database Settings.
Network error IOException: Connection refused: connect
This is the parameters i have defined :
Db type : Microsoft SQL Server
Login : lamyt
password : (my password or nothing doesn't change anything)
server : SQLEXPRESS (for error n°1) or Localhost (for error n°2)
port : 1433 or 4096 as written in SQL server management
Database : scenario (i create it in SQL server management)
Does someone have an idea to solve this problem
Thank you
Tibal

Re: Connection SQL server express

Anonymous — Wed, 07 May 2008 10:05:11 GMT

Hello

server : SQLEXPRESS (for error n°1) or Localhost (for error n°2)

If you install the server on your local machine, type in: localhost
If you install the server on another machine, type in the IP or computer name, for example: 192.168.0.109
Best regards
shong

Re: Connection SQL server express

_AnonymousUser — Wed, 22 Oct 2008 16:23:27 GMT

Hi,
Have you resolve your pb ?
If not, there's another thing to verify => The connection port. Try 1086.
Regards,

Re: Connection SQL server express

fyk_cz — Thu, 23 Oct 2008 08:35:05 GMT

Have you installed SQL2k5EE as named instance or default instance? Because TOS using jtds jdbc driver, see the http://jtds.sourceforge.net (FAQ in documentations) for instance parameter.

Re: Connection SQL server express

_AnonymousUser — Tue, 24 Mar 2009 16:11:38 GMT

I had the same issue and resolved it by adding 'instance=SQLEXPRESS' in Additional JDBC Parameters

Re: Connection SQL server express

Anonymous — Wed, 08 Apr 2009 21:48:05 GMT

Where 'SQLEXPRESS' is your server instance. Using command prompt on Windows, type 'sqlcmd -L' to list named instances.

Re: Connection SQL server express

_AnonymousUser — Fri, 01 May 2009 22:39:46 GMT

I've got the same issue and, when I add the "instance=SQLEXPRESS I get a new message : "Unable to get information from SQL Server : <Name of server>"
Have you any idea to help me ?
Thanks for your help
Pascal

Re: Connection SQL server express

Anonymous — Thu, 07 May 2009 14:40:30 GMT

Is the server local ?
SQL Server 2005 Express comes with TCP/IP Connections *Disabled* by default.
So if you're trying to access a remote server, make sure that the server has that enabled.

Re: Connection SQL server express

briansms — Thu, 07 May 2009 15:00:03 GMT

You should also check your SQL client connection configuration. Review the suggestions in 2878
- Brian

Re: Connection SQL server express

Anonymous — Sun, 26 Jul 2009 03:37:13 GMT

Hello,
I am having the same issues as Pascal Hervier with SQL Express 2008. I have gone through all the settings for my SQL Server instance but I get the same problems he is having. Have there been any definitive solutions to this issue?
I have no issues using the MS SQL ODBC connection, but I cannot get the SQL Server with SQL Express to connect.
The only reason I am not using the ODBC connection is I am trying to get a generated identity key after an insert into the database using tMSSqlLastInsertId for doing a data translation from a record number based schema to an OORM schema. When I insert a row in the parent table, I need to get the generated identity key for use in the child table.
Any help would be very much appreciated.
Thanks,
Jim Long

Re: Connection SQL server express

_AnonymousUser — Fri, 04 Jan 2013 09:08:30 GMT

to connect sql server 2008 with instance name you must .
- add parameter to Additional parameters: instance=<instance_name>
- you need ensure SQLServer Browser service is started.
good luck!

Re: Connection SQL server express

_AnonymousUser — Wed, 11 Dec 2013 19:44:41 GMT

This final one worked for me:
--- you need ensure SQLServer Browser service is started.