Configure named instance MS SQL Connection

One Star

Configure named instance MS SQL Connection

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.
Employee

Re: Configure named instance MS SQL Connection

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

Re: Configure named instance MS SQL Connection

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
One Star

Re: Configure named instance MS SQL Connection

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
One Star

Re: Configure named instance MS SQL Connection

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

Re: Configure named instance MS SQL Connection

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Configure named instance MS SQL Connection

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