topic Re: Connect to MS SQL instance in Talend Studio

Connect to MS SQL instance

es1961 — Wed, 29 Aug 2018 18:04:19 GMT

My Talend (v6.3) job is connecting to MS SQL server with a few instances.

Server name - PBACIMNAAPUA01

Default instance - CR9_UAT

Named instance – 18r1_UAT

Job failed to connect to the server when I use host name as PBACIMNAAPUA01\CR9_UAT or PBACIMNAAPUA01\18R1_UAT, and running well when I use just a server name. It is connecting to default instance.

I tried to search Google, but did not find much information about it.

Please advise if Talend can connect to specific instances, passing as context parameters.

Re: Connect to MS SQL instance

Morpheus — Wed, 29 Aug 2018 18:34:32 GMT

Try with below options.

DB Type : Microsoft SQL Server
login : your user name
password - your password
server - PBACIMNAAPUA01
port - 1433
database - myDatabaseName
schema - (blank)
Additional parameters - instance=18r1_UAT

Re: Connect to MS SQL instance

es1961 — Wed, 29 Aug 2018 20:20:20 GMT

Thank you. It works

Re: Connect to MS SQL instance

Morpheus — Wed, 29 Aug 2018 21:00:26 GMT

@es1961, Can you please mark the reply as the resolution?