Re: [resolved] connection with sqlserver 2008 R2

Hi Please go to check that: 1. The server name is misspelled or the port number is incorrect. 2. SQL Server is not configured to use TCP/IP. Either enable TCP/IP from SQL Server's Network Utility app or have jTDS connect via named pipes (see the URL format for information on how to do this). 3. There is a firewall blocking port 1433 on the server.To check whether TCP/IP is enabled and the port is not blocked you can use "telnet <server_host> 1433". Until telnet doesn't connect, jTDS won't either. If you can't figure out why, ask your network administrator for help.Aslo, have a try the sql server authentication and use the ip replace server name.Best regardsshong

----------------------------------------------------------Talend | Data Agility for Modern Business

Re: [resolved] connection with sqlserver 2008 R2

thanks Shong,- for the server name and the the port 1433 are working well, sql is connected on that port and the server name is (local)- about ... jTds via named pipes.. I don't know much about it - telnet < ... > 1433 it works.

Re: [resolved] connection with sqlserver 2008 R2

thanks Shong,- for the server name and the the port 1433 are working well, sql is connected on that port and the server name is (local)- about ... jTds via named pipes.. I don't know much about it - telnet < ... > 1433 it works.

connect SQL Server with name (local) mean - You are connect from same machine (think from studio?)is Talend Also on same machine?if not You must open Management Utility in SQL Server and check for Server Networks -> tcp/ip - what network interfaces enabled?Even if You are select all - better do it manually and enable EachSame with FireWall - connect to server (local) not describe nothing about FireWall, You must be sure it open for connect from Outside