Configure named instance MS SQL Connection

[Anonymous]

I'm trying to connect to a named instance of 2005 Express. I'm running Version 2.4.1 and the connection string is jdbc:jtds:sqlserver://obelix23:1433/master;instance=obelix where obelix23 is my server and obelix my instance. what am I getting wrong. Please help.

[Anonymous]

Hello,
Your post is not very clear.
Where is your problem ? In the wizard ? ? in the components ?
What version do you use ?
Regards,

[_AnonymousUser]

Hi,
I am using SQL Server 2000. My database server was running in the named instance as SQL2K. My Server name is Pradeep. I gives the connection string as foolowing:-
Server : Pradeep
Database : DemoDB
Password : demo@123
Login : Demo
Schema : dbo
Port : 1433
AdditionalParams : instance=SQL2K
The above syntax is correct or not. My job was threwing the following error.
Exception in component tMSSqlOutput_1
java.sql.SQLException: Server DOMAINCIS17 has no instance named SQL2K.
Thanks & Regards,
Pradeepkumar.M

[_AnonymousUser]

Hi,
I am using SQL Server 2000. My database server was running in the named instance as SQL2K. My Server name is Pradeep. I gives the connection string as foolowing:-
Server : Pradeep
Database : DemoDB
Password : demo@123
Login : Demo
Schema : dbo
Port : 1433
AdditionalParams : instance=SQL2K
The above syntax is correct or not. My job was threwing the following error.
Exception in component tMSSqlOutput_1
java.sql.SQLException: Server Pradeep has no instance named SQL2K.
Thanks & Regards,
Pradeepkumar.M

[_AnonymousUser]

Hi,
I am getting the same error. Did you get a solution? Does anyone know the solution?
Thanks
Khyati

[Anonymous]

Hi Khyati,
Did you restart your sql server brower? Can you connect to your sql server express successfully without using Talend tool?
Best regards
Sabrina

[_AnonymousUser]

Hi Sabrina,
Yes, I did both successsfully and still getting the error that the Server cannot find/ connect to the instance SQLEXPRESS.
Khyati