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.