You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » How to connect to SQL Server 2010
#1 2011-11-07 21:42:29
- mashah
- Member
- Registered: 2011-06-26
- Posts: 29
How to connect to SQL Server 2010
Hi, All,
I tried to connect SQL Server 2010 database, but I am not able to connect.
I am getting error : "connection failure. You must change the Database settings."
Although all the settings including server name, port, credentials, are correct.
also port 1433 is running and also default port in TCP/IP settings.
Can any one please help me? All the posts are related to 2005 only. There is no post regarding 2010.
I appreciate your help.
Regards,
Manan Shah
Offline
#2 2011-11-08 03:57:02
Re: How to connect to SQL Server 2010
Hi Manan,
I might just be a library issue, where the java library for SQL Server included with Talend is not compatible with SQL Server 2010. Try to get the last driver for SQL Server 2010, drop it into the lib folder of the Studio, and see if it works.
Vincent Galopin
US Pre-Sales Consultant
Talend US
Offline
#3 2012-01-06 17:25:42
- nickd_nwea
- Member
- Registered: 2009-05-28
- Posts: 24
Re: How to connect to SQL Server 2010
What is SQL Server 2010?
Did you mean SQL Server 2012 RC? I think the driver in Talend is generic enough that you should be able to connect. Make sure your server protocol is enabled and if this is an instance name installed, specify it correctly in the db connection settings.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Quality and Talend Enterprise Data Quality » Configuration, usage and feedback
- » How to connect to SQL Server 2010