Connection SQL server express

One Star

Connection SQL server express

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

Re: Connection SQL server express

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Connection SQL server express

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

Re: Connection SQL server express

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

Re: Connection SQL server express

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

Re: Connection SQL server express

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

Re: Connection SQL server express

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

Re: Connection SQL server express

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.
Five Stars

Re: Connection SQL server express

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

Re: Connection SQL server express

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

Re: Connection SQL server express

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

Re: Connection SQL server express

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog