|Talend Version||6.3, 6.4|
|SQL Server doesn't return schema to Talend 6.3.1|
|Product||Talend Data Integration|
This means you have to create a new connection for every non-system schema (n number of creations for n number of schemas).
If a connection is created to SQL Server without mentioning any schema and database details, all the schemas associated with that user should be shown.
|Problem root cause||The behavior is a bug in the product and thus Jira ticket TUP-18804 was submitted to address the issue.|
|Solution or Workaround||
You can resolve this issue by changing the Db Version in Metadata > Db Connections > SQL Server from Microsoft to Open Source JTDS.
|JIRA ticket number||TUP-18804|