topic Re: SQL server connection issue in Talend Studio

SQL server connection issue

rommy — Sat, 16 Nov 2024 03:16:17 GMT

Hi All,

I am trying to connect to sql server and having an issue to connect. I can log into sql server using same user id with SSMS but not able to establish connection with Talend connection. TCP IP port is already enabled for SQL server. Can someone please help here ?

Re: SQL server connection issue

rommy — Sun, 16 Feb 2020 15:17:26 GMT

Appreciate if someone can guide me on this !

Re: SQL server connection issue

Anonymous — Mon, 17 Feb 2020 05:36:25 GMT

@rommy wrote:

Hi All,

I am trying to connect to sql server and having an issue to connect. I can log into sql server using same user id with SSMS but not able to establish connection with Talend connection. TCP IP port is already enabled for SQL server. McDVOICE Can someone please help here ?

I have exactly the same problem. Did anyone get a suggestion?

Re: SQL server connection issue

Anonymous — Tue, 18 Feb 2020 12:48:40 GMT

Try restarting your SQL SERVER from services.

Re: SQL server connection issue

rommy — Sat, 25 Jul 2020 23:07:47 GMT

I know I am little late to post the answer but posting it here for benefit of everyone who would face the issue, To fix the problem , I had to download the driver from Microsoft and plugin with Talend and it worked.