The Definitive Guide to Data Quality
Hi there. This could be simple but I cannot get it. How do you connect to SQL Server using Windows Authentication? It looks like I Profiler wants me to use SQL Server authentication only... Am I missing something? Thanks.
did you try to connect without setting a login and password?
I have found a reply on this forum: Currently SQL Server 2008 Windows Authentication is not supported.
I am on Windows 7 64 bit/SQL Server 2008 R2. I tried both 32 bit ODBC as well the 64-bit Native Driver.
I'm trying to connect to MS SQL Server 2008 via the DB Connections form in Talend DQ Version 5.0.2.r78237.
I first tried selecting MS SQL Server, MS SQL Server 2005/2008 as well as ODBC in the DB type and none of these options work. ODBC connection tests correctly.
I tried both Windows and SQL Server credentials but neither functions. I tried moving the ntmauth.dll to C:\Program Files (x86)\Java\jre6\bin but that does not work.
The DB Connections functionality allows me to connect to the same DB on TOS - MDM and TOS Data Integration but not with DQ.
Any advice would be welcome.