Hello I have installed SQL Server 2005 in localhost on my computer. I've tried to parameter an Db Connections but Talend can not initiate the connection with SQL Server. Also, when I define an connection with odbc, I made it working with a dynamic port, and I can insert data on the database with the generic components. I saw that odbc can not be connect with SQL Server if i define the port with the default value 1433. I need to use the MS SQL Server component for some option like create table, so does someone can help me to set the good parameter for SQL Server 2005. Thank you Tibal
I use SQL Server 2005 without a problem and without the need for ODBC. Check the configuration settings in the SQL Server Connection Manager, make sure the TCP/IP protocol is enabled and check the Client Protocols > TCP/IP > Default Port.
Hi All,
I am using talend open studio but when i create the MS SQL Server connection then talend gives me
error "host name is not found". My sql server 2005 name is : "SSS\SQLEXPRESS" and when i
filled this name in host name so error is coming "Connection failure. You must change the Database Settings.
Unknown server host name 'SSS\SQLEXPRESS'.
".
plz solve my issue .
Thanks,
SSS
Email : syed2uk@gmail.com
I am having this same problem: TOS attempts to connect, and the error message is "java.sql.SQLException:Network Error IOException: connection refused: connect". I have validated the SQL Server configuration and the connect string appears to be correct. I have attempted to connect with both tMSSqlConnection (for which I can't find any documentation) and Metadata/Db Connections/Create Connection. Is this stuff documented anywhere?
Hi, I'm not sure if you are still struggling with this. In my case I discovered I had to use SQL Login Authentication (as opposed to Windows Authentication). So here's my steps: 1. Create/Make sure I had a valid SQL Login with Log permissions on SQLServer and enough permission on the Dabatase I was trying to connect to. 2. Make sure that SQL Server was configure to accept Windows and SQL Server authentication 3. Test connecting to you Server/Database using the login you provided. 4. Then use same credentials/details on the Talend DI Connection Window. Good luck guys, I'm still a newbie on talend
Hi its Ibran,
can anyone tell how to connect to mssql from talend i am getting
impossible to initialize the connection error please please help me..
my database settings in talend are
DB Type - Microsoft SQL Server
login - myusername
password - mypassword
server - localhost
port - 1433
database - myDatabaseName
schema - (blank)
Additional parameters - instance=SQLEXPRESS
and in sql server i have enable the tcp/ip port and default port is 1433
