Unable to connect to Microsoft SQL Server - Connection failed to Microsoft SQL Servers
Hi,
I am facing issues connecting to the data source Microsoft SQL Server, i am getting the following error
Connection failure. You must change the Database Settings. java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host
The TCP/IP is enabled in SQL Server configuration manager, but still same error.
I wanted to try with Microsoft SQL Server(OBDC Driver) but somehow that doesnt seem to be an option in the free version, i am currently using Open Studio - Data Integration.
I strongly suggest using the context load for your jobs and not using the so called connections in the TMC. Keep in mind, the credentials are actually a matter of DevOps or Administrators and usually they do not have access to the TMC.
You can use the build-in context load (check the options in the project settings or per job in the view "Job") or you can use the more convenient component right start of the job: https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F1633&pi=marketplace%252F1%252Fproducts%252F1633%252Fitems%252F3003 (there is spelling error in Talend Exchange, the components name is tContextInput).
