topic Re: Configure named instance MS SQL Connection in Talend Studio

Configure named instance MS SQL Connection

Anonymous — Sat, 16 Nov 2024 14:10:12 GMT

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.

Re: Configure named instance MS SQL Connection

Anonymous — Thu, 06 Nov 2008 12:22:45 GMT

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

Re: Configure named instance MS SQL Connection

_AnonymousUser — Mon, 17 Nov 2008 05:49:41 GMT

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

Re: Configure named instance MS SQL Connection

_AnonymousUser — Mon, 17 Nov 2008 05:50:46 GMT

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

Re: Configure named instance MS SQL Connection

_AnonymousUser — Fri, 10 Apr 2015 04:27:17 GMT

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

Re: Configure named instance MS SQL Connection

Anonymous — Tue, 14 Apr 2015 10:07:35 GMT

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

Re: Configure named instance MS SQL Connection

_AnonymousUser — Thu, 16 Apr 2015 16:12:47 GMT

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