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