Connect to MS SQL instance

[es1961]

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.

[Morpheus]

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

[es1961]

Thank you. It works

[Morpheus]

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