Connection SQL server express

[_AnonymousUser]

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

[Anonymous]

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

[_AnonymousUser]

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

[fyk_cz]

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.

[_AnonymousUser]

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

[Anonymous]

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

[_AnonymousUser]

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

[Anonymous]

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.

[briansms]

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

[Anonymous]

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